Grouping rows - performance

KrzysztofDusko / JustyBase

SQL editor/IDE

GNU General Public License v3.0

10 stars 0 forks source link

Grouping rows - performance #300

Closed KrzysztofDusko closed 5 months ago

KrzysztofDusko commented 5 months ago

Grouping rows in JustyBase with many distinct values takes ages compared to JustyBaseLegacy. This should be way faster especially for first grouping level.

KrzysztofDusko commented 5 months ago

test code

SELECT random() FROM 
JUST_DATA..FACTPRODUCTINVENTORY 
ORDER BY  ROWID
LIMIT 40000

In Legacy grouping is instant in JustyBase takes few secounds on very fast CPU.