Posted by Michael Fesser on 01/08/07 18:25

..oO(Erwin Moller)

>SO if you want to speed up your query, try to find out what it is spending
>its time on, or make a lucky guess.

For "profiling" a query the EXPLAIN clause can be very helpful, even if
the result might be a bit difficult to understand:

EXPLAIN SELECT ... FROM ...

Micha

• Next in forum: Re: PHP newbie. Storing sensitive data
• Prev in forum: pear DB converting ' to &#039 - how to convert back?
• Thread view: Re: What is Indexing in mysql and how it will be useful and how we can retrieve database content easily from a database table containing about 5lakhs datas

[Reply to this message]