Customizing SMF > SMF Coding Discussion

Slow queries, need help badly {Urgent!!}{Live627 This is Your Code I need Help!}

(1/8) > >>

Groovystar:
I am getting slow queries on my site:


--- Quote ---| 40728076 | warrior_acorn | 192.168.1.1:60201 | warrior_smf | Query | 4858 | Sending data | SELECT COUNT(mem.id_member)
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id |
| 40728689 | warrior_acorn | 192.168.1.1:34790 | warrior_smf | Query | 4833 | Sending data | SELECT COUNT(mem.id_member)
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id |
| 40728800 | warrior_acorn | 192.168.1.1:35292 | warrior_smf | Query | 4827 | Sending data | SELECT COUNT(mem.id_member)

--- End quote ---

This seems to be problems with a mod, the subaccount mod that was custom modified by Live.

We have had problems with this mod for a long time. Would anyone be able to give it a little tweak or show me how I could?

live627:
Which file?

Groovystar:
I am not sure, just know that this slowness required a restart of mySQL. I found these in the Cpanel error area earlier.

Subaccounts have often caused slow queries on my site, they are extremely popular hit with the members so they get heavily used.

live627:
Yep, yep, could be near a million 'subaccounts.

Do the errors include the URL? That, alone, would tell me the file.

Groovystar:
Unfortunately they do not.

This has happened again tonight. Site crashed, slow queries, same ones.

Okay--Would it help to first list all the files that are involved with subaccounts?

We can then at least narrow it.

Navigation

[0] Message Index

[#] Next page