- Committer: Dylan McCall
- Date: 2010-06-23 03:14:51 UTC
- Revision ID: dylanmccall@gmail.com-20100623031451-5t8ac1dcjr341vrv
Tinkering with QuerySet stuff for performance.
opportunities_list QuerySet is filtered by selected packages in all cases again. (Filter added when it is first created in views.py).
Filtering alone (not counting display of package info) is down to 4 SQL queries total in all cases; one database hit for each model. Still feels heavy and needs some tuning, but it is balanced. Biggest possible query still takes 5 seconds of CPU time, but it no longer kills the server.
opportunities_list QuerySet is filtered by selected packages in all cases again. (Filter added when it is first created in views.py).
Filtering alone (not counting display of package info) is down to 4 SQL queries total in all cases; one database hit for each model. Still feels heavy and needs some tuning, but it is balanced. Biggest possible query still takes 5 seconds of CPU time, but it no longer kills the server.
| Filename | Latest Rev | Last Changed | Committer | Comment | Size | ||
|---|---|---|---|---|---|---|---|
 ..
|
|||||||
common
|
104 | 15 years ago | Daniel Holbach | initial cut at porting Harvest to Django - very br |
|
||
|
filters
|
195 | 14 years ago | Dylan McCall | Organized filters_base.py into its own module Spl |
|
||
|
locale
|
104 | 15 years ago | Daniel Holbach | initial cut at porting Harvest to Django - very br |
|
||
|
media
|
104 | 15 years ago | Daniel Holbach | initial cut at porting Harvest to Django - very br |
|
||
|
opportunities
|
104 | 15 years ago | Daniel Holbach | initial cut at porting Harvest to Django - very br |
|
||
|
templates
|
104 | 15 years ago | Daniel Holbach | initial cut at porting Harvest to Django - very br |
|
||
__init__.py |
104 | 15 years ago | Daniel Holbach | initial cut at porting Harvest to Django - very br | Empty |
|
|
manage.py |
124 | 15 years ago | jgraeme | Use env for a more flexible hashbang | 546 bytes |
|
|
|
settings.py |
195 | 14 years ago | Dylan McCall | Organized filters_base.py into its own module Spl | 4.5 KB |
|
|
|
urls.py |
129 | 15 years ago | jgraeme | Fix deprecated way of registering the admin views | 693 bytes |
|
|
|
version |
181.1.1 | 14 years ago | Daniel Holbach | add script to add release information, include it | 30 bytes |
|
|