| View previous topic :: View next topic |
| Author |
Message |
Coville Philippe
Guest
|
 Posted: Thu Dec 18, 2003 8:15 pm Post subject: TADO performance |
 |
|
I ma doing a complexe update row by row on a large table with 20 000
records. I am using an TADOTable object connected to an Access 2000
database.
The update is 5 times slower than with TTable on Paradow files. What can I
do to improve the performance.
Thanks for your help
P. Coville
France
|
|
| Back to top |
|
 |
Coville Philippe
Guest
|
| Posted: Sun Dec 21, 2003 11:26 pm Post subject: Re: TADO performance |
|
|
I have done what you told me but I haven't seen any improvment.
Any other idea?
Thanks for your help
"Brian Bushay TeamB" <BBushay (AT) Nmpls (DOT) com> a écrit dans le message de news:
[email]j6q4uvkdpaochtrhl3umbgfgplqo91tuj3 (AT) 4ax (DOT) com[/email]...
| Quote: |
I ma doing a complexe update row by row on a large table with 20 000
records. I am using an TADOTable object connected to an Access 2000
database.
The update is 5 times slower than with TTable on Paradow files. What can
I
do to improve the performance.
Set TableDirect to true.
DisableControls
Lastly remember there are problems associated with using Paradox tables
but slow
performance isn't one of them
--
Brian Bushay (TeamB)
[email]Bbushay (AT) NMPLS (DOT) com[/email]
|
|
|
| Back to top |
|
|
Emmanuel Guillot
Guest
|
| Posted: Fri Dec 26, 2003 12:52 pm Post subject: Re: TADO performance |
|
|
bonjour regarde ce code tu devrais ameliorer les performances.
var
rs : _Recordset;
begin
rs := AdoInt.CoRecordset.Create;
rs.CursorLocation := adUseClient;
rs.CursorType := adOpenForwardOnly;
rs.LockType := adLockReadOnly;
Q1.CommandText := 'select champ from matable';
rs := Q1.Execute;
rs.MoveFirst;
while not rs.EOF do
begin
// Do Something
rs.MoveNext;
end;
rs := nil;
end;
Emmanuel.
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
