Board index » delphi » fastest method to insert new records

Leonid Abelev

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

fastest method to insert new records

I need to import a data from a text file to SQL Server 7.0 table. Using
TADOTable and append-insert methods(with batch update) is to slow.

How can I efficient insert new records in the table ?

servus L.A.

 
Alexandre Torre

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:fastest method to insert new records


I don't know if is possible in your case, but a good method to import text
files to SQL 7.0 is using BCP.

Alexandre Torres

Leonid Abelev escreveu na mensagem <8a5uo1$7...@bornews.borland.com>...

Quote
>I need to import a data from a text file to SQL Server 7.0 table. Using
>TADOTable and append-insert methods(with batch update) is to slow.

>How can I efficient insert new records in the table ?

>servus L.A.

Leonid Abele

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:fastest method to insert new records


Quote
> I don't know if is possible in your case, but a good method to import text
> files to SQL 7.0 is using BCP.

> Alexandre Torres

> >I need to import a data from a text file to SQL Server 7.0 table. Using
> >TADOTable and append-insert methods(with batch update) is to slow.

> >How can I efficient insert new records in the table ?

What do you mean with BCP ? Because of complex logic of the import, I cann't
use the the standard import  mechanismes.

servus L.A.

Alain Quesne

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:fastest method to insert new records


I would suggest using import packages on SQL Server. They are very fast and
very flexible. You can schedule them to run automatically at a determined
interval, if you plan on importing from the same file periodically.

--

Alain Quesnel
cinqsanss...@compuserve.com

-----

Quote
Leonid Abelev <abe...@earthling.net> wrote in message

news:8a5uo1$7095@bornews.borland.com...
Quote
> I need to import a data from a text file to SQL Server 7.0 table. Using
> TADOTable and append-insert methods(with batch update) is to slow.

> How can I efficient insert new records in the table ?

> servus L.A.

Other Threads

1. Record Cloning or Insert New Record using data from currently selected record

2. copying data from one record to the next when inserting a new record

3. Fastest Method of Inserting

4. Master/Detail w/SQL Server shows all detail records when inserting a new master record

5. What is faster on TTable (Insert or Edit method)

6. What is faster Insert or Append method.

7. Record Hidden after insert a new record

8. Retrieve ADO records faster than with the .Next method

9. fast method to update records ?

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