Board index » delphi » Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE

Euan Garde

Delphi Developer
Wed, 18 Jun 2003 00:02:54 GMT

Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE

Why not get one of the direct ODBC tool kits?

-Euan

Quote
"Douglas Kurtz" <nos...@work.com> wrote in message

news:92i4au$qai4@bornews.inprise.com...
Quote
> The problem I have with ODBC is that unless I write my own code to work
> directly with ODBC (which I don't have the time) the I must use the BDE.
The
> BDE will not execute on more than one processor in a multi-threaded
> application. This application is designed to take advantage of large
> multi-processor machines. By using the BDE all threads which interface
with
> the BDE must execute on the same processor. A complete waste of resources.

> "Euan Garden" <euan.gar...@spicedham.usa.net> wrote in message
> news:92gqe0$22v6@bornews.inprise.com...
> > In addition to what Justin said, native ODBC (dunno about BDE based
> ODBC)for
> > SQL Server in MDAC 2.1 is faster than OLE DB or ADO. In MDAC 2.6 ODBC is
> as
> > fast as OLE DB and faster than ADO.

> > You would not need to write an OLE DB Provider to use OLE DB you would
> need
> > to write an OLE DB consumer.

> > -Euan

> > "Douglas Kurtz" <nos...@work.com> wrote in message
> > news:92gdf7$23h5@bornews.inprise.com...
> > >     I need something faster than ADO or ODBC drivers. And I don't have
> > time
> > > to write OLE DB driver. Thanks for input.

 
Justin Pitt

Delphi Developer
Wed, 18 Jun 2003 02:09:27 GMT

Re:Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE


for selects, try to use a firehose cursor.
Usual rant about stored procedures, index tuning, etc.
I had not encountered the issue mentioned in Euan's reply - my app server is
ADO 2.1 and it runs several highly multithreaded apps quite well
Justin Pitt

Delphi Developer
Wed, 18 Jun 2003 02:04:17 GMT

Re:Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE


if it's the one I remember, it's stable and faster than even ODBC. However,
it is tied to SQL DBLIB and doesn't support MSSQL 7+ features like varchar>
2048 or whatever 6.5's limit was
Euan Garde

Delphi Developer
Wed, 18 Jun 2003 05:30:05 GMT

Re:Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE


Its a stated limitation that perf with the core MDAC stack in 2.1, is
significantly reduced above 2 procs. Perf on MDAC 2.5/2.6 is almost linear
with procs up to 8 (thats all that has been published), as can be seen by
the TPC-C numbers for SQL2k.

If you are not maxing the processors then you will not have seen this issue.

-Euan

Quote
"Justin Pitts" <pitt...@my-deja.com> wrote in message

news:3a4cd34d$1_1@dnews...
Quote
> for selects, try to use a firehose cursor.
> Usual rant about stored procedures, index tuning, etc.
> I had not encountered the issue mentioned in Euan's reply - my app server
is
> ADO 2.1 and it runs several highly multithreaded apps quite well

Douglas Kurt

Delphi Developer
Wed, 18 Jun 2003 05:43:22 GMT

Re:Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE


Justin or Euan,
   Is a firehose cursor an Interface or a type of database cursor (forward
cursor, scrollable, ect). I am using Delphi ADO components and do not see
any firehose setting.
Justin Pitt

Delphi Developer
Wed, 18 Jun 2003 06:15:52 GMT

Re:Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE


sorry for the jargon - it's a forward only
Douglas Kurt

Delphi Developer
Wed, 18 Jun 2003 06:17:49 GMT

Re:Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE


thanks
Justin Pitt

Delphi Developer
Wed, 18 Jun 2003 06:17:44 GMT

Re:Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE


other than the TPC numbers, where has this been documented by MS?
Del

Delphi Developer
Wed, 18 Jun 2003 10:41:14 GMT

Re:Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE


or large blob fields
Quote
Justin Pitts wrote in message <3a4cd217$1_2@dnews>...
>if it's the one I remember, it's stable and faster than even ODBC. However,
>it is tied to SQL DBLIB and doesn't support MSSQL 7+ features like varchar>
>2048 or whatever 6.5's limit was

Justin Pitt

Delphi Developer
Sun, 22 Jun 2003 04:18:32 GMT

Re:Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE


Hey! I'm not that old! :)
Go to page: [1] [2]

Other Threads