There is a problem with some drupalit querys.

oskar_calvo - April 4, 2009 - 08:50
Project:DrupalIt
Version:5.x-1.4-beta2
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:active
Description

I have a small/medium portal that let people to vote, the problem is that some query of drupalit take too much time, I'll paste from devel statics:

ms # where query
93.05 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 3097 AND uid = 1
76.59 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 3119 AND uid = 1
50.85 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 3118 AND uid = 1
47.29 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 3059 AND uid = 1
46.92 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 3043 AND uid = 1
46.83 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 3006 AND uid = 1
46.8 1 _drupalit_data SELECT * FROM drupalit_user_to_vote WHERE nid = 3060 AND uid = 1

I think that the Select all should be improve if it's possible, or only let see the vote in the full node and not in the teaser.

Thanks.

Oskar

 
 

Drupal is a registered trademark of Dries Buytaert.