Dne Čt 3. prosince 2015 10:51:10, Anton Aylward napsal(a):
On 12/03/2015 07:52 AM, Vojtěch Zeisek wrote:
Also there are several, I'd say ordinary, webs using CMS like Drupal.
The you are going to get a lot of searches of the FIND WHERE AND nature, where one of the AND is going to be the user id. That is a problem for indexing, which again gets back to reads of the database.
Exactly
Most CMSs do logging, but whether you choose to log to the database or the file system depends on the options offered by the CMS. How you use the logs will be of importance here. Using them for accounting/billing seems wasteful when the function is better implemented n the application.
They are set to log into the database (not system), but usage of logs is extensive, basically just for statistics.
Some CMSs do various kinds of caching of their own, again you have options of how much of that can be in memory.
Yes, Drupal has it.
Check out 'memcached' and 'redis'.
Of course, tuning of the application itself is the most important step... -- Vojtěch Zeisek Komunita openSUSE GNU/Linuxu Community of the openSUSE GNU/Linux http://www.opensuse.org/ http://trapa.cz/