I ran an sp in Squirrel and it took like 30 seconds to return 57 records.
I ran it on isql and took just few seconds to return the same number of
records. I ran the same sp again with different input in isql which return
4,332 records. It took almost a minute to return to my unix console. I ran
the same input in Squirrel and waited for an hour and never completed. Java
services in Task Manager was at 100%. What could be causing it?