Received: from mail.rdc1.va.home.com (ha1.rdc1.va.home.com [24.2.32.66]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB2IeaF45437 for ; Sat, 2 Dec 2000 13:40:36 -0500 (EST) (envelope-from batemanb@home.com) Received: from workhorse ([24.2.41.198]) by mail.rdc1.va.home.com (InterMail vM.4.01.03.00 201-229-121) with SMTP id <20001202184042.FWGP23967.mail.rdc1.va.home.com@workhorse>; Sat, 2 Dec 2000 10:40:42 -0800 Message-ID: <012d01c05c66$0108d6f0$c6290218@workhorse> From: "Bryan Bateman" To: , "Sanjay Arora" References: <200012011652.WAA08483@tcs.com> Subject: Re: Thanks.....& How do I implement Connection Pooling....;-)) Date: Sat, 2 Dec 2000 13:44:33 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200012/8 X-Sequence-Number: 345 Let me also ask this question and add another request that may be helpful to Sanjay and myself. All references and examples I have seen to date that explain COM, DCOM, COM+ and MTS all make reference to a PUB database that comes with MSSQL. If anyone out there has ported this to postgresql, I could sure use any configuration scripts you might have. Thanks, Bryan ----- Original Message ----- From: "Sanjay Arora" To: Sent: Friday, December 01, 2000 10:26 PM Subject: [INTERFACES] Thanks.....& How do I implement Connection Pooling....;-)) > First of all I would like to thank all those who helped me solve my slow > odbc access problem. Shutting off odbc logs helped & recompiling the odbc > driver on NT really boosted the performance a bit. This can only happen on > the net.....I couldn't have afforded a consultant !! > > I am using postgreSQL v. 7.0.2 on RH Linux 6.2 on the server with VB6 > Application accessing the DB through postgrSQL ODBC driver v. 6.50 and > another accesing through JDBC. > > Now I want to pool my connections on the postgreSQL server. Can some people > give me some pointers? Some Web Resources for studying this subject? My > experience on connection pooling is limited to MTS in MS environs. > > With best regards. > > Sanjay. >