Re: ADO 2.7 performance
From: Stephen Howe (stephenPOINThoweATtns-globalPOINTcom)
Date: 12/30/04
- Next message: Stephen Howe: "Re: Key column information insufficient....ERROR"
- Previous message: Wilfried Mestdagh: "create access tables in C# at runtime"
- In reply to: Itai Gordon: "ADO 2.7 performance"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Dec 2004 12:54:25 -0000
> I'm tring to get 60,000 record via ADO2.7 SP1 from SQL2000. The results
are
> 11 sec. At the same time I get the same data via BDE5.1 at less than 6
sec.
> How can I improve the ADO performance
What language?
How are getting 60,000 records? Recordset?
If RecordSet is it Server-sided or Client-sided? LockType? CursorType?
If RecordSet is Server-sided, what is the CacheSize?
Thanks
Stephen Howe
- Next message: Stephen Howe: "Re: Key column information insufficient....ERROR"
- Previous message: Wilfried Mestdagh: "create access tables in C# at runtime"
- In reply to: Itai Gordon: "ADO 2.7 performance"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
