Hi to all,
I would like to ask u if anyone has a simple PB app (or can give a hint on
how to build one) that compares the connection speed and the amount of data
(from - to) using mss,oledb,ado.net when connected to an Microsoft SQL
The reason is that we migrate our PB app from MSS to OLEDB or ADO>NET
Sorry for my poor English.
I hope my request is not silly...(and I hope you could understand what I
Subject: benchmark program
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-Trace: 1 Sep 2005 03:54:04 -0700, 188.8.131.52
X-Original-Trace: 1 Sep 2005 03:54:05 -0700, forums-2-dub.sybase.com
Date: 1 Sep 2005 03:54:08 -0700
X-Trace: forums-1-dub 1125572048 10.22.108.75 (1 Sep 2005 03:54:08 -0700)
X-Original-Trace: 1 Sep 2005 03:54:08 -0700, forums-master.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:8570
Article PK: 735787
Hi to all,
Subject: Re: benchmark program
Organization: STD Inc.
X-Newsreader: Microsoft Outlook Express 5.50.4927.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200
Date: 1 Sep 2005 04:49:43 -0700
X-Trace: forums-1-dub 1125575383 184.108.40.206 (1 Sep 2005 04:49:43 -0700)
X-Original-Trace: 1 Sep 2005 04:49:43 -0700, stealth.nserc.ca
Xref: forums-1-dub sybase.public.powerbuilder.objects:8571
Article PK: 735789
Great question .. I would like to know the overhead of ODBC, OLE-DB and
ADO.net vs MSS as well. I have thought about that allow over the past year.
I think MS is imposing unnecessary overhead on the average application no
matter what development tool you use. They should of enhanced the DBLib.dll
(MSS) to support SQLServer2000/2005. I think that would have been extremely
easy to add support for a few new data types and long character columns.
The problem with moving off the native (MSS) driver is also the change to
the SQL - especially at run time. Each other driver type introduces DML
nuances which are hard to test for (thanks Bill)!