Hi,

> What I'm I doing wong ?
> Any ideas ?
>
> Tried doubling buffer sizes in FB2.0 .. but

> ------------------------------------------------------------------------
> Same Server, Same data
>
> FB1.5: runtime 29 Secs ODS 10.1
> FB2.0: runtime 240 Secs ODS 11.0
> ------------------------------------------------------------------------

Could you post the PLANs return by FB1.5 and FB2.0 for both queries?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
1051 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!