Re: improve speed of PHP answers

On Thu, Feb 10, 2011 at 5:18 AM, Alex Nikitin <niksoft@gmail.com> wrote: <snip> > > One, while sorting and limiting, and improving mysql queries is a great way > to increase application performance, dont forget that sql is not a > programming language and as such certain tasks should not be done in > queries, any complex computations for example would execute faster in php > then they would in mysql (tested). > <snip> Optimizing the backend for speed goes beyond just SQL query optimization. Is the DB structure optimized? Example: best usage of column type & column size? Do you have any indexes? Are you over normalizing the tables? Queries makes full use of indexes? etc... Basic DB structure is fine when you have very small # rows. Once the rows count reach hundreds of thousands, or worse, millions, you'll need to have an optimized DB structure. If you're limited on knowledge and experience on RDBMS, time for major readings or ask a friendly DBA. Regards, Tommy