With and without the suspend.

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: Friday, 11 March 2011 4:46 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Query runs extremely slow when run inside a stored procedure

> 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!



[Non-text portions of this message have been removed]