Subject Re: [firebird-support] Query runs extremely slow when run inside a stored procedure
Author Martijn Tonies
> I've tried the following (individual changes):
> * Removed the for, and just selected into local variables
> * Used just the derived table SQL (still slow), and removed the
> outer select, so now it's just a plain select with no fancy work, just a
> max on a string concatenation.
> * Restarting firebird (v 2.1.2 btw)
> * Restarting PC
> * Dropping and re-creating
> All still take much longer in the stored procedure.

And the SUSPEND?

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!