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.
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... Thank to Dr. Hipp and everyone who did it possible! Cesar Rodas
