Still FB. Cheers, Carl
> -----Original Message----- > From: Paul McKenzie [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 28, 2006 9:22 PM > To: [EMAIL PROTECTED]; NZ Borland Developers Group - Delphi List > Subject: Re: [DUG] Migration from IBX to Interbase to SQL-Server 2005 > > > 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
