🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #899

Re: MS SQL with ADO or MS SQL with dbExpress?

#899
From: Vassiliev V.V.
Date: Thu, 12 Dec 2002 09:23
62 lines
3483 bytes
This very depends on what you are doing and how ADO properties are set.
Anyway, OLEDB Direct is faster :).

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (LCPI provider, http://www.lcpi.lipetsk.ru) databases.

"Ramesh Theivendran" <rtheivendran@borland.com> �������/�������� � ��������
���������: news:3df76be3@newsgroups.borland.com...
> dbExpress access to MSSQL is mutiple times faster than ADO.
>
> T.Ramesh.
> "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message
> news:3dde439b@newsgroups.borland.com...
> > >We are wondering if we should go with ADO or
> > > dbExpress?
> >
> > ADO is based on OLEDB. OLEDB (and ADO) internally is much more powerfull
> > than dbExpress. dbExpress has only one plus over OLEDB (and ADO) - it is
> > cross-platform. If you need speed working with MS SQL Server you can use
> > OLEDB Direct (http://www.oledbdirect.com) that works with OLEDB and
avoids
> > ADO layer. Even without OLEDB Direct I recommend you ADO over dbExpress
> for
> > MS SQL Server.
> >
> > >Can dbExpress even be used with MS SQL?
> >
> > Yes, Delphi 7 even has MS SQL dbExpress driver. BCB 7 very probable will
> > have too. With BCB 6 you should use third-party drivers such as OLEDB
> > Express (can be found on http://www.oledbdirect.com, goto OLEDB
Express).
> >
> > ----------------------------------------------------------------
> > Regards,
> > Viatcheslav V. Vassiliev
> > http://www.oledbdirect.com
> > The fastest way to access MS SQL Server and MS Jet (MS Access)
databases.
> >
> > "bmkiss67" <bmkiss67@aaahawk.com> �������/�������� � �������� ���������:
> > news:3dde389e@newsgroups.borland.com...
> > > We have a cople of app that we have written a while ago that use the
> BDE.
> > > We have upgraded to BCB6, which I hope wasn't a mistake, and are
looking
> > to
> > > get away from the BDE now.  We are wondering if we should go with ADO
or
> > > dbExpress?  Can dbExpress even be used with MS SQL?
> > >
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID: <3df86101@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail
References: <3dde389e@newsgroups.borland.com> <3dde439b@newsgroups.borland.com> <3df76be3@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: fb4e2,d4f3ca338c81514c
X-Google-Attributes: gidfb4e2,public
X-Google-Thread: 10698b,d4f3ca338c81514c
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-12-12 02:17:20 PST
From: "Vassiliev V.V." <news@vassilievvv.mtu-net.ru>
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.cppbuilder.database.dbexpress
References: <3dde389e@newsgroups.borland.com> <3dde439b@newsgroups.borland.com> <3df76be3@newsgroups.borland.com>
Subject: Re: MS SQL with ADO or MS SQL with dbExpress?
Date: Thu, 12 Dec 2002 12:23:36 +0300
Lines: 66
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 212.188.101.125
Message-ID: <3df86101@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039687937 212.188.101.125 (12 Dec 2002 02:12:17 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail