|
I have OSQA script running on Windows 2008/MySQL with Python via Helicon Zoo. When I open it via web, each single user/browser causes Python.exe process to work really hard. When I open 15-20 browsers, the CPU loads almost 100% (see attachments). I have a fast 8-core CPU but each open browser uses up the whole core. It worked fast enough in the beginning (I had 2-3 questions) but it's now very slow when I have 20+ questions. The homepage with the list of questions is especially slow - it takes 30+ seconds to load. One browser open:
15+ browsers open:
showing 5 of 6
show 1 more comments
|
|
You must have something seriously wrong in your config. We routinely run OSQA sites with 10,000+ questions and operate with near-zero average loads. |
|
Please check this article and find "Static content" chapter. This is usual case when Python is trying to operate on every static file, causing every request running as tens or hundreds requests. Thy to apply static content fix form the article. |
Thanks for the hint. I added a special "web.config" inside /m/ folder so that static files are processed via IIS, not Python/Django. It reduced the load significantly.
Also, you should start using memcached if not using it yet. Will help a lot.
The problem returned :(
I know its easy to blame OSQA, neither microsoft, or the python people, or even the django people would give much attention to your problem, but I can assure you its not OSQA's fault. The server where this site is running has several OSQA sites running on it, one of which with near 20k questions!! There is also jira and fisheye, etc, all running in this server.
Didn't mean to blame anybody. Just looking for a solution specific to my situation. I guess every bit of technology contributes to the problem.
Are you using anything like wsgi but for windows? Right now it looks like you're having to spawn a separate python process for each request. This likely isn't going to work real well and will chew into the processors for each request.