Re: Adding records is very slow.
- From: "Vitali Kalinin" <vitkalinin@xxxxxxxxx>
- Date: Thu, 25 Jan 2007 16:51:58 +0200
AFAIK fastest approach to append data into Access table would be to use
TADODataSet in tabledirect mode. Something like this:
ADataSet := TAdoDataSet.create(nil);
ADataSet.ConnectionString := getConnectionString;
ADataSet.CursorLocation := clUseServer;
ADataSet.CommandType := cmdTableDirect;
ADataSet.CommandText := 'MyTable';
ADataSet.Active := true;
.
- References:
- Adding records is very slow.
- From: Ugo
- Adding records is very slow.
- Prev by Date: Adding records is very slow.
- Next by Date: Re: Adding records is very slow.
- Previous by thread: Adding records is very slow.
- Next by thread: Re: Adding records is very slow.
- Index(es):
