Re: Cannot open Access table with ADO or BDE/ODBC


"Doug Stephens" <dougstephens@xxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:446c8e13$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Vitali Kalinin wrote:
How many records in this table, are there any blobs, do you
experience same problem with server side cursor?

280,000 records No blobs. Not tried with server side cursor.
Not even really sure what that is:) But there is no "server" in this
scenario, unless you call JET a server.
Take a look at CursoLocation property of TADODataSet in online help. 280.000
records is pretty much, if you will open them with clUseClient, ctStatic
cursor (default settings of TADODataSet) it could take a lot of time and
memory, since all this records will be fetched in memory.


.

Relevant Pages

  • Re: VB connection to SQL server
    ... > the client machine begins to lose its relevance and accuracy as soon as it ... > aware that the data is probably out of date, a client sided cursor might ... > design minimises the possibility that records will have changed in the ... >> The Database server is in the office, and people use the Vb program from ...
    (microsoft.public.vb.database)
  • Re: Prepared sql generates "Insufficient memory available.." erro
    ... Also, QA only returns a Firehouse, client-side cursor. ... There should be no need for an application to create a Server-side, API ... you said you had 3 GB of memory on the server. ...
    (microsoft.public.sqlserver.server)
  • Re: Huge memory comsumption of ADODB Connection object
    ... unless the cursor is returning data to the client* I don't see ... I suppose this could cause some extra memory ... Is there a similar behavior in Sybase? ... Server was originally based on that rdbms, so there very well may be. ...
    (microsoft.public.data.ado)
  • Re: VB connection to SQL server
    ... "Chris Barber" wrote in message ... > recordsets (client side cursor) to allow you to persist the recordsets to ... aware that the data is probably out of date, a client sided cursor might fit ... That is because the SELECT statement is executed on the server and the data ...
    (microsoft.public.vb.database)
  • Re: Accessing A Large MS SQL Table Over ADO Components
    ... Client-side cursor fetches all rows, ... Because I had some performance loss when I set it up to Server ... Server-side cursor does not fetch all rows to client, so if server is on the ... > If we want to display the data on a readonly grid wich component is the ...
    (borland.public.delphi.database.ado)