*** 674,682 **** have bench Table with million records. 10 fields of all types. 100MB size. Next query "SELECT DISTINCT * From T1" Valentina do in 1.7 seconds, SqlLite in 280 seconds. Difference 180 times. Or query: "SELECT * FROM T1 ORDER BY fld_byte, fld_varchar Desc" Valentina do in 1.99 seconds, SqlLite in 115 ! seconds. Difference 55 times. And this is just sigle table queries. I do not mention joins on 3-5-7 ! tables with, with GROUP BY, HAVING, ... And more. If to make database in 10 million records, so db ! grow to 1Gb the you will see even better Valentina win. If you want get information about real production power then just go to their users testimonials page and read quotes starting from 1998 year it seems. --- 674,682 ---- have bench Table with million records. 10 fields of all types. 100MB size. Next query "SELECT DISTINCT * From T1" Valentina do in 1.7 seconds, SqlLite in 280 seconds. Difference 180 times. Or query: "SELECT * FROM T1 ORDER BY fld_byte, fld_varchar Desc" Valentina do in 1.99 seconds, SqlLite in 115 ! seconds. Difference 55 times. This is just single table queries. I do not mention joins on 3-5-7 ! tables with, with GROUP BY, HAVING, ... More, if to make database in 10 million records, so db ! grow to 1Gb the you will see even better Valentina wins. If you want get information about real production power then just go to their users testimonials page and read quotes starting from 1998 year it seems.
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|