Got it to move over fine.. but now several of my queries are slow.. The plans are no changed.. and I dont know what to do to specify a plan etc.
Ive never had to before.. i just built indexes based on my anticipated queries and it worked fine..

----- Original Message -----
From: Marcin Bury
To: IBObjects@yahoogroups.com
Sent: Tuesday, February 19, 2008 10:58 AM
Subject: Re: [IBO] Firebird 2.


And check TIB_Query.KeyLinks.
IBO likes to put table name as the prefix even if you used an alias. Then
the query will not prepare.
That was my nightmare while switching to Firebird 2...

My $0.02
Marcin

----- Original Message -----
From: "Jason Wharton" <supportlist@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, February 19, 2008 6:50 PM
Subject: RE: [IBO] Firebird 2.

>> Is there anything that I need to do to use Firebird 2?
>> Ive been using firebird 1.5 for a long time.. I now have a
>> situation where the DB is getting near 2GB in size..
>> Im thinking I should move everything to Firebird 2. Is it
>> hard to do?
>
> There are release notes and a migration guide you can follow.
>
> There are some things you may need to change in your source code depending
> on how you use table aliases.
>
> Other than that, it should be rather straight forward.
>
> Jason Wharton
>
>
>
> __________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>





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