Adult Script Pro Community Forums
The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!
You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#1 2013-02-12 09:53:01
- Jadmanx
- Member
- Registered: 2012-05-25
- Posts: 128
best Cache Settings for optimising
whats the best Cache Settings for sql.
i have a real big database and a hight load of it whats the best Cache Settings to optimise this ?
Cache Driver:
file
APC
Offline
#2 2013-02-12 10:09:49
Re: best Cache Settings for optimising
Use file. For APC you need a lot of memory or a lot of visitors (in which case the cache will be updated faster).
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#3 2013-02-13 23:49:51
- Mitomind
- Member
- Registered: 2012-06-27
- Posts: 166
Re: best Cache Settings for optimising
Once you get MySQL 5.6.10 larger databases will function better.
You might want to allocate more memory to MySQL in the my.cnf file located in the /etc/ folder (if you are using CentOS).
You might want to consider using Nginx and allocating the extra ram saved to MySQL.
Offline
#4 2013-02-14 07:52:29
Re: best Cache Settings for optimising
Are you saving the videos views ? (Admin -> Video -> Config -> Advanced) If yes, disable this setting.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#5 2013-05-20 07:36:48
- rbmoss
- Member
- Registered: 2012-08-17
- Posts: 36
Re: best Cache Settings for optimising
can both file and APC be used for caching for optimized result letting the program choose which methodology to use in optimized way. suppose if there are plenty of visitors program can switch to APC and then when visitor count drops it could switch file caching.
Offline
#6 2013-05-20 10:18:53
Re: best Cache Settings for optimising
The best method for caching is currently memcache. It should be used when you have a large number of visitors (100k). If you use it with a low number of visitors, it wont speed anything. You can use APC for a overall speed improvement.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Pages: 1