Subject | Re: ISQL Faster than IBO?.. why? |
---|---|
Author | Carlos GarcĂa Trujillo |
Post date | 2006-10-20T18:14:16Z |
Thanx Jason,
I'm using now a trick to get the results for single-field statements
using a stored procedure that makes a EXECUTE STATEMENT ... INTO...
of one parameter that contains the SQL of my request.
This works great for single output statements, and even i've used
TStringList to feed the results of all the records for that field,
and works well for my requirements, i've make some trickys to get
more than one field using predefined field-separators and getting all
the fields concatenated as a single string, but i'would like to can
retrieve the results of one arbitrary query as a TDataset... the
arbitrary order and the types of the fields dificults the use of
predetermined SPs.
The only problem that i have using this Predetermined SP is that i
must treat all the results as Strings so i must do a CAST for the
selected field match with te result of the SP, but using CAST with
TIMESTAMP types returns something like "2006-10-06" that cant be
casted again as a TDateTime in Delphi =:-(
Any ideas to can retrieve an arbitrarious SELECT and perform it using
pre-defined SPs is very wellcome, i could think in use
TJvMemoryDataset for store the results, i'll figure out how use this
tricks to gain the fastest possible speed in my App over this VERY
SLOW connection.
Carlos G.
I'm using now a trick to get the results for single-field statements
using a stored procedure that makes a EXECUTE STATEMENT ... INTO...
of one parameter that contains the SQL of my request.
This works great for single output statements, and even i've used
TStringList to feed the results of all the records for that field,
and works well for my requirements, i've make some trickys to get
more than one field using predefined field-separators and getting all
the fields concatenated as a single string, but i'would like to can
retrieve the results of one arbitrary query as a TDataset... the
arbitrary order and the types of the fields dificults the use of
predetermined SPs.
The only problem that i have using this Predetermined SP is that i
must treat all the results as Strings so i must do a CAST for the
selected field match with te result of the SP, but using CAST with
TIMESTAMP types returns something like "2006-10-06" that cant be
casted again as a TDateTime in Delphi =:-(
Any ideas to can retrieve an arbitrarious SELECT and perform it using
pre-defined SPs is very wellcome, i could think in use
TJvMemoryDataset for store the results, i'll figure out how use this
tricks to gain the fastest possible speed in my App over this VERY
SLOW connection.
Carlos G.