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

[Neven MacEwan]

Paul

dbx and ado are incomparable so saying one is 'better' than the other is 
irrelevant, dbX is a thin, fast, unidirectional data provider/command 
evecutor, ADO is a fat M$ 'solution to end all solutions' also known as 
'we've done this 5 times (ODBC 1, ODBC 2, RDO, DAO, ADO) and still can't 
get it right!'

I think if you follow the logic that you should use ADO because its 
designed to work with MS SQL, you might as well extrapolate that to 
using VB because ADO was designed to work with it, BTW you might as well 
redesign your database to use the ADO update logic while you are at it

Neven

Paul McKenzie wrote:
> 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
>>
>>
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 
> 

-- 
Neven MacEwan (B.E. E&E)
Ph. 09 620 1356 Mob. 027 4749 062

New Address Details
===================
MWK Computer Systems
1 Taumata Rd
Sandringham
Auckland

Ph 620 1356
Fx 620 1336
-------------- next part --------------
A non-text attachment was scrubbed...
Name: neven.vcf
Type: text/x-vcard
Size: 164 bytes
Desc: not available
Url : http://ns3.123.co.nz/pipermail/delphi/attachments/20060531/ec2d85a3/neven.vcf