Toad World® Forums

Bind variables slowing down sql


#1

Hi,

I’m using version 10.1.1.8 on Oracel 10G. When I run a simple sql with a bind
variable, Toad takes at least 10-15seconds to come back and ask for variable
value. But when I put in the variable value directly, the sql runs immediately.

Any ideas why the delay with bind variables?

an example sql could be : select * from clients where client_id = :client_id;



#2

This has been resolved. I had to delete the Variables.dat file in the \user
files directory. It had grown to 714kb (still not so big) but was causing this
delay.
image001.jpeg


#3

This has been resolved. I had to delete the Variables.dat file in the \user
files directory. It had grown to 714kb (still not so big) but was causing this
delay.
image001.jpeg