Changes between Version 52 and Version 53 of Caching

Timestamp:

11/10/25 02:48:44 (2 weeks ago)

Author:

222039

Comment:

--

Caching

@@ -434 +434 @@
 '''Споредба:'''
 
+[[Image
+
+
+'''Performance test:'''
+{{{
+-- DYNAMIC
+SET @start = NOW(6);
+SELECT COUNT(*), AVG(LENGTH(dummy_data)) FROM test_dynamic;
+SET @dynamic_time = TIMESTAMPDIFF(MICROSECOND, @start, NOW(6));
+
+-- COMPACT
+SET @start = NOW(6);
+SELECT COUNT(*), AVG(LENGTH(dummy_data)) FROM test_compact;
+SET @compact_time = TIMESTAMPDIFF(MICROSECOND, @start, NOW(6));
+
+-- COMPRESSED_1 
+SET @start = NOW(6);
+SELECT COUNT(*), AVG(LENGTH(dummy_data)) FROM test_compressed_1;
+SET @compressed_1_time = TIMESTAMPDIFF(MICROSECOND, @start, NOW(6));
+
+-- COMPRESSED_2 
+SET @start = NOW(6);
+SELECT COUNT(*), AVG(LENGTH(dummy_data)) FROM test_compressed_2;
+SET @compressed_2_time = TIMESTAMPDIFF(MICROSECOND, @start, NOW(6));
+
+SELECT 
+    @dynamic_time AS 'DYNAMIC (μs)',
+    @compact_time AS 'COMPACT (μs)',
+    @compressed_1_time AS 'COMPRESSED_1 (μs)',
+    @compressed_2_time AS 'COMPRESSED_2 (μs)',
+    '---' AS '---',
+    ROUND((@compact_time / @dynamic_time) * 100, 2) AS 'Compact vs Dynamic %',
+    ROUND((@compressed_1_time / @dynamic_time) * 100, 2) AS 'Compressed_1 vs Dynamic %',
+    ROUND((@compressed_2_time / @dynamic_time) * 100, 2) AS 'Compressed_2 vs Dynamic %',
+    ROUND((@compressed_1_time / @compressed_2_time) * 100, 2) AS 'Compressed_1 vs Compressed_2 %';
+}}}
+
+[[Image(
+