Emmanuel van der Meulen writes:
> Hello Monty,
>
> I downloaded and installed 4.0.1 for the SQL_CALC_FOUND_ROW option.
> However, the query runs 600% longer, so the saving I get with FOUND_ROWS()
> running in 0.0 secs does not serve me. Am I maybe doing something wrong?
>
> Here is what I did;
>
> I ran the query without SQL_CALC_FOUND_ROW and it runs in 2.61 secs.
> mysql> select * from memberships,membershipstracking where
> memberships.email=mem
> bershipstracking.email order by membershipstracking.activitytimestamp desc
> limit
> 1;
This truly depends on query. On some queries it is faster to use
SQL_CALC_FOUND_ROWS options, with others it is faster to run count(*).
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
