I have a problem,
I need all you coppermine super-experts to put your brains on this as it could be a nice feature (I hope it is already available though)
Here is the situation
1) I host a gallery where my users can register and upload pictures to some general galleries as well as create their own personal albums
2) I am getting to a point where I have more than 30,000 pictures so coppermine and server and everything is getting slow.
3) I want to split the gallery into an archive and a current section. I want to keep pic uploaded in the last 2-3 months in the current gallery and keep all the historical pictures along with the comments and votes in the archive gallery.
4) This will speed up the current gallery and when people want to see older pics they can endure the slowness.
What you guys suggest ?
Thanks
ZB
Don't double post. I moved your identical post in Upload to the crap bin.
remove some elements that cause extra queries (e.g. random/lastup etc.) from "the contents of the mainpage" to speed coppermine up. Post a link for details.
Joachim
Quote from: GauGau on January 21, 2005, 12:07:46 PM
remove some elements that cause extra queries (e.g. random/lastup etc.) from "the contents of the mainpage" to speed coppermine up. Post a link for details.
Joachim
So,
Basically you are saying that all you super brains have not thought of that at all..
Well Ok,
I will get to work then, and If I come up with a shareable solution, I will post it here.
Thx
ZB
Quote from: zany_brainy on January 28, 2005, 08:47:25 AM
Basically you are saying that all you super brains have not thought of that at all..
We have thought of larger galleries as well. Larger galleries result in a high number of data sets in your database, which will slow the queries down. This is a matter of design, which could only we worked around if some queries were cached (or rather: query
results were cached). Coppermine offers great flexibility, you can turn on or off many whistles and bells. If you turn on everything that can be turned on, the load on your server will rise. This is only natural, you will experience the same in all other web apps that use databases as well. Posting inadequate insults won't win you friends around here >:(; you should instead have done what I suggested and should have posted a link to your site; taking a look at it we might have come up with better advice ::).
Joachim