Create Django formset without multiple queries

Question

I need to display multiple forms (up to 10) of a model on a page. This is the code I use for to accomplish this.

TheFormSet = formset_factory(SomeForm, extra=10)
...
formset = TheFormSet(prefix='party')

return render_to_response('template.html', {
        'formset' : formset,
})

The problem is, that it seems to me that Django queries the database for each of the forms in the formset, even though the data displayed in them is the same.

Is this the way Formsets work or am I doing something wrong? Is there a way around it inside django or would I have to use JavaScript for a workaround?

You might check the solution from this question stackoverflow.com/questions/15203207/… — Tomasz Zieliński
– Tomasz Zieliński, Commented Mar 15, 2013 at 22:35

Daniel Roseman · Accepted Answer · 2010-05-07 10:14:21Z

1

What happens if you use modelformset_factory instead of formset_factory? Does that help?

answered May 7, 2010 at 10:14

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Martin Over a year ago

It does not, Django still queries for each of the forms in the formset.

Matthew Schinckel · Accepted Answer · 2010-05-07 12:58:08Z

1

If the queries are all identical, it may be worth looking at johnny-cache, and see if that will improve performance.

answered May 7, 2010 at 12:58

Matthew Schinckel

35.7k6 gold badges91 silver badges122 bronze badges

Comments

dragoon · Accepted Answer · 2010-05-07 10:19:35Z

0

Are you sure that django queries database? Try to use Django Debug Toolbar to see what queries django actually makes.

answered May 7, 2010 at 10:19

dragoon

5,7845 gold badges39 silver badges56 bronze badges

2 Comments

Martin Over a year ago

Thanks for the suggestion. I installed the toolbar and it confirms the huge number of queries. The model has many foreign key fields, so to display on of the forms a total of 8 queries are performd, which is already a lot, so when I want to display 10 a total of 80 queries are made!

dragoon Over a year ago

Are you sure that queries to database are performed when you creating a formset? Or may be queries are made when you populate formset with data from database? Anyway, try to use [select_related][1] on your querysets to reduce the number of actual queries [1]: docs.djangoproject.com/en/dev/ref/models/querysets/#id4

Collectives™ on Stack Overflow

Create Django formset without multiple queries

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related