Re: Server Cursor with Joined Tables

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

Date: Fri, 26 Mar 2004 13:46:05 -0500

Thanks for the tip, I tried that but I still seem to get that problem. I'm
doing an inner join between the two tables, not sure if that is different
than the union?

"Martin Plourde" <martinplourde@glcp.qc.ca> wrote in message
news:40638955@newsgroups.borland.com...
> Hi,
>
> I've done it with a view on SQL Server. In my view I made some thing like
> « select * from tableA union select * from tableB » and in my application
I
> used « select * from view »
>
> Martin
>
> "Richard" <abbeyroad@mindspring.com> a écrit dans le message de
> news:40631e65@newsgroups.borland.com...
> > 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)