Thanks - did you go to SQL-Server after moving to DBExpress or are you still
using FB/IB ?
Regards
Paul McKenzie
Wellington
New Zealand
Karl @ Work wrote:
I migrated from IBX to DBExpress with nary a hitch. They're similar in the
extent that their core datasets are unidirectional. It is easier when
you're already using ClientDataSets. Can't speak for ADO.
Whichever way you go, the IB optimisation issues will still be there. It
helps to know that FB/IB handles composite indices very badly: if you're
having trouble with the engine not choosing your composite index in plans
when it ought to, try replacing the offending index with a bunch of
single-column indices instead. Seems to work more often than not. Beats
having to write your own plans.
Cheers,
Carl
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Paul McKenzie
Sent: Sunday, May 28, 2006 7:37 PM
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Migration from IBX to Interbase to SQL-Server 2005
The Conversion from InterBase to SQL-Server is not the
problem. We have tools and experts to do that.
The issue we have is that we need to migrate our 3-Tier App
from IBX components to DBExpress or
ADOExpress - We are investigating which is best...
The appear to be fairly equal!
I was wondering if anyone had done the conversion (or similar
investigation) and found it easy to go
to one but not the other. Or found one cannot do something vital etc.
One big issue is that we would like to migrate to SQL-Server
2005 and will probable move to D2006
for this but are having to investigate this as well.
One big issue we had (this is very legacy code) is that the
IB optimiser was killing our SQL in many
heavy-duty frequently used cases... we had to re-write our
SQL just to force InterBase to not
optimise and thus run much faster (in most cases speed
reduced from many minutes to a few seconds)
Everything I have read so far (ok 0.5 a day) indicates that
DBExpress vs ADOExpress is just preference!
Hoping someone has had experience...
The only indicator is from the Newsgroup "SQL Servers - May
2006" Bill Todd (TeamB) recommends ADO
over DBExpress for Win32!
Regards
Paul McKenzie
Wellington
New Zealand
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
