Print Thread
slower queries when not using substitution variables
#8206 02/11/06 07:56 PM
Joined: Feb 2006
Posts: 3
M
matjazt Offline OP
Member
OP Offline
Member
M
Joined: Feb 2006
Posts: 3
Hello,

could you please explain me, why are large (complicated) queries so much faster when using substitution variables instead of other types (integer, string, date). If I run query in pl/sql developer the query is very fast (2 secs), when I run it within TOracleDataSet, the execution is so much slower (60 secs)...Of course, if I use substitution variables, then I have to be careful about right format of variable...

Thank you for the answer!

Re: slower queries when not using substitution variables
#8207 02/13/06 05:06 PM
Joined: Oct 1999
Posts: 138
Eschborn, Germany
Member
Offline
Member
Joined: Oct 1999
Posts: 138
Eschborn, Germany
Could you give an example of the sql and the contents of the variables?

Greetings
Jens


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4