performance::this module adds 10 times nearly queries to the database!!!
haojiang - July 21, 2009 - 15:51
| Project: | Localization client |
| Version: | 6.x-1.7 |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
before using this module::
Executed 90 queries in 157.45 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 489.2 ms.
after using this module::
Executed 539 queries in 343.79 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 934.44 ms.
this is just the result by using cacherouter , if not using , may be worse
is there a way to just allow one user to using this module and the other could not , thus , the mysql will not be overload to the annoymous
#1
This should only ever happen to admin users, and is intended. Otherwise there would be no way to get the exact list of strings used for the page. If you can reproduce it slows down anonymous, then that is a bug. If it slows down admin this way, then it is intended. We have no way to identify which part of the big cache blob was used and many long strings are not in the cache blob even to display the interface properly.
#2
Also, not sure in what math 539 equals 10 times 90.
#3
actually , i don't want the first user (userID=1) to use this module ,
because i always use this user to do some hight-athority job