View Single Post

   
  #6 (permalink)  
Old 02-28-2008, 11:27 AM
Lo'oris
 
Posts: n/a
Default Re: adding LIMIT 1 to improve performance?

On 16 Set, 20:10, Brian Wakem <n...@email.com> wrote:
> Why don't you write a script to benchmark it? Do it with and without LIMIT
> 1 a few hundred thousand times each, repeat the test half-a-dozen times and
> post your results.
>
> Make sure you turn off query cache first if the queries are selects.


great idea!! I'll let you know (but not soon, I'll do that in later
stages in this case

Reply With Quote