🚀 go-pugleaf

Hi Andre,

Some time ago I shared your experience in working with ADO and C++-Builder.
It took me more than a whole day to find some settings which would give me
any confidence in keeping on using ADO.

For now I'm using the following rules (Say we got a TADODataSet and a
TDBGrid):
- When you have to scroll through a table with lots of records (say
100.000+) use CursorLocation clUseServer and CursorType ctKeyset. The first
execution of the query then is rather quick. The speed of scrolling (from
top till bottom) is a bit lower.
- When you have to work with a small set of records, but you're using joins,
lookup- or calculated fields then clUseServer can get slow. With setting
CusorLocation to clUseClient and CursorType to ctStatic the scrolling and
showing of lookups will be a lot faster. A drawback can be the lower speed
of the first execution of the query (you have to wait some time to see the
first data appear in the grid).
- When you're using several TADODataSets (or TADOTables) at the same time,
let them share the same TADOConnection so the connection has to be
initialised only once and your settings are conveniently centralized.

Maybe this will help you,

HTH
Ronald
--
----------------------------------------------------------------------------
----------------
CodeFit Applications: www.codefit.nl (Dutch spoken)
----------------------------------------------------------------------------
----------------

"Andre Venter" <andre@hacker.co.NOSPAM.za> schreef in bericht
news:3cd0595d_1@dnews...
> Im currently using TADOQuery and TADOTable for using access databases,
> and finding the speed a less than satisfactory... i'm know it can be alot
> faster, I have used access in VB before and that worked very efficiently.
>
> Does anybody have any comments, or suggestions on how to speed this up?
> I can only presume using another method of using access databases?
>
>