Show everything do not check for accessmap table

gaurav10feb

Joined: 2010-08-24
Posts: 31
Posted: Thu, 2010-11-11 05:45

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.

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2010-11-11 12:50

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

 
gaurav10feb

Joined: 2010-08-24
Posts: 31
Posted: Wed, 2010-11-17 00:29

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

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2010-11-17 00:55

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