+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Slow performance on gallery->garbageCollect() (/thread-8745.html)
Slow performance on gallery->garbageCollect() - fatman - 2011-06-22
I found the speed to access album edit page is quite slow, after checking the code, the gallery->garbageCollect() take about 40s to run, if for a save operation, it load twice, so it will take double time.
The problem is it fetch all row in 'obj_to_tag' and loop to check each object exist in corresponding table or not. As a result, my gallery need to run above 10000 query for this the check.
I think it is quite easy to rewrite it in delete sub query. such as
DELETE FROM obj_to_tag WHERE type = 'album' and objectid not in (SELECT id FROM albums)
Maybe store different object types in option/constant if don't want to hardcode in program, or even SELECT DISTINCT type FROM obj_to_tag can do it(but not a good practice)
BTW, I just update to 1.4.1, the version.php got a extra empty line at beginning.
Slow performance on gallery->garbageCollect() - acrylian - 2011-06-22
Please open a ticket.
Slow performance on gallery->garbageCollect() - fatman - 2011-06-22
No password reset page on Trac?
Slow performance on gallery->garbageCollect() - acrylian - 2011-06-22
I fear not... at least I don't know it I admit... We could delete your account and you re-register...
Slow performance on gallery->garbageCollect() - fatman - 2011-06-22
OK...
(I believe my password on forum & trac is the same, strange that can't login trac)
Slow performance on gallery->garbageCollect() - acrylian - 2011-06-23
So shall we delete your account then?
Slow performance on gallery->garbageCollect() - fatman - 2011-06-23
OK to delete...