Michael Van Canneyt escreveu:
On Fri, 12 May 2006, Luiz Americo wrote:
I did more tests, all give comparable results: sqlite is very fast
for simple stuff.
Your results are comparable from one made without index published in
sqlite wiki, but when using index, according to the test, sqlite
compares to the other.
Obviously, I have created the same indexes in all 3 databases.
See: http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
And yes, I did all possible optimizations. Version 3 was used.
I have a lot of experience with databases of all kinds, and I know
what to test for.
Please post the database schema, no of records, indexes, so i can
reproduce and publish in a site.
I'll send it in private if you want, but you don't have permission to
publish it.
(my contract with the journal's editor forbids that)
Please send it. I'll take a look if some easy optization can be done and
i'll return to you privately.
Luiz
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives