Hello Serge,
On Wed, March 1, 2006 16:11, Serge Semashko wrote:
...
> I'm in no way a database expert, but the tests on the benchmarking page
> seem a bit trivial and looks like they only test database API (data
> fetching throughoutput), but not the engine performance. I would like to
> see some benchmarks involving really huge databases and complicated
> queries and wonder if the results will be similar to those I have
> observed...
those benchmarks target the primary use of SQLite, which isn't the same as
other database engines, as perfectly explained by DRH himself. Even though its
performances and rich feature list might make us forget which is the intended
use of SQLite, we must remember that it is firt of all a compact, lightweight,
excellent *embedded* database engine. SQLite simply isn't designed for huge
databases and complicated queries, even though most of the times it is able to
cope with both, being at least a bit more than an fopen() replacement. Don't
be shy Dr. Hipp! :)
Bye,
--
Denis Sbragion
InfoTecna
Tel: +39 0362 805396, Fax: +39 0362 805404
URL: http://www.infotecna.it
