From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham autolearn_force=no version=3.4.4 X-Google-Thread: 103376,2843c5eea3415584 X-Google-Attributes: gid103376,public X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!news3.google.com!news.glorb.com!wn14feed!worldnet.att.net!207.35.177.252!nf3.bellglobal.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail From: "Warren W. Gay VE3WWG" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.lang.ada Subject: Re: APQ (Connection Cloning) References: <2hju7i5ft73q$.x4md24pt913v.dlg@40tude.net> <1TCyd.29237$GK5.1510003@news20.bellglobal.com> In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Date: Thu, 23 Dec 2004 13:52:24 -0500 NNTP-Posting-Host: 198.96.223.163 X-Complaints-To: abuse@sympatico.ca X-Trace: news20.bellglobal.com 1103827873 198.96.223.163 (Thu, 23 Dec 2004 13:51:13 EST) NNTP-Posting-Date: Thu, 23 Dec 2004 13:51:13 EST Organization: Bell Sympatico Xref: g2news1.google.com comp.lang.ada:7197 Date: 2004-12-23T13:52:24-05:00 List-Id: Georg Bauhaus wrote: > Warren W. Gay VE3WWG wrote: > : Why a second database connection? The reasons vary, but the following > : reasons come to mind right away: > > Another one: > - one database system is very fast but is more or less a simple SQL > front end to a quick ISAM store or some such; another database > system supports transactions, subselects, partial locks, etc.. > But this comes at a price, you cannot use the second database for > storing larger amounts of data quickly. Solution: use two database > systems for two needs. > > And another one: > - say, my application is a component to be integrated with other > components that use an existing database system. As is, mine comes > with its own database handling, using a different database system. > Can all components use the same DBMS? > There can be various reasons why the existing database system > may or may not fulfill the requirements of my component, and > similarly the other components may not be happy with the DB that > may component uses by default. > > Let alone the cost of integration, of adaption effort, and planning backup > anew. > > > -- Georg I think you confused the OP's question. His was along the lines of "why would you need more than one connection to the very same database in one application?" Same database product and same database/schema. APQ certainly does not stop anyone from messing with different products or instances at the same time. In fact I did a lot of this successfully when I was testing Sybase, with PostgreSQL and MySQL as comparisons on similar tables. -- Warren W. Gay VE3WWG http://home.cogeco.ca/~ve3wwg