[DUG] Migration from IBX to Interbase to SQL-Server 2005

[Paul McKenzie]

I didn't ask this very well - why ADO over DBX ?
Most (If not all) of what I have been able to find on the Net and Newsgroups says ADO is better...
"It was designed to work better with SQL-Server" etc...
This is a bit airy-fairy - is it correct ? does it still apply to D2006 Win32 ?
Almost all of the info relates to versions other than D2006. Has DBX surpassed ADO in D2006 ?

Regards
Paul McKenzie
Wellington
New Zealand


Richard Vowles wrote:
> Why would anyone go with SQL Server? 
> 
> (I am not seriously asking this question, I understand some people will
> be unfortunate enough to have to use it.)
> ---
> Richard Vowles, Solutions Architect, Borland New Zealand
> email: richard.vowles at borland.com
> phone: +64-9-9184573
> cell: +64-21-467747
> other: MSN richard.vowles at borland.com, skype: rvowles
> blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769
> 
> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
> On Behalf Of Paul McKenzie
> Sent: Wednesday, 31 May 2006 9:39 a.m.
> To: NZ Borland Developers Group - Delphi List
> Subject: Re: [DUG] Migration from IBX to Interbase to SQL-Server 2005
> 
> I have been playing with the ADO options ... Returning small ResultSets
> - 200-250 records I can get the speed to equal DBX (not better) but when
> the ResultSets increase ADO gets Slower compared to DBX!
> 
> I am asking why would anyone go with ADO over DBX ?
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 
>