Hello my website has 50,000 images and its getting really really slow...i have done everything to make it fast and wants to know if there is any way i can stop the script to check the access from accessmap table as i have 200,000 records in that table.
Posts: 8339
that table has to do w/ permissions, unless every item/album has the same permission, then no.
gallery should be caching that anyways.
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 31
Thanks for replying suprsidr...yes its same permission for every file..and i believe script dont have to go and check for each image...this might make it faster
Posts: 16504
Start with these docs:
http://codex.gallery2.org/Gallery2:ACL_Performance
http://codex.gallery2.org/Gallery2:Performance_Tips
It's not G2 that's slow, it's either a low-end shared server, disk i/o, poorly configured or overloaded network (if DB is on a separate box) or poorly configured web or database server. 50,000 images is nothing.
http://codex.gallery2.org/Gallery2:Scalability
Some more info here:
http://gallery.menalto.com/node/82413#comment-288705
Really, you've not given a lot of information. For instance you've not mentioned anything about your configuration, what plugins you have installed, what theme you're using, how much traffic you're getting, etc
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here