Re: Cakephp, gearman workers and changing database connection on the fly issue

2012-09-17 Thread Ketan Shah
No worries Tarique. Thanks for your time. I've wasted too much time only to realise that remote mysql connection is kinda slow. So we decide to build an API on top of cakephp which would consume this data. Worked out to be lot faster. cheers, -Ketan. On Mon, Sep 17, 2012 at 3:41 PM, Dr. Tarique

Re: Cakephp, gearman workers and changing database connection on the fly issue

2012-09-17 Thread Dr. Tarique Sani
Looks fine... No more ideas - sorry T On Mon, Sep 17, 2012 at 10:18 AM, Ketan Shah wrote: > Thanks Tarique, > > Here you go. http://pastebin.com/ezCBqyGV > > On Mon, Sep 17, 2012 at 10:10 AM, Dr. Tarique Sani > wrote: >> >> On Sat, Sep 15, 2012 at 6:46 PM, Ketan Shah wrote: >> > Thats correct

Re: Cakephp, gearman workers and changing database connection on the fly issue

2012-09-16 Thread Ketan Shah
Thanks Tarique, Here you go. http://pastebin.com/ezCBqyGV On Mon, Sep 17, 2012 at 10:10 AM, Dr. Tarique Sani wrote: > On Sat, Sep 15, 2012 at 6:46 PM, Ketan Shah wrote: > > Thats correct. I am sending the db config info in the workload > > Paste the code that you are using to change the DB > >

Re: Cakephp, gearman workers and changing database connection on the fly issue

2012-09-16 Thread Dr. Tarique Sani
On Sat, Sep 15, 2012 at 6:46 PM, Ketan Shah wrote: > Thats correct. I am sending the db config info in the workload Paste the code that you are using to change the DB This should not happen because every workload is processed in its own thread and they do not share anything. The DB connection sh

Re: Cakephp, gearman workers and changing database connection on the fly issue

2012-09-15 Thread Ketan Shah
Thats correct. I am sending the db config info in the workload Sent from my iPhone On 15-Sep-2012, at 4:33 PM, "Dr. Tarique Sani" wrote: > Are you sending which DB to use in the workload and then switching the > DB in the worker accordingly? > > T > > On Sat, Sep 15, 2012 at 9:59 AM, Ketan w

Re: Cakephp, gearman workers and changing database connection on the fly issue

2012-09-15 Thread Dr. Tarique Sani
Are you sending which DB to use in the workload and then switching the DB in the worker accordingly? T On Sat, Sep 15, 2012 at 9:59 AM, Ketan wrote: > howdy! > > We have created a SaaS app using cakephp 1.3 which is pulling in data from a --

Cakephp, gearman workers and changing database connection on the fly issue

2012-09-14 Thread Ketan
howdy! We have created a SaaS app using cakephp 1.3 which is pulling in data from a 3rd party API and populating the database (each subdomain has its own database) . We are in process of moving our architecture to a gearman for the 3rd party API. Each subdomain would submit a workload to the