Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:33080 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 59712 invoked by uid 1010); 10 Nov 2007 13:59:45 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 59696 invoked from network); 10 Nov 2007 13:59:45 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 10 Nov 2007 13:59:45 -0000 Authentication-Results: pb1.pair.com smtp.mail=arend@hyves.nl; spf=pass; sender-id=pass Authentication-Results: pb1.pair.com header.from=arend@hyves.nl; sender-id=pass Received-SPF: pass (pb1.pair.com: domain hyves.nl designates 217.170.2.100 as permitted sender) X-PHP-List-Original-Sender: arend@hyves.nl X-Host-Fingerprint: 217.170.2.100 mail1.exchange.cysonet.com Windows 2000 SP4, XP SP1 Received: from [217.170.2.100] ([217.170.2.100:39060] helo=mail1.exchange.cysonet.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id E7/C0-51759-F49B5374 for ; Sat, 10 Nov 2007 08:59:45 -0500 Received: from hyves1.exchange.cysonet.com ([85.158.200.92]) by mail1.exchange.cysonet.com with Microsoft SMTPSVC(6.0.3790.3959); Sat, 10 Nov 2007 14:59:40 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C823A1.F4690F1E" Date: Sat, 10 Nov 2007 14:59:47 +0100 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PHP-DEV] Making parallel database queries from PHP Thread-Index: AcgjlLOugGEalxkiQwavGxAH1hxqugACmLwA References: <1C887659-E869-4E15-98B0-05D68DC71852@pooteeweet.org> To: Cc: "Lukas Kahwe Smith" X-OriginalArrivalTime: 10 Nov 2007 13:59:40.0629 (UTC) FILETIME=[F02DA850:01C823A1] Subject: RE: [PHP-DEV] Making parallel database queries from PHP From: arend@hyves.nl ("Arend van Beelen") ------_=_NextPart_001_01C823A1.F4690F1E Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Lukas, > 2) maybe you can create something out of MySQL Proxy that splits out =20 > a single query into multiple queries and then rejoins them > 3) since MySQL AB is actively developing a new libmysql replacement =20 > for PHP only, you might want to talk to them about implementing =20 > something like this Spot on! What you're suggesting, splitting queries and combining the = results, is exactly the direction I'm thinking about. We had a short = look though at MySQL Proxy, and basically it does not seem to cut the = job for us. We want to avoid adding another proxy layer between our = webservers and the database servers as it would just mean additional = overhead and possible bottlenecks and points of failure. This is why I = want to move this functionality onto the webservers themselves, to = achieve minimum overhead and to guarantee it will scale with the number = of webservers. Nevertheless, MySQL Proxy does appear to provide some of the = functionality we will be needing and it might indeed be a good idea to = contact MySQL and try to reuse some of Proxy's components if possible. Thanks! Arend. ------_=_NextPart_001_01C823A1.F4690F1E--