Re: Populate dataset with text file

Dan,

> Actually Bill, I have been working on this issue for 2 months now.
> I can add each record one by one, even tried smiImport component.
You have the bad perfomance on dataset-level (to insert the records to
table), not in text file parser.

I suggest:
1. don't use the cached update mode (so client app will not create the own
cache)
2. disable all events for dataset and fields (if you use any)
3. disable all indexes/constraints/triggers/checks
4. commit changes every 1000-2000 records
5. try to load a data in exclusive mode when any user'll not have an access
to same data (no read, no write)
6. you may generate the SQL-script with INSERT-statements and execute
instead append records to TDataset
7. don't run an application within Delphi/C++Builder IDE (especially if you
have a few breakpoints for debug)

--
With best regards, Mike Shkolnik
EMail: mshkolnik@xxxxxxxxxxxxx
http://www.scalabium.com


.