Re: [PHP] php / mysql performance resources

2007-06-13 Thread Robert Cummings
On Wed, 2007-06-13 at 23:41 -0400, Guillaume Theoret wrote: > On 6/13/07, Daevid Vincent <[EMAIL PROTECTED]> wrote: > > > > > > > > I actually use this little optimizing trick as an interview question for > > new hires. You'd be amazed at how many people don't think of this, as > > obvious as it s

Re: [PHP] php / mysql performance resources

2007-06-13 Thread Guillaume Theoret
On 6/13/07, Daevid Vincent <[EMAIL PROTECTED]> wrote: I'll throw in my suggestion here as to how I implement this. Generally I evaluate how big are the tables and what do I intend to do with them. Sorting is usually a "problem". Using the PHP multi_sort seems cumbersome and never seems to be as

Re: [PHP] php / mysql performance resources

2007-06-13 Thread Guillaume Theoret
On 6/13/07, Richard Lynch <[EMAIL PROTECTED]> wrote: On Wed, June 13, 2007 12:31 pm, Guillaume Theoret wrote: > Thanks for the response. > > On 6/13/07, Robert Cummings <[EMAIL PROTECTED]> wrote: >> On Wed, 2007-06-13 at 10:36 -0400, Guillaume Theoret wrote: >> > Hi everyone, >> > >> > Can anyone

RE: [PHP] php / mysql performance resources

2007-06-13 Thread Daevid Vincent
I'll throw in my suggestion here as to how I implement this. Generally I evaluate how big are the tables and what do I intend to do with them. Sorting is usually a "problem". Using the PHP multi_sort seems cumbersome and never seems to be as simple as letting the DB do it. I too use LEFT JOINs

Re: [PHP] php / mysql performance resources

2007-06-13 Thread Richard Lynch
On Wed, June 13, 2007 12:31 pm, Guillaume Theoret wrote: > Thanks for the response. > > On 6/13/07, Robert Cummings <[EMAIL PROTECTED]> wrote: >> On Wed, 2007-06-13 at 10:36 -0400, Guillaume Theoret wrote: >> > Hi everyone, >> > >> > Can anyone recommend any good books/resources for php and mysql >

Re: [PHP] php / mysql performance resources

2007-06-13 Thread Robert Cummings
On Wed, 2007-06-13 at 12:39 -0500, Richard Lynch wrote: > On Wed, June 13, 2007 10:17 am, Robert Cummings wrote: > > On Wed, 2007-06-13 at 10:36 -0400, Guillaume Theoret wrote: > >> Hi everyone, > >> > >> Can anyone recommend any good books/resources for php and mysql > >> performance management? I

Re: [PHP] php / mysql performance resources

2007-06-13 Thread Robert Cummings
On Wed, 2007-06-13 at 13:31 -0400, Guillaume Theoret wrote: > Thanks for the response. > > On 6/13/07, Robert Cummings <[EMAIL PROTECTED]> wrote: > > On Wed, 2007-06-13 at 10:36 -0400, Guillaume Theoret wrote: > > > Hi everyone, > > > > > > Can anyone recommend any good books/resources for php and

Re: [PHP] php / mysql performance resources

2007-06-13 Thread Richard Lynch
On Wed, June 13, 2007 10:17 am, Robert Cummings wrote: > On Wed, 2007-06-13 at 10:36 -0400, Guillaume Theoret wrote: >> Hi everyone, >> >> Can anyone recommend any good books/resources for php and mysql >> performance management? I'm more interested in the software >> development side (as opposed t

Re: [PHP] php / mysql performance resources

2007-06-13 Thread Guillaume Theoret
Thanks for the response. On 6/13/07, Robert Cummings <[EMAIL PROTECTED]> wrote: On Wed, 2007-06-13 at 10:36 -0400, Guillaume Theoret wrote: > Hi everyone, > > Can anyone recommend any good books/resources for php and mysql > performance management? I'm more interested in the software > developme

Re: [PHP] php / mysql performance resources

2007-06-13 Thread Robert Cummings
On Wed, 2007-06-13 at 10:36 -0400, Guillaume Theoret wrote: > Hi everyone, > > Can anyone recommend any good books/resources for php and mysql > performance management? I'm more interested in the software > development side (as opposed to server configuration) of things. I'm > looking for anything

[PHP] php / mysql performance resources

2007-06-13 Thread Guillaume Theoret
Hi everyone, Can anyone recommend any good books/resources for php and mysql performance management? I'm more interested in the software development side (as opposed to server configuration) of things. I'm looking for anything that would be good to know when working on websites that get millions