chronocomments fires 6 sql requests on frontpage

dolphinnose 08 Apr, 2009
Is it normal to fire 6 queries into the database on the first page? I am not sure how much of these are contributing to slowness. I set comments on blog view to false. When I set that true, more queries are sent to Database.

#
SELECT *
FROM jos_chrono_comments
WHERE component = 'com_content'
AND pageid= '53'
AND parentid='0'
AND published='1'
AND verify='1'
ORDER BY datetime ASC
#
SELECT *
FROM jos_chrono_comments
WHERE id = '3'
#
SELECT *
FROM jos_chrono_comments
WHERE parentid='3'
AND published='1'
AND verify='1'
ORDER BY datetime
#
SELECT *
FROM jos_chrono_comments
WHERE id = '4'
#
SELECT *
FROM jos_chrono_comments
WHERE parentid='4'
AND published='1'
AND verify='1'
ORDER BY datetime
#
SELECT *
FROM jos_chrono_comments
WHERE id = '5'
#
SELECT *
FROM jos_chrono_comments
WHERE parentid='5'
AND published='1'
AND verify='1'
ORDER BY datetime
Max_admin 15 Apr, 2009
Hello dolphinnose,

nice point, I will move this to the bugs forums and fix in the coming release!

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.