Adding records

[Damon Pillinger]

Hi Guys,

What is the fastest way to add records?

Val 2.1
RB 5.5.5 Win

I am using SQL INSERT INTO at the moment and can get 8.12 seconds for
10,000 records but wondered if there is a faster way?

Also is there a "Begin transaction" as this seems to speed up SQLite
significantly.

TA
Best regards

Damon L. Pillinger
Director Daisychain EDi
Suite 3
4 Winston Court
Moorabbin 3189
Phone : +61 3 9532 1220
Fax : +61 3 9532 1280