Very Very Very Slow

[parentingdiscussions]

[TwinsX2Dad]

Agreed.   

Have you tried indexing your tables?

[G6Cad]

Have you tried indexing your tables?

Tutorial please Twins

Whats that, and how to do it ? 

[IchBin]

Maybe something to try would be to create a new database. Then export each table one by one and put them in the new database one by one. Then you can see which Table is causing it, if it is...

[TwinsX2Dad]

Indexing the fields in your database is a simple task, if you have phpMyAdmin, but could be a little time consuming. It is done much quicker from command line, but the minute I try to describe that function here, someone will crash their database - plus most don't have command line access.

Open phpMyAdmin and select your database.

Then open each table (view structure). Select the fields desired (or select all) and choose the index function.

Pretty simple operation and it can speed up your database as well as make optimization more efficient. It can increase your DB size, though - so if you're pressed for disk space, you might think twice before a wholesale indexing operation.

Start with the boards table.

[G6Cad]

Open phpMyAdmin and select your database.

Then open each table (view structure). Select the fields desired (or select all) and choose the index function.

Pretty simple operation and it can speed up your database as well as make optimization more efficient.

Thanks Twins, will take a go at it right now and see it there is any emprovement.

[TwinsX2Dad]

If I remember correctly, you will need to make some modifications to some tables. A serious flaw in SMF is it doesn't always create, handle or update tables correctly or completely.

[stigmartyr]

Maybe something to try would be to create a new database. Then export each table one by one and put them in the new database one by one. Then you can see which Table is causing it, if it is...

OMGz :O  I would rather 'DELETE' and start all over than waste my life scanning thru SQL tables .. and desperately fighting them to work right hehehe.  That is unless Im billing by the hour.

[parentingdiscussions]

It is going to work one way or the other!!!

[G6Cad]

OMGz :O  I would rather 'DELETE' and start all over than waste my life scanning thru SQL tables .. and desperately fighting them to work right hehehe.  That is unless Im billing by the hour.

I think of it like this...

Twins gave a thought of how to maby find the error and see if it help.

I try it out, see what comes from it, maby it does get better, maby it dont, but in the process, even if it is a bit boring, i learn something from it
So it aint all that bad to atleast try the diffrent ways for fixing things, especially if there comes a good idea on a way to perhaps solve the problem