Re: Populate dataset with text file

I would be very interested to know the time it takes for the 147,000
records if you comment out the code that actually inserts the row into
the database table. There are other ways to do the import that might be
faster.

Also, how are you adding the records to the table. ADO will be much
slower than the Advantage TDataSet components. The two possibilities
are a TAdsTable or a TAdsQuery using a parameterized insert statement.
I would expect the TAdsTable to be faster but I have not tested this.

--
Bill Todd (TeamB)
.

Relevant Pages

  • Re: Access DB for Multi-user
    ... > server will be much more reliable. ... > Bill Todd (TeamB) ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: [?] Howto create a generic ADO Search ?
    ... form would be to use ANSI standard SQL for the search. ... Bill Todd (TeamB) ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: types in TField
    ... You can try instantiating the field objects at design time and changing ... Bill Todd (TeamB) ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: ANN: CopyCat replicator demo available!
    ... tools group. ... Bill Todd (TeamB) ... Prev by Date: ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Indices and client data sets
    ... for the small number of records that CDS is intended to hold. ... Bill Todd (TeamB) ... > manually with TClientDataSet's AddIndex method? ...
    (borland.public.delphi.database.ado)