Re: Using IF in a query to set a variable then sort on said variable

2009-10-25 Thread Jaime Crespo Rincón
2009/10/23 Jeff j...@platinumsynergy.com: I currently have a query like so: SELECT p.fldId, p.fldFName, p.fldLName, p.fldEmail, p.fldPhone, p.resellerId, d.timezoneId, d.bestTime, d.lastDate, d.lastTime, d.lastConnected FROM tblProspects as p LEFT JOIN tblProspectsDetails as d ON

MySQL alternative to PostgreSQL's pgpool2?

2009-10-25 Thread Tomasz Chmielewski
With PostgreSQL, I can use pgpool2[1] tool as a load balancer/replicator for queries: postgres_server_1\ pgpool2 --- client postgres_server_2/ Generally, pgpool will query either of the SQL servers to load balance (and failover, if one of them goes down), and send writes

Re: MySQL alternative to PostgreSQL's pgpool2?

2009-10-25 Thread Carlos Proal
Hi Tomasz There are several solutions for this, one of them, maybe the most popular, is MySQL proxy, take a look to see if solves your issues. http://forge.mysql.com/wiki/MySQL_Proxy Carlos* * On 10/25/2009 12:41 PM, Tomasz Chmielewski wrote: With PostgreSQL, I can use pgpool2[1] tool as a

Fw: RM700,000+++

2009-10-25 Thread rosidah soaid
Mari capai impian anda bersama kami.  Sila Klik Link berikut :- www.mesti.my/1malaysia Terima Kasih...moga anda berjaya seperti kami. __ Get more social and