Hi,
if you install the devel module and have a look at the query times of drupalit you will find something like this (bold for time in ms):
219.99 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 17874 AND uid = 1
204.99 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 24559 AND uid = 1
204.11 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 24605 AND uid = 1
204 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 24572 AND uid = 1
203.7 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 24560 AND uid = 1
203.53 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 24536 AND uid = 1
203.48 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 24541 AND uid = 1
203.31 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 24546 AND uid = 1
This is an enormous amount, a performance killer!
Are there any ways to cache the querys on frontpage etc.? Or are there any ways in modifying the module (patch) to make it perform better?
Thank you very much!
| Comment | File | Size | Author |
|---|---|---|---|
| #5 | 227513.patch | 864 bytes | roychri |
Comments
Comment #1
funana commentedWe finally had to get rid of this module.
It leads to blank index and taxonomy pages and slows down the performance of the site dramatically.
That was very very ugly....
Comment #2
funana commentedChanged this to bug report because it really is a bug.
Comment #3
vpiotr commentedJust perform the following SQL in your MySQL console (e.g. phpMyAdmin):
Should be part of install script...
Comment #4
funana commentedThanks, but we had to uninstall the module.
Comment #5
roychri commentedHere's a patch for this.
Please review and either change the status to "reviewed & tested" or to "code needs work" and let me know what problems you had.
Thank you.