Customizing SMF > SMF Coding Discussion

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

<< < (5/8) > >>

Groovystar:
I cannot run queries so will have to ask my host if he will.

Will that reveal the place that the error's happening--the file or files it originates from?

Thank you so much for responding. We need this taken care of ASAP.

butch2k:
As far as i can tell the issue comes from the Member and Memberlist page.
I do not use this mod but i believe the number of subaccounts must appear somewhere on the members page. Indexing engines might be responsible for the queries if there are many bots indexing members at the same time.

Groovystar:
That's interesting, because we put that member list off limits to everyone but administrators some time ago. Or do you mean the members database tables or something?

butch2k:
The queries are used at different places but one of them seems to be used by the user management part of SMF and most likely the memberlist. I do not know this mod but use the CREATE INDEX i sent you as this index is clearly missing from the subaccounts table. How many members and subaccounts do you have on your forum ?

Did you manage to obtain the explain i requested some posts ago ?

Groovystar:
I have around 50,000 member and subaccounts in total.

What would running that query do? I've never run a query on my own and get really nervous at the prospect. Very sorry :(

Navigation

[0] Message Index

[#] Next page

[*] Previous page