Re: [PHP] Pulling from Multiple Databases

2011-02-01 Thread Steve Staples
-- purposely top posting as well -- just think, here in ontario, we have UBB... where Bell is proposing a 25 cap on usage... you sir, are killing my usage! :) On Tue, 2011-02-01 at 12:18 -0700, Alexis wrote: > Bloody Hell!! > > How many lines is the footer in your email response!!! > > I ma

Re: [PHP] Pulling from Multiple Databases

2011-02-01 Thread David Hutto
> Do you even NEED a footer with nothing but inane comments in it? > It's probably an overcompensation for a small penis. > Alexis > On 01/02/11 11:54, David Hutto wrote: >> I'd pass the db's to a threaded function that processes each db's info >> in an algorithmic order. >> >> -- The lawyer in m

Re: [PHP] Pulling from Multiple Databases

2011-02-01 Thread Alexis
Bloody Hell!! How many lines is the footer in your email response!!! I make it almost ten times longer than the reply itselftalk about abominable netiquette, and I have purposely put this response at the top as after all footers do go at the bottom of an email :) Do you even NEED a foote

Re: [PHP] Pulling from Multiple Databases

2011-02-01 Thread David Hutto
I'd pass the db's to a threaded function that processes each db's info in an algorithmic order. -- The lawyer in me says argue...even if you're wrong. The scientist in me... says shut up, listen, and then argue. But the lawyer won on appeal, so now I have to argue due to a court order. Furthermo

Re: [PHP] Pulling from Multiple Databases

2011-02-01 Thread Jon Hood
Bah, forgot to reply-all On Tue, Feb 1, 2011 at 11:59 AM, Jon Hood wrote: > Using pcntl_fork mostly accomplished what I wanted (I had to go back and > create the actual connection in each of the forked processes, otherwise, the > first process that ended would destroy the connection to the main

Re: [PHP] Pulling from Multiple Databases

2011-02-01 Thread Richard Quadling
On 1 February 2011 16:39, Jon Hood wrote: > (comments in-line) > > On Tue, Feb 1, 2011 at 10:34 AM, Richard Quadling > wrote: >> >> I use a data warehouse (a semi denormalized db) to hold data from >> around 200 different data sources (DB, Excel spreadsheets, Web, etc.) >> >> I use multiple scrip

Re: [PHP] Pulling from Multiple Databases

2011-02-01 Thread Adam Richardson
On Tue, Feb 1, 2011 at 10:59 AM, Jon Hood wrote: > I have a website that is currently pulling from more than 30 databases, > combining the data, and displaying it to the user. As more and more > databases are added, the script continues to get slower and slower, and > I've > realized that I need

Re: [PHP] Pulling from Multiple Databases

2011-02-01 Thread Jon Hood
(comments in-line) On Tue, Feb 1, 2011 at 10:34 AM, Richard Quadling wrote: > I use a data warehouse (a semi denormalized db) to hold data from > around 200 different data sources (DB, Excel spreadsheets, Web, etc.) > > I use multiple scripts to update the DB, each one tuned to a > particular fre

Re: [PHP] Pulling from Multiple Databases

2011-02-01 Thread Richard Quadling
On 1 February 2011 15:59, Jon Hood wrote: > I have a website that is currently pulling from more than 30 databases, > combining the data, and displaying it to the user. As more and more > databases are added, the script continues to get slower and slower, and I've > realized that I need to either

RE: [PHP] Pulling from Multiple Databases

2011-02-01 Thread Jay Blanchard
[snip] I have a website that is currently pulling from more than 30 databases, combining the data, and displaying it to the user. As more and more databases are added, the script continues to get slower and slower, and I've realized that I need to either find a way to pull these data in parallel. S

[PHP] Pulling from Multiple Databases

2011-02-01 Thread Jon Hood
I have a website that is currently pulling from more than 30 databases, combining the data, and displaying it to the user. As more and more databases are added, the script continues to get slower and slower, and I've realized that I need to either find a way to pull these data in parallel. So - wha