Toad World® Forums

Preparing Statement.... takes very long time


#1

I wonder, what could be the reason for ‘Preparing Statement…’ part of the query execution to take >5 (sometimes even 30) seconds? I’m using SQL Nav 5.5.4.
Windows task manager does not show any significant activity, but during this stage switching to another application window becomes impossible until SQL Nav actually executes the query.


#2

Hi Alexey,

Even if there’s an issue with 5.5.4 I doubt there’s little we can do for you. We’re currently working on version 6.2 and it’s much faster than 5.5.4. You can grab a free copy and try it out. We’re looking forward to more feedbacks from you.

Cheers,
Gwen