Index coppermine database (index coppermine tables)

[allvip]

Can you please,please help me index all the tables.
Is important for the database to use less server resources.
Is the default coppermine database.Nothing changed.
I belive all the copermine databases look the same.

[Αndré]

Don't forget to add some information what exactly needs to be indexed in your opinion.

[allvip]

what exactly needs to be indexed in your opinion.

I have no ideea.
The ex host was telling me to do that and I thought is something that everyone should do:index the database to make the website use less server resources.
I hate all that index ideea because I do understand nothing.
I searced google and tryed to understand how to do that and what it is and all I got is a head pain.

[Αndré]

Then I suggest to leave the database as-is. Some columns are already indexed. I haven't checked that in detail, but I assume there's no further indexing needed for a stock Coppermine installation.

[allvip]

OK.I am glad is no need to index.
Thanks.

[gmc]

I was away and couldn't respond to this thread.
I agree with Andre, that indexing is correct for a 'stock' Coppermine installation.

As I recall, you were doing something custom at high volume that was resulting in a table scan - which is why I suggested both the use of LIMIT and a new INDEX in your case.

Greg

[allvip]

Thanks Greg.
Andre updated redirect.php with the LIMIT 1 ideea.

http://forum.coppermine-gallery.net/index.php/topic,76683.40.html