Hi,

When I clicked on vote details of a node with 1200 votes Debug show the horrible image:
Executed 6223 queries in 535.77 milliseconds.

6000+ queries isn't too much?

Any fix or cache optimization? Or maybe just a pager?

Thanks

Comments

marvil07’s picture

marvil07 commented
Category: support » bug
Status: Active » Closed (cannot reproduce)

It is actually a pager query, so at most that table information is generated by two queries, one for the content and one for the count query.

If you can point me to the query that is being executed 6223 times for your site, and that query comes from vote up/down please reopen this ticket.