slower queries when not using substitution variables - Allround Automations forums

Register Log In

Forums Products Direct Oracle Access slower queries when not using substitution variables

Print Thread

slower queries when not using substitution variables #8206 02/11/06 07:56 PM
Joined: Feb 2006 Posts: 3 M matjazt OP Member
OP matjazt 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 Jens Fudickar Member
Jens Fudickar 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
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.107s Queries: 14 (0.026s) Memory: 2.4948 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-20 00:02:01 UTC
Valid HTML 5 and Valid CSS