Re: TADOQuery, OnFilterRecord and Locate

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

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.

After we re-thought the process, not a lot. I don't know what your exact
needs are, but can the process be broken up in smaller processes? Maybe a
combination of database and non-database resources (ex. utilizing a O-O
design pattern like the Decorator pattern)? Maybe one of those situations
you don't know until you try?

There maybe a workaround or other useful information, take a look at:

http://www.fulltextsearch.com/

You can search on Borland specific newsgroups and see if anyone else is
having similar issues.

Good luck,
krf


.

Relevant Pages

  • Re: TADOQuery, OnFilterRecord and Locate
    ... How much work is being done in the stored procedure? ... skills, plus up to 20 other search criteria. ... design pattern like the Decorator pattern)? ...
    (borland.public.delphi.database.ado)
  • Re: Help Isolating Data Access
    ... > I've set up a stored procedure that first queries the table for a record ... > The process that executes this stored procedure runs on multiple threads ... Is there a design pattern for ...
    (microsoft.public.dotnet.general)
  • Access ADP Form and Stored Procedure as RecordSource
    ... Me.RecordSource property, to a second Stored Procedure, in code when ... the Search button was clicked and include all the Input Parameters ... from the search criteria the user would input. ... What I realized is you can't change the RecordSource from one Stored ...
    (microsoft.public.access.queries)
  • Access ADP Form and Stored Procedure as RecordSource Options
    ... Me.RecordSource property, to a second Stored Procedure, in code when ... the Search button was clicked and include all the Input Parameters ... from the search criteria the user would input. ... What I realized is you can't change the RecordSource from one Stored ...
    (microsoft.public.access.adp.sqlserver)
  • DataView Rowfilter Speed
    ... My application allows the end user to enter search criteria to limit the ... and populates a dataset with a single table. ... 'Run the stored procedure and return data set. ... rowfilter searches are resolved quickly, and some take minutes and there is ...
    (microsoft.public.data.ado)