Server Cursor with Joined Tables

From: Richard (abbeyroad_at_mindspring.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 13:01:11 -0500

Hello,

I have two tables, Table A and table B, that both have primary keys defined
on them. When I return a result set for each table individually, I am able
to use a server side cursor. When I try to join table A with table B for a
single result set, it comes back as a client cursor even if I specify a
server cursor. This is a problem because the result set is pretty big, and
starts to take up memory on the client machine. I've tried defining a
relationship between the two tables but the same problem exists. Does
anyone know how to join the two tables and have it still be a server side
cursor? Thanks!

Richard

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: Client Cursor oder Server Cursor?
    ... > Summa summarum dürfte es jemanden, der seine Programmierung auf ADO die ... So erstellt der SQL Server ein internes ... > Während der Client Cursor für den Abruf ein ForwardOnly/ReadOnly ...
    (microsoft.public.de.sqlserver)
  • 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: ADO server side cursor sloooow
    ... Using the ODBC driver my tests show that both client and server side ... forward only server side cursor is faster than a client side cursor as ... requiring over 1000 trips over the network. ...
    (comp.databases.btrieve)