Caching of user's number of pictures? Caching of user's number of pictures?
 

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

Caching of user's number of pictures?

Started by amirw2k, December 06, 2005, 04:59:01 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

amirw2k

Hello Dev Team,

Is it possible to add another field to the users table that will cache the number of pictures that belong to that user? My request is mainly related to bridging this also to an external bulletin board such as phpBB so I can show the number of pictures of each user near every message he posts. If you can call an UPDATE query on every upload or deletion of an image to the bridge (or coppermine's internal database), I can set it to update a new field in the users table and use it without overloading the database with queries.

Thanks for your response,
Amir W.

Joachim Müller

various caching mechanisms are being discussed to improve performance for large installs for cpgNG (aka cpg2.0), but don't expect anything like this happening that soon.