On 7/17/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
Hello to everybody...!!!
I was using my old notebook the weekend, and i was doing some programs in C
to try SQLite performance, and I am happy, because i could insert
4.000.000rows in 10 minutes in my old notebook( Pentium II 400 MHZ 128
M.RAM). Thank for everybody who made it possible (share this coll DB), that
was on my Windows XP... then I try on my Linux FC4, i could insert
8.000.000 of row in 15 minutes.. that's great!!!! faster that every DB
engine that I know.
bulk inserts are much faster if you delete the indexes, insert the data, then
create the indexes. Did you try that?
And with the select it took about 10 ms to select 50 rows of 8.000.000 (
that's very cool!)
I am wondering if it will have a better performance if i split every index
and table into a file, i know that i will loose the LITE concept, but i am
wondering if it will have a better performance...
more RAM and higher rotational speed on the hard disks are your best bet.
