Hey all !
I seem to be having a problem for the last few years:
There is a number of problems BUT this is the main:
When you open http://www.mysite.com/showmembers.php/cat/500
it selects ALL the pictures in database from this category (~10k) and loads into memory
then it counts pictures and cuts the required number of pictures and page
so it takes a very long time to load, because all these operations must be executed in the database and use index. So it will be executed 10-20sec.
This loads the site down and kills my google ad revenue.
WTS: I want to update my site that has close to 50k in members and 300k in photos, but I also want to add the SEO
functions I've read here but am afriad the SE bots will even load/slow the site down even more.
If anyone can help me with this solution I would be greatful.