Revize abaa5f46

Experiment with database

backend/src/main/java/cz/zcu/kiv/backendapi/catalog/CatalogController.java

@@ -44 +44 @@
     @GetMapping("")
     @Operation(summary = "returns catalog items based on filter")
     public ResponseEntity<List<CatalogItemDto>> getCatalog(@RequestParam(defaultValue = "") String name, @RequestParam(defaultValue = "") String country, @RequestParam(defaultValue = "") String type) {
-        return new ResponseEntity<>(catalogService.getCatalog(name, country, type), HttpStatus.OK);
+
+        List<CatalogItemDto> catalog = null;
+        long start = System.currentTimeMillis();
+        catalog = catalogService.getCatalog3(name, country, type);
+        System.out.println(catalog.size());
+        long time1 = System.currentTimeMillis() - start;
+        start = System.currentTimeMillis();
+        catalog = catalogService.getCatalog2(name, country, type);
+        System.out.println(catalog.size());
+
+        long time2 = System.currentTimeMillis() - start;
+        start = System.currentTimeMillis();
+        catalog = catalogService.getCatalog(name, country, type);
+        System.out.println(catalog.size());
+
+        long time3 = System.currentTimeMillis() - start;
+        System.out.println(time1 + "\t" + time2 + "\t" + time3);
+        return new ResponseEntity<>(catalog, HttpStatus.OK);
     }
 
     /**