From 19985dbb8c0aa66dc4bf7905abc1148de909097d Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Anton=20Luka=20=C5=A0ijanec?= <anton@sijanec.eu>
Date: Tue, 11 Jan 2022 12:35:47 +0100
Subject: prvi-commit

---
 utils/testQuerySpeed.php | 53 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 53 insertions(+)
 create mode 100644 utils/testQuerySpeed.php

(limited to 'utils/testQuerySpeed.php')

diff --git a/utils/testQuerySpeed.php b/utils/testQuerySpeed.php
new file mode 100644
index 0000000..6082864
--- /dev/null
+++ b/utils/testQuerySpeed.php
@@ -0,0 +1,53 @@
+<?php
+
+/**
+ * Test speed of query
+ * Uroš Podkrižnik 21.12.2017
+ */
+class testQuerySpeed {
+
+    function __construct() {
+        
+    }
+
+    function test($sql_query = "SELECT id FROM srv_anketa", $loopnum = 1000) {
+        $microa = 0;
+        $microo = 0;
+        $microni = 0;
+        $micron = 0;
+        for ($i = 0; $i < $loopnum; $i++) {
+            $starta = microtime(true);
+            $sql_array = sisplet_query($sql_query, 'array');
+            foreach ($sql_array as $pair)
+                $res = $pair;
+            $enda = microtime(true);
+            $microa += ($enda - $starta);
+
+            $starto = microtime(true);
+            $sql_obj = sisplet_query($sql_query, 'obj');
+            foreach ($sql_obj as $pair)
+                $res = $pair;
+            $endo = microtime(true);
+            $microo += ($endo - $starto);
+
+            $startn = microtime(true);
+            $sql = sisplet_query($sql_query);
+            while ($row = mysqli_fetch_assoc($sql))
+                $res = $row;
+            $endn = microtime(true);
+            $microni += ($endn - $startn);
+
+            $startn = microtime(true);
+            $sql = sisplet_query($sql_query);
+            while ($row = mysqli_fetch_assoc($sql))
+                $res = $row;
+            $endn = microtime(true);
+            $micron += ($endn - $startn);
+        }
+        error_log('$microa ' . $microa);
+        error_log('$microo ' . $microo);
+        error_log('$microni ' . $microni);
+        error_log('$micron ' . $micron);
+    }
+
+}
-- 
cgit v1.2.3