Jørn Wildt

Hello all

I have a pn installation with a huge amount of folders.
Unfortunatly, after aprox 5000 albums, to add a new one takes about 2 minutes 99% cpu from mysql.
This because ms handles the hierachie of the folders in a very uneconomic way :(
and has to update each album separete.
Is there hope that this will be better in future?
Somebody with the same problem?

Where did you stored your images?
Filesystem oder mySQL-database?

I am planning to migrate a big menalto-gallery to mediashare. And after I read your post, I got frightened.

Does anyone has the same problems?



edited by: herr.vorragend, Oct 10, 2007 - 02:21 PM

It does not depend on disk or db storage.
The problem is inserting of a new folder in the album table and the needed updates to this table for the hirarchical structure. A new album leads to x updates (x = count of existing albums)
It also not depend on the amount of images, only on the count of albums.

so if you import once and don't have to insert new albums all the time, it does not affact you...
but on my system, the users can create albums, it realy sucks if it takes 40sec and the system has load 10 :)

mysql > 4.1 would support hirachical queries without having this structure, so jorn, maybe this should be used.



edited by: spax, Oct 13, 2007 - 05:27 PM

Please report this as a bug here: http://sourceforge.net/tracker/?group_id=92103&atid=599536.

I know how to fix it and will do it next time I get time for Mediashare.