Hi,

I am trying to cut down the queries loading for Mysql, so I enabled Debugging of my Joomla! 1.0.15 site and check the number of queries on my front end.

I am too sure how to read those datas...but I was told to try to cut down to less than 50 queries for each page.

I noticed that All Videos Plugins seems to create duplicates queries... here is what was shown on my Home Page:

39
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'40
SELECT *
FROM jos_mambots
WHERE id = '22'41
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'42
SELECT *
FROM jos_mambots
WHERE id = '22'43
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'44
SELECT *
FROM jos_mambots
WHERE id = '22'45
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'46
SELECT *
FROM jos_mambots
WHERE id = '22'47
SELECT p.id, p.title
FROM jos_polls AS p
INNER JOIN jos_poll_menu AS pm ON  pm.pollid = p.id
WHERE ( pm.menuid = 1 OR pm.menuid = 0 )
AND p.published = 148
SELECT id
FROM jos_menu
WHERE type = 'components'
AND published = 1
AND link = 'index.php?option=com_poll'49
SELECT id, text
FROM jos_poll_data
WHERE pollid = 16
AND text != ''
ORDER BY id50
SELECT id, name, link, parent, type, menutype, access
FROM jos_menu
WHERE published = 1
AND access <= 0
ORDER BY menutype, parent, ordering51
SELECT *
FROM jos_banner
WHERE showBanner=1
ORDER BY RAND()52
SELECT * FROM jos_events_sessions WHERE ( `status` = '1' ) AND ( `published` = '1' ) AND ( `availability` in (0,2,3) ) ORDER BY 353
select id,htmlUrl from jos_gcalendar where name='Calendar'54
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'Calendar Full View'
AND published = 1
AND access <= 0
ORDER BY parent, ordering55
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'56
SELECT *
FROM jos_mambots
WHERE id = '22'57
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'58
SELECT *
FROM jos_mambots
WHERE id = '22'59
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'60
SELECT *
FROM jos_mambots
WHERE id = '22'61
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'62
SELECT *
FROM jos_mambots
WHERE id = '22'63
SELECT guest, usertype
FROM jos_session64
SELECT SUM( hits ) AS count
FROM jos_stats_agents
WHERE type = 165
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'66
SELECT *
FROM jos_mambots
WHERE id = '22'67
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'68
SELECT *
FROM jos_mambots
WHERE id = '22'69
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'70
SELECT *
FROM jos_mambots
WHERE id = '22'71
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'72
SELECT *
FROM jos_mambots
WHERE id = '22'

I don't have the video shown in the Home page. And for your information, I only have 1 video for my entire site.

If I browse to the page where I have that 1 video. The number of queries reduced a little... these are what I have for All Videos Plugins:

44
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'45
SELECT *
FROM jos_mambots
WHERE id = '22'46
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'47
SELECT *
FROM jos_mambots
WHERE id = '22'48
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'49
SELECT *
FROM jos_mambots
WHERE id = '22'50
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'51
SELECT *
FROM jos_mambots
WHERE id = '22'

I have been facing problem with my host due to Mysql overloaded... so I am looking into several issues involved in reducing Queries and one of it is components, modules and mambots. All Videos plugins is really a cool tool for the site... I really want to keep it. But I cannot help imagine what will happen if I add tones of videos to my website?

Please advise if there is ways to cut down on queries? or will the new 3.0 version solve this problem?

Thanks a lot!