Re: ADO results set vs. BDE


"Bill Todd [TeamB]" <no@xxxxxx> wrote:
What is the problem you are trying to solve? In other words, why is
using a client side cursor and fetching the entire result set a problem?

It is difficult to suggest a solution without knowing exactly what
problem you are trying to solve.

--
Bill Todd (TeamB)

Well, the problem really is that our users are used to being able to perform a query that returns a large result set, but without having to wait around for all the results to be loaded. With the BDE, you could fetch a large results set a few records at a time. You wouldn't have to wait for all the results to be fetched first, which might take some time if there were a lot of results.

With ADO it seems that the entire result set must be fetched in one go, which could take a long time.

I know it would be preferable if we didn't fetch large result sets in the first place, but the BDE's behaviour was quite handy - e.g. if you accidentally did a wildcard search that pulled back a lot of results, you wouldn't have to wait. It would be great if this can be done in ADO too.
.

Relevant Pages

  • Re: ADO results set vs. BDE
    ... It would be great if this can be done in ADO too. ... TADODataSet with readonly forwardonly server side cursor. ... combination you could control fetching more precisely. ...
    (borland.public.delphi.database.ado)
  • Re: ADO results set vs. BDE
    ... using a client side cursor and fetching the entire result set a problem? ... Bill Todd (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: ADO server side cursor sloooow
    ... A client side cursor will stream the data in bulk down the the ... When you need the ENTIRE data set sent across the line, ... > Using PSQL 9.1 I am comparing the PDAC SQL components to ADO. ...
    (comp.databases.btrieve)
  • 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)