Re: ADO Performance / Optimize?
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 07/14/04
- Next message: Brian Bushay TeamB: "Re: Row cannot be located for updating"
- Previous message: Brian Bushay TeamB: "Re: Diamond Access"
- In reply to: Todd Jaspers: "ADO Performance / Optimize?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 13 Jul 2004 20:05:44 -0500
> CPXML_DATA.DM.CP_Query.SQL.Clear;
> CPXML_DATA.DM.CP_Query.SQL.Text := SQLStatement;
> CPXML_DATA.DM.CP_Query.Active := True;
> Result := CPXML_DATA.DM.CP_Query.FieldByName('specimen_id').AsString;
> CPXML_DATA.DM.CP_Query.Active := False;
> CPXML_DATA.DM.CP_Query.SQL.Clear;
> End;
>
>
>
>I'm posting this because I hope you'll take notice of the ACTIVE = TRUE and
>then ACTIVE = FALSE commands that I use. Is there a better way? Do I really
>need to active / inactivate the query component each time? Or can I leave
>the query active the entire time, and just execute it?
If you use a parameter in your query you can change the parameter and use the
Requrey method which will be a lot faster than what you are doing.
-- Brian Bushay (TeamB) Bbushay@NMPLS.com
- Next message: Brian Bushay TeamB: "Re: Row cannot be located for updating"
- Previous message: Brian Bushay TeamB: "Re: Diamond Access"
- In reply to: Todd Jaspers: "ADO Performance / Optimize?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
