How to Archive ? How to Archive ?
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

How to Archive ?

Started by zany_brainy, January 21, 2005, 01:07:38 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

zany_brainy

January 21, 2005, 01:07:38 AM
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

kegobeer

#1
January 21, 2005, 01:20:05 AM
Don't double post.  I moved your identical post in Upload to the crap bin.
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Joachim Müller

#2
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

zany_brainy

#3
January 28, 2005, 08:47:25 AM
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

Joachim Müller

#4
January 28, 2005, 04:22:18 PM
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
Print
Go Up Pages1
User actions