Big Data base problem
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.
what version are you using?
There is no showgallery all anymore
6.01 ..........................Thanks Chuck..
ah yes thats a real old gallery indeed, I would suggest upgrading our current is 7.02 your gallery is over 2 years more like 2.5 years old.
Thanks as always.. link to upgrade? Please?
Chuck, a bit confused here when I upgrade is it Renew Members Area Access ? I also have 2 licenses?
yes SEO is included in 7.x series
You would purchase a members area renewal for the license you want to download sure. I assume here your going to download it and do your upgrade then renew members access is what you purchase if your access is expired.
|All times are GMT -5. The time now is 08:18 AM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0