fastest way to insert 100 records into a table

Willi Kühni

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

fastest way to insert 100 records into a table

D3,Sybase SQL Anywhwere with ODBC, TQuery
I have a stringgrid with about 100 items. With each one of this items I have
to generate a record in a table.
What's the fastest way?
Now I do it this way and it takes almost one second for a record:
In a loop a make:
TQuery.Append;
I am sure, there are better and faster ways.
Thanks for any tips.
Willi
wkueh...@bluewin.ch

George Aligiani

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:fastest way to insert 100 records into a table

By using cached updates, all the updates are sent at the same time, instead
of doing each one individually.

George Aligianis

Other Threads

1. inserting data with tquery stops after 100 records

2. Insert 100 000 records

3. Why does Round(6.125*100)*100=6.12?

4. Selecting 100+ records @ a time from a database

5. get only 100 record always with sql?

6. breaking the 100 limit on record locking via LocalSQL

7. SQL q: Request limited dataset = (100 records?)

8. Copy 100 records in SQL ?

9. How to insert a record fast???????????

10. Tquery becomes faster after 51st record inserted?!?