Re: ADO server side cursor sloooow

Bill Bach wrote:

> A client side cursor will stream the data in bulk down the the
> workstation. When you need the ENTIRE data set sent across the line,
> you should use the Client-Side Cursor. Server-side cursors are much
> faster when only a small portion of the data is needed.
> Goldstar Software Inc.
> Building on Btrieve(R) for the Future(SM)
> Bill Bach

Thanks for your answer Bill. I am an experienced database developer and
I understand the basics of ADO. My problem is that if I run exactly the
same SQL statement (which selects 1,000 rows from a much larger table)
it is three times faster with a client side cursor than with a read
only forward only server side cursor.

This makes no sense because the client side cursor must dynamically
allocate memory to hold the data then load the data into that memory on
the client.

Try the same test with SQL Server and the server side cursor is faster
as I would expect. I do not understand why the server side cursor is
slower with Pervasive 9. Is there anything I can do to improve the
performance of a server side cursor?

--
..Bill.

.

Relevant Pages

  • 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: ... after Opening a record set
    ... I will point out that as long as one can live with a client cursor (all records retrieved to the client machine during the ... it is better to loop based on EOF unless there is a compelling reason to do otherwise. ... >> It is not a reliable method of retrieving records from a recordset. ...
    (microsoft.public.vb.database.ado)
  • Re: ORATCL help needed!
    ... set cursor ... Wow, An Oratcl 3.3. ... It is coded with the the OCI layer released with Oracle ... Oracle instant client is available for many many platforms, ...
    (comp.lang.tcl)
  • Re: cancel ADO2.8 asynchron queries over WAN, takes long time
    ... >> the .open method first creates the recordset at the server. ... I use clientside cursor to minimalize the traffic... ... You do not want to be managing any types of cursors on the client ... > doing so over a slow link is a bad choice. ...
    (microsoft.public.sqlserver.programming)
  • 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)