Re: CursorLocation -> Scrollbar behavior


Thanks for replying,

What do you mean exactly?
Is the reason for the increase of speed, when using Server based cursors,
that the RecordNo is'nt exact. (RecordCount works ok)
Do you think the problem is in the driver, or is it the Access DB thats
simply not able to provide info.

Is this a common problem, or does is work with the SQL Server?

I would imagine that this is something other customers have experienced as
well.
Im already limiting a lot with WHERE clauses in the commandtext property.

Thanks
LC


"Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx> wrote in message
news:4422f550$1@xxxxxxxxxxxxxxxxxxxxxxxxx

For RecordNo OLEDB allows to return approximate value. Access may return
approximate value for RecordCount too. Both values are used by DBGrid. The
best solution for you is to use WHERE in command text and limit number of
rows returned for DBGrid.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"LC" <lc@xxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:44228e50$1@xxxxxxxxxxxxxxxxxxxxxxxxx

Hi,

Im using XP -> D7 -> ADO -> MSAccess.

The data in some of my customers DBs have grown, making DBGrids very
slow.
Wherefore I have changed the TADODataset.CursorLocation to clUseServer,
and now the data is presented a lot faster.

However, the scrollbar now works in like 3 steps, making it almost
impossible to use.
I guess this has to do with the fact, that the ADO cursor have no clue
where its located in the table, when the Cursorlocation is set to Server.

Does anybody no how to fix this?
Is there a way to set the CursorLocation to clUseServer for performance,
and still have a 'working' scrollbar in the DBGrid?


Thanks a lot
LC









.

Relevant Pages

  • Re: Download Speed
    ... out, under SQL Server, is server-sided,readonly,forwardonly. ... then you have no control on the RecordSet, you should get the ... get back Forward only, Readonly, Server Sided RecordSet, CacheSize = 1. ... Connection CursorLocation is Client-sided, you should get back Static, ...
    (microsoft.public.data.ado)
  • TADODataSet and Cursor Location
    ... What is the difference in the CursorLocation for the server or client ... I want connect to a local Access database and need to be able to use ...
    (borland.public.delphi.database.ado)
  • recordset
    ... what is the better way to open a Recordset and don't affect the memory ... Actually I use recorset with cursorlocation = cliente and cursortype ... =adOpenForwardOnly but my server memory goes up. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Download Speed
    ... location to server and I call my select statement directly ... The Connection "CursorLocation" is the default cursorlocation of a ... If you don't bother setting a "CursorLocation" for a RecordSet, ... "CursorLocation" is so that you can override what is the Connection default ...
    (microsoft.public.data.ado)