Is a design time query being run at runtime?
I have done a little more testing, and have found out that if you never call
those queries to gather the table and field names, the report still works.
If you Exit from the following function and never set the query to active,
the report still works fine.
procedure TdaDOADataSet.SetActive(Value: Boolean);
begin
Exit;
GetQuery.Active := Value;
end; {procedure, SetActive}
This saves a lot of round trips to the Oracle server. I have only tested
this on a couple of reports at runtime. I assume that this would cripple the
runtime query designer. So....is there a way to avoid these calls for
runtime only to boost performance?
Thanks,
Andy
those queries to gather the table and field names, the report still works.
If you Exit from the following function and never set the query to active,
the report still works fine.
procedure TdaDOADataSet.SetActive(Value: Boolean);
begin
Exit;
GetQuery.Active := Value;
end; {procedure, SetActive}
This saves a lot of round trips to the Oracle server. I have only tested
this on a couple of reports at runtime. I assume that this would cripple the
runtime query designer. So....is there a way to avoid these calls for
runtime only to boost performance?
Thanks,
Andy
This discussion has been closed.
Comments
this were able to be done, then at Delphi design time, RB would need to have
its own local database which would store all of this information. We don't
have this functionality in RB.
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com