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.
Quote from: Αndré on July 23, 2014, 12:20:05 PM
Don't forget to add some information what exactly needs to be indexed in your opinion.
Quote from: Αndré on July 23, 2014, 12:20:05 PM
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.
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.
OK.I am glad is no need to index.
Thanks.
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
Thanks Greg.
Andre updated redirect.php with the LIMIT 1 ideea.
http://forum.coppermine-gallery.net/index.php/topic,76683.40.html (http://forum.coppermine-gallery.net/index.php/topic,76683.40.html)