Re: Large PHP/Database driven site & scalability

On Wed, 19 Jul 2000, Billy Harvey wrote: > Eric Peters writes: > > Its DEFINATELY something we've looked into : ) > > > > I went into some further detail in a couple previous Re:Re's > > > > Thanks though, > > > > Eric > > Yep - I just received those. You certainly have a interesting > problem, though I can't offer any "been there, done that advice." > > My bud is a true database guru and PE certified EE. He builds such > hardware for fun :) I'll ask him what kind of solution he'd look for, > as he is the TLC behind a very-large and very-financially- > important-to-his-company database too. sounds good > > One thought, and you've probably already been there, is to measure > your database use and see where you may be able split pieces into > separate machines. This would entail a rewrite of the PHP code so > that it sourced peices from different machines. My assumption here is > that the load is coming from the queries on large tables, and not as > much from the quantity of queries. As ny friend has emphasized to me, > SQL engines work better, in his opinon, building lots of smaller > tables, which are more easily distributed across databases on various > machines, that they do with large databases on one machine. > definately - its part of the process we are looking into - push comes to shove when we need to do a query from all of those tables we have to do that - do a query from each of those tables there doesn't sound to be any real slick way to do a distributed db system w/o an oracle enterprise setup Thanks again, Eric