| Subject | Re: [firebird-support] Update database to new version? |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-07-26T13:35:32Z |
At 01:17 PM 26/07/2004 +0100, you wrote:
1.5's ODS 10.1, you can take advantage of performance enhancements stemming
from indexing having been added to some of the system tables...there are
also some handy 10.1 features you might want to use, such as being able to
have descending indexes on primary keys, nulls in unique constraints,
separate custom names for constraints and their supporting indexes, et al.
Re the SQL problems - they're not from using IBX, per se, but from Fb 1.5
being stricter about enforcing legal SQL, particularly noticeable with
GROUP BY and ORDER BY criteria. You won't get away with ignoring the
release notes. :-)
/heLen
>Do you need to do anything to update your database to make it use the newerWhere does "need" end and "want" begin? If you upgrade your db to Firebird
>version of Firebird, when you install 1.5?
1.5's ODS 10.1, you can take advantage of performance enhancements stemming
from indexing having been added to some of the system tables...there are
also some handy 10.1 features you might want to use, such as being able to
have descending indexes on primary keys, nulls in unique constraints,
separate custom names for constraints and their supporting indexes, et al.
Re the SQL problems - they're not from using IBX, per se, but from Fb 1.5
being stricter about enforcing legal SQL, particularly noticeable with
GROUP BY and ORDER BY criteria. You won't get away with ignoring the
release notes. :-)
/heLen