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

>> ps. When I started with sqlite it took 500 minutes to save the 1
>> 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.

Nope, no index only a primary key..
  (Pin          Integer
  ,IDNumber     Char(13)
  ,Name         VarChar(35)
  ,PayPeriod    Integer
  ,PaypointCode VarChar(6)
  ,RegionCode   VarChar(6)
  ,ProxyPin     Integer

The table I'm using for test purpose look like above.

Everything in this email and its attachments relating to the official business 
of Face Technologies is proprietary to Face Technologies. It is confidential, 
legally privileged and protected by law. The person addressed in the email is 
the sole authorised recipient. Any unauthorized dissemination or copying of 
this e-mail (or any attachment to this e-mail) or the wrongful disclosure of 
the information herein contained is prohibited.

sqlite-users mailing list

Reply via email to