Welcome to our list Ruslan :-)
I'm no database expert, though you can find plenty of them on the SQLite open source website: www.sqlite.org
I challenge you to post your benchmarks there if you're serious about getting a response. There you'll find more of the 'war' I believe you're searching for.
Though, I can point to some speed facts about the program:
From the SQLite.org home page:
"A series of tests were run to measure the relative performance of SQLite 2.7.6, PostgreSQL 7.1.3, and MySQL 3.23.41. The following are general conclusions drawn from these experiments:
*SQLite 2.7.6 is significantly faster (sometimes as much as 10 or 20 times faster) than the default PostgreSQL 7.1.3 installation on RedHat 7.2 for most common operations.
*SQLite 2.7.6 is often faster (sometimes more than twice as fast) than MySQL 3.23.41 for most common operations.
*SQLite does not execute CREATE INDEX or DROP TABLE as fast as the other databases. But this is not seen as a problem because those are infrequent operations.
*SQLite works best if you group multiple operations together into a single transaction."
I believe the absense of Valentina benchmarks only indicates they chose to compare against some of the more popular databases, and ones who's source code was 'open' for all to see.
Also, I notice you make mention of 'locking' records. If you use this trick for SQLite, you are adding needless cycles to the benchmark. The SQLite database is a 'single-user' database, and has no need for locking records in the Revolution environment. I would think you, as a proficient database expert (unlike I) would of course know this?
A last challenge: Why don't you create a great Demo for Valentina in Revolution? I believe if you do, you may find you can increase your sales and help out our community. If you're interested in viewing ours, please see:
http://www.altuit.com/webs/altuit2/altSQLiteCover/default.htm
Also, I noticed you're still selling Valentina for Revolution 1.1.1. We're now up to version 2.5.1. I know your users are eager for you to update!
And at $299 for both Mac and PC, that would make it 3X as expensive as altSQLite. And of course, altSQLite also includes Linux.
Have a nice day,
Chipp Walters Altuit, Inc.
Ruslan Zasukhin wrote:
:-) I think this is little a myth that SQL Lite is fast.
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
