TOPIC: 5000+ SQL Querys to load page

Hi all -

I'm trying to identify why some of my DTR pages are loading so slow on both the front and back end.

I turned on System Debugging in Joomla (1.5.23). On the DTR->Records page, it's loading 3,858 queries (on a non-DTR page, it's 19). On the front end, listing programs in DTR, it's 5,116 queries.

Does this sound right? If not, can you recommend anything that would help combine those queries and speed up loading of my DTR pages? It can sometimes hang 20+ seconds before the page loads.

We currently have 441 events active on our system.

Thanks,

wow, I thought mine was bad at 750 or so. this is ridiculous.

These are the queries:

SELECT *
FROM jos_dtregister_group_member AS gm
INNER JOIN jos_dtregister_user AS u
ON u.userId = gm.groupUserId
INNER JOIN jos_dtregister_member_field_values v
ON v.member_id = gm.groupMemberId
WHERE v.field_id=28
AND CONCAT('|',v.`value`,'|') LIKE '%|1|%'
AND u.payment_verified = 1
AND u.eventId = 7

where it says "LIKE '%|1|%' - I have about 720 of them with every number from 1-50 it looks like for every single field I have. One field does this twice up to 200 so that one field has 400 queries. The id=30 field is a simple textual with <hr> in it. The field=28 is a radio field. To test it I first unpublished the field which did nothing. Then I deleted it entirely and it's still being queried 400 times. From what I count, the issue is only these 2 fields (28 and 30) that are accounting for about 500 or so queries.

**edit**

ok I found the issue - my fields 28 and 30 are Country and State fields that have tons of options as dropdowns. I converted both to text fields and the pages load normally now with normal queries.

Is this normal? This SQL load is killing my server. This site has thousands of users. When they are mass mailed about the meeting, the site almost stops because of this.

Sorry to say it, but if this is "just how it is" then this is a deal breaker. I was looking forever to find the source of my slow server and I think I just found it.