Return-Path: Delivered-To: apmail-perl-modperl-archive@www.apache.org Received: (qmail 95633 invoked from network); 16 Aug 2005 23:05:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 16 Aug 2005 23:05:10 -0000 Received: (qmail 60627 invoked by uid 500); 16 Aug 2005 23:05:04 -0000 Delivered-To: apmail-perl-modperl-archive@perl.apache.org Received: (qmail 60610 invoked by uid 500); 16 Aug 2005 23:05:03 -0000 Mailing-List: contact modperl-help@perl.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Delivered-To: mailing list modperl@perl.apache.org Received: (qmail 60597 invoked by uid 99); 16 Aug 2005 23:05:03 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Aug 2005 16:05:03 -0700 X-ASF-Spam-Status: No, hits=3.6 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,MSGID_FROM_MTA_HEADER,RCVD_IN_BL_SPAMCOP_NET,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of badaiaqrandista@hotmail.com designates 65.54.161.21 as permitted sender) Received: from [65.54.161.21] (HELO hotmail.com) (65.54.161.21) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Aug 2005 16:05:22 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 16 Aug 2005 16:05:01 -0700 Message-ID: Received: from 65.54.161.200 by by106fd.bay106.hotmail.msn.com with HTTP; Tue, 16 Aug 2005 23:05:01 GMT X-Originating-IP: [61.9.213.251] X-Originating-Email: [badaiaqrandista@hotmail.com] X-Sender: badaiaqrandista@hotmail.com In-Reply-To: <1124187419.6987.7.camel@asterix.traveljury.com> From: "Badai Aqrandista" To: modperl@perl.apache.org Subject: Re: apache children waits for each other? Date: Wed, 17 Aug 2005 09:05:01 +1000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 16 Aug 2005 23:05:01.0492 (UTC) FILETIME=[EE411F40:01C5A2B6] X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi, >I'm assuming that each client database is contained within the same >MySQL server, and that you're not running 300 MySQL servers on different >machines or different ports? Yes, why would I do that? >If so, you can reuse the same connections, and just reference the >different database in the query.So : > >select * >from db1.table1 > >select * >from db2.table1 > >When you connect and specify a database name, you're just specifying the >default database. I don't know it's even possible in mysql. Its reference docs doesn't say that it is (http://dev.mysql.com/doc/mysql/en/join.html). Thanks... --- Badai Aqrandista Cheepy (?) _________________________________________________________________ REALESTATE: biggest buy/rent/share listings http://ninemsn.realestate.com.au