Changes between Version 50 and Version 51 of Caching

Timestamp:

11/10/25 02:40:32 (2 weeks ago)

Author:

222039

Comment:

--

Caching

@@ -394 +394 @@
 * '''<10%:''' 🟢 Добро, нормална фрагментација
 
-
-
-
-
+==== Row format експерименти
+
+{{{
+CREATE TABLE test_row_format_base AS
+SELECT 
+    flight_id,
+    airline_id,
+    flightno AS flight_number,
+    `from` AS departure_airport,
+    `to` AS arrival_airport,
+    departure AS departure_time,
+    arrival AS arrival_time,
+    REPEAT('X', 500) AS dummy_data 
+FROM flight
+LIMIT 10000;
+
+-- Test 1: DYNAMIC 
+CREATE TABLE test_dynamic 
+ROW_FORMAT=DYNAMIC 
+AS SELECT * FROM test_row_format_base;
+
+-- Test 2: COMPACT
+CREATE TABLE test_compact 
+ROW_FORMAT=COMPACT 
+AS SELECT * FROM test_row_format_base;
+
+-- Test 3: COMPRESSED (со различни compression levels)
+CREATE TABLE test_compressed_1 
+ROW_FORMAT=COMPRESSED 
+KEY_BLOCK_SIZE=8 
+AS SELECT * FROM test_row_format_base;
+
+CREATE TABLE test_compressed_2 
+ROW_FORMAT=COMPRESSED 
+KEY_BLOCK_SIZE=4 
+AS SELECT * FROM test_row_format_base;
+}}}
  
 
 
+ 
+
+