Article View: borland.public.vdbase.data.sql
Article #1532Re: SQL or not
From: Romain Strieff [TeamB]
Date: Tue, 11 Nov 1997 00:00
Date: Tue, 11 Nov 1997 00:00
21 lines
1482 bytes
1482 bytes
In article <3467CCBB.ED460008@DELETE_THIS.hit.net>, kgc@DELETE_THIS.hit.net says... > > There are a number of factors involved here. For example, when I hit > our AS/400 database from VdB with a SQL statement, performance is not > too impressive. There's a lot of overhead, and it really shows at the > front end of the transaction. But when I signon to the AS/400 and run > its own interactive SQL facility, it's dynamite. I mean it's zoomin'. > Why the huge difference? Middleware. Between the native AS/400 > database and my VdB app is the QCMN subsystem on the /400, ODBC, the > BDE, and finally VdB. If you have native SQL drivers and can avoid > using ODBC you'll get the benefit of optimized connections and > performance. ----- And how much would such a setup be?<G> (Instead of a simple Netware Server) -- Romain Strieff [TeamB] A few VdB utilities at: http://ourworld.compuserve.com/homepages/RStrieff/
Technical Details
Message-ID:
<MPG.ed27dc2698a8bb7989f55@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<01bcebc7$dd08ec20$a8fba126@LoprestA> <346a4a98.8671338@forums.Borland.Com> <3467CCBB.ED460008@DELETE_THIS.hit.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,ef8a746a45c3dbae X-Google-Attributes: gidff5a1,public From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB]) Subject: Re: SQL or not Date: 1997/11/11 Message-ID: <MPG.ed27dc2698a8bb7989f55@forums.borland.com> X-Deja-AN: 288614301 References: <01bcebc7$dd08ec20$a8fba126@LoprestA> <346a4a98.8671338@forums.Borland.Com> <3467CCBB.ED460008@DELETE_THIS.hit.net> Reply-To: teamb@opto-pps.com Organization: TeamB Newsgroups: borland.public.vdbase.data.sql