Hi, I wender if you ever have experienced this kind of problem. In fact, I used to create a database which contains about 1.5 Millions records.
The problem is, when I do this on : Linux 2.6.9-34.ELsmp #1 SMP Sun Mar 19 13:54:02 CST 2006 i686 i686 i386 GNU/Linux it takes less than 10 minutes However when, I do it on : Linux 2.6.18-53.el5 #1 SMP Mon Nov 12 02:14:55 EST 2007 x86_64 x86_64 x86_64 GNU/Linux it takes about 2 hours ?!!!! which is abnormal !!! I observed that the difference between these two cases is that the CPU is well used (about 80 % ) in the first configuration. But in the second configuration, the CPU usage is very slow (about 5%) !!!! By the way, the second configuration uses a newer material than the first one do you have any ideas ?! thank you, _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users