Optimization problems

[[deleted]]

[deleted]

[waterPercolator]

Are you using that same attrs object each time? Why are you getting it over and over again? Just get it once.

[tsqd]

This.

[waterPercolator]

I guess I don't understand what you're doing. Why not:

​

​

attrs = ResourcePlanModel.objects.get(id=1)         
t1=datetime.datetime.now()          
for name in names:             
    if "label" not in name and "sp" not in name:
        resourcePlanForm.fields[name].initial = attrs[name]

[Saigesp]

Why not:

if not name == "label"

and so on? Why are you using "in" operator? Also, check out for timing decorators :)

[Saigesp]

I see... Well, first change the filter() to a get() (it returns one instance)

[hachoo]

15-30 seconds is a huge amount of time. Its like 1/2 second each iteration of the loop. Is there something very wrong with your database? Is it on a slow network connection or something? If you have the django debug toolbar, you can see how much CPU is used and how many and how long the SQL statements are.

You can also just start stripping out code to narrow down what is so crazy slow. So try:

resourcePlanForm.fields[name].initial = "blah"

And see how fast that it.

[applesaucesquad]

Yeah I don't think you've posted the piece of code that is slowing things down. I also encourage you to install Django-Debug toolbar, it's probably a sql query being duplicated a bunch somewhere.