Hello,
First post here, I'd like to thank everybody for the many answers I've
found here!
I've been using Django for a few years now (since 2008) and installed
different versions on Linux systems.
My problem now is that I HAVE to install Django on a windows server
(customer has only one computer running other services).
The computer is a Pentium III 591MHz with 2GB RAM.
I did install everything just fine :
- IIS
- xampp for mysql
- pyISAPIe for python and IIS
- my django app in IIS
- my database via phpmyadmin
I set the mysql engine to myISAM for performances and my.ini as a huge
database.
I do not use any DNS to get the database (127.0.0.1 in configuration
files)
I use keep alive connections in IIS
So, the problem is the app is very slow when hitting the database. For
instance, it takes like 30 seconds to save a short list of inlines in
an admin form.
I can't understand because my dev server, a Linux computer, is much
faster remotely.
This morning, I ran
C:\python -s cProfile -o stats.txt manage.py runserver
192.168.1.57:8080
The result is :
>>> p.strip_dirs().sort_stats('cumulative').print_stats(30)
Thu Jan 12 09:46:11 2012 stats.txt
100777 function calls (97825 primitive calls) in 1453.418 CPU
seconds
Ordered by: cumulative time
List reduced from 1564 to 30 due to restriction <30>
ncalls tottime percall cumtime percall
filename:lineno(function)
1 0.001 0.001 1453.422 1453.422 {execfile}
1 0.013 0.013 1453.420 1453.420 manage.py:2(<module>)
1 0.000 0.000 1453.162 1453.162 __init__.py:
431(execute_manager)
1 0.000 0.000 1453.152 1453.152 __init__.py:340(execute)
1 0.000 0.000 1451.760 1451.760 base.py:
182(run_from_argv)
1 0.000 0.000 1451.757 1451.757 base.py:193(execute)
1 0.000 0.000 1450.885 1450.885 runserver.py:39(handle)
1 0.000 0.000 1450.885 1450.885 runserver.py:69(run)
1 0.000 0.000 1450.885 1450.885 autoreload.py:129(main)
1 0.000 0.000 1450.885 1450.885 autoreload.py:
107(python_reloader)
1 0.000 0.000 1450.885 1450.885 autoreload.py:
96(restart_with_relo
ader)
1 1450.884 1450.884 1450.884 1450.884 {nt.spawnve}
56/40 0.001 0.000 1.925 0.048 importlib.py:
18(import_module)
65/41 0.057 0.001 1.924 0.047 {__import__}
1 0.000 0.000 1.387 1.387 __init__.py:
245(fetch_command)
3 0.018 0.006 1.016 0.339 __init__.py:3(<module>)
1 0.000 0.000 0.872 0.872 __init__.py:99(activate)
1 0.000 0.000 0.834 0.834 trans_real.py:
190(activate)
So, what is nt.spawnve?
And, does anybody has an idea?
Thanks
Anthony
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
