Re: Server Cursor with Joined Tables

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 03/26/04

  • Next message: Brian Bushay TeamB: "Re: Multiple-step Operations Generated Errors!" 
    Date: Thu, 25 Mar 2004 20:08:25 -0600

    >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?

    You don't tell us what database and Oledb driver you are using and that makes a
    difference. 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: Brian Bushay TeamB: "Re: Multiple-step Operations Generated Errors!"

    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)