forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: allvip on July 23, 2014, 12:25:49 pm

Title: Index coppermine database (index coppermine tables)
Post by: allvip on July 23, 2014, 12:25:49 pm

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.

Title: Re: Index coppermine database (index coppermine tables)
Post by: Αndré on July 23, 2014, 12:27:52 pm

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.

Title: Re: Index coppermine database (index coppermine tables)
Post by: allvip on July 23, 2014, 12:31:46 pm

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.

Title: Re: Index coppermine database (index coppermine tables)
Post by: Αndré on July 23, 2014, 12:53:11 pm

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.

Title: Re: Index coppermine database (index coppermine tables)
Post by: allvip on July 23, 2014, 12:59:04 pm

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

Title: Re: Index coppermine database (index coppermine tables)
Post by: gmc on July 26, 2014, 02:19:53 pm

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

Title: Re: Index coppermine database (index coppermine tables)
Post by: allvip on July 26, 2014, 07:28:09 pm

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)