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
#
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
Hello dolphinnose,
nice point, I will move this to the bugs forums and fix in the coming release!
Regards,
Max
nice point, I will move this to the bugs forums and fix in the coming release!
Regards,
Max
This topic is locked and no more replies can be posted.
