SQL-Server 2000 Client fetches all data
Hi experts,
I have two queries.
Opening query1: one record is fetched (but still thousends to come).
Stays open...
Opening query2: all records from query1 will be fetched (still thousends
of records). After all records of query1 were fetched, query2 opens its
cursor and one record is fetched.
This happens with BDE,ODBC and ADO.
Oracle and Informix doesnt fetch all data if a second cursor is going to
be opend.
How can i prevent SQL Server client to fetch all this data ?
Its a big problem if 100 users try to access addressdata and every
client fetches all records from the resultset. In addition this will
create a huge memory usage.
Setting ADO cursorlocation to UseServer will cause an error when
reaching the end of the result set.
D6 Enterprise, Updatepack 1,SQL-Server 2000, BDE 5.2
Regards,
Falko
?
