Mark
Bulk loading is not really the domain of ADO but have you considered,
providing you don't have duplicate problems (i.e you are appending)
1/ Taking your input file, extracting the metadata from the target table and
create insert values statement
INSERT INTO Dest (field names)
VALUES (insert values here)
2/ As above but use parameters for the values
You could also try (using a Client/static/BatchOpt) if you are using an
identity field
TADODataSet.Recordset.Properties['Update Resync'].Value := 0;
// 0 = none, 1 = AutoInc (default), 2 = Conflicts, 4 = Updates
// 8 = Inserts, 15 = Allsetting
HTH
Neven
----- Original Message -----
From: Mark Derricutt <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Thursday, 31 August 2000 09:32
Subject: Re: [DUG]: To Bind or Not to Bind
> On Thu, 31 Aug 2000, Neven MacEwan wrote:
>
> > For scalable apps I use Client/Static/BatchOpt ADO (on MSSQL et al)
> > and for small Server/Keyset/Opt (on JET) both work well - The main
>
> How do you do the batchopt stuff? In one of my apps I need to regularly
> post 5-6k records from an ascii import file and find that doing an insert
> for each is slow as heck, doing a TADOTable append/post was quicker, but
> still rather slow, what techniques are there to improve the speed of these
> large import type operations?
>
> --
> "We don't guarantee anything except that it will take up disk space..."
> Apache 2.0alpha5 Disclaimer
>
> Now Playing: utopik - Good evening
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"