On 14 Jul 2010, at 11:55am, Werner Smit wrote:

> ps. When I started with sqlite it took 500 minutes to save the 1 million
> records.
> I've got it down to just less than 200 minutes with current settings.
> Clarion does it in between 100 and 200 minutes.

Do you have any indexes defined ?  It can be considerably faster to DROP the 
indexes before importing all that data, then remake them afterwards.  Of course 
you may already be doing this.

sqlite-users mailing list

Reply via email to