Django query optimization

Question

I have a model with a lot of entries (more than 12,513,262) and they are supposed to increase exponentially. But the problem is due to this large no. entries querying is taking a lot of time is there a way to increase performance using indices etc.

My query is like this:

MyModel.objects.all().order_by('-timestamp')[0:50]

and its taking a lot of time to execute.

@Glycerine, of course! Now, I understand why about 12513262 entries ;) — dani herrera
– dani herrera, Commented Nov 30, 2011 at 16:21

second · Accepted Answer · 2011-11-02 14:29:35Z

4

do you have an index on the timestamp field?

if you use south (for database migrations, you should definitely look into it if you aren't already), you can just add db_index=True to your field and migrate. Otherwise you can run

./manage.py sqlindexes MyApp

to show the sql statement adding the index. (which you need to run manually, e.g. using

./manage.py dbshell

edited Nov 2, 2011 at 14:29

answered Nov 2, 2011 at 12:44

second

28.8k8 gold badges80 silver badges77 bronze badges

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

2 Comments

Abhi Over a year ago

i don t have any index yet can i create one now if yes how to do that ?

Chris Pratt Over a year ago

If you haven't been using South, you'll need to create the index manually with the appropriate SQL. That will vary based on what DB you're using. Ask Google: "create index [my database brand]"

Collectives™ on Stack Overflow

Django query optimization

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related