First time here? Check out the FAQ!
Ask Your Question
1

Performance of settings page
 
   
  
 
 
Hi, I just installed Askbot and am trying to set things up.
For some reason saving settings on the /settings/...  pages takes forever, like minutes, and makes my server cpu run at 70-80%, and it's not even the database, because database is on separate server.
 
What on earth can it possibly be doing? Is that expected?
 
EDIT: Ehm... it's livesettings. Querying database for 1400 times for every setting. Wat.
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 ralexeev's avatar

      11
    
 
 
 
 ralexeev 
 
 
    asked 9 years ago,
        
    updated 9 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
  see more comments  
 
 
 
 
 
 1 Answer
  
  
  
 
 
 
 
0
 
 
  
 
 
 
 
 
 
It is very unusual, livesettings use cache heavily, so they should not query the database that much.
 
Have a look at the cache setup, use at least 'locmem' cache (ok for a single-process setup), but better redis or memcached.
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 Evgeny's avatar

      13.2k
    
 
 
 
 Evgeny 
 
 
    answered 9 years ago 
 
 
 
 
     link   
 
 
 
Comments
 
 
 
  see more comments