Me too.

There's something fishy with the where clause. If I remove the element name parameter, then it runs fine.

I've got a work around by just grouping by the element_name field as well and using that in a different way.

Thanks for all the help.

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

> With and without the suspend.

Then I'm puzzled.

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]