Re: TADOQuery, OnFilterRecord and Locate


"Kevin Frevert" <kevin@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:44e1c549$1@xxxxxxxxxxxxxxxxxxxxxxxxx

"Isaac Alexander" <isaacNOSPAM@xxxxxxxxxxxxxxxxxxx> wrote in message
news:44e1007a$1@xxxxxxxxxxxxxxxxxxxxxxxxx

The BDE handled this quite nicely since it would only fire the
OnFilterRecord event for enough records to fill the grid which made for
great performance.

We ran into a similar issue (going from BDE->ADO), which we ended up
having to have multiple round-trips to the server. At the time it seemed
like a huge problem (which is was), but it forced us to re-think what the
application was really needing to do and ended up re-writing the process
to a single stored procedure call. Almost 5 years later, users still
enjoy nearly instantaneous response times.


How much work is being done in the stored procedure? My list is an conflict
checking sampling module that checks availability, licenses, skills, plus up
to 20 other search criteria. I'm worried that the stored procedure will take
a long time.


.

Relevant Pages

  • Re: TADOQuery, OnFilterRecord and Locate
    ... The BDE handled this quite nicely since it would only fire the ... OnFilterRecord event for enough records to fill the grid which made for ... nearly instantaneous response times. ...
    (borland.public.delphi.database.ado)
  • Re: Returning records from a Store Procedure
    ... It is being assigned to a datareader. ... Runs decently when the Stored procedure returns a small data set. ... That takes 10 minutes to finish loading. ... > object to get data out of a database, but if you're loading it to a grid it ...
    (microsoft.public.data.ado)
  • Re: DataGrid Colum Names
    ... Should I create a datatable from the stored procedure? ... > You'll reference the DataTable that you bound the grid to. ... > grid is just the presentation of the underlying data obejct. ...
    (microsoft.public.dotnet.languages.vb)
  • Unable to retrieve schema - Divide by zero error encountered
    ... Here's the funny thing - the grid works fine. ... I get to the point where I can test the data source, ... calls a stored procedure with two arguments) are correct. ... even Visual Studio manages to get the data in the data source configuration ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: xp.cmdshell doesnt fire
    ... The stored proc can be checking the return code from ... When the stored procedure runs it should fire and create a textfile ... have set the non-sysadmin job proxy account to our "god" account but it still ...
    (microsoft.public.sqlserver.security)