> 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
http://www.upscene.com

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