[ZODB-Dev] some interesting benchmarks
Jean Jordaan
jean.jordaan at gmail.com
Mon Sep 17 04:59:11 EDT 2007
Hi Martijn,
Thanks for the references. A colleague of mine had some comments, I'm
forwarding them in case any list members would like to take up the
benchmarking gauntlet or further qualify the linked benchmarks: how far
can we depend on them?
Ashok writes:
"""
I can see a couple of areas, where that query he has used for inserting
data (in the context of Sqlite) could be speeded up.... like... the
usage of executeMany... I have used it before and for various reasons
the performance of that vs a looping insert is much slower.....
And the other thing is ...the performance of a low footprint db like
Sqlite3 can be misleading... since the indexing mechanisms are
rudimentary when compared to something like Postgres or Oracle....
which means once you reach a certain volume of data performance will
most certainly drop off steeply....
.. and the benchmark is really for insertion of data.... I would be
interested in things like indexed retrieval of data...
"""
--
jean . .. .... //\\\oo///\\
More information about the ZODB-Dev
mailing list