Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
758 views
in Technique[技术] by (71.8m points)

python - Why is django ORM so much slower than raw SQL

I have the following two pieces of code:

First, in SQL:

self.cursor.execute('SELECT apple_id FROM main_catalog WHERE apple_id=%s', apple_id)
if self.cursor.fetchone():
    print '##' 

Next, in Django:

if Catalog.objects.filter(apple_id=apple_id).exists():
    print '>>>'

Doing it the first way is about 4x faster than the second way in a loop of 100k entries. What accounts for Django being so much slower?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

Typically ORMs go to the trouble of instantiating a complete object for each row and returning it. Your raw SQL doesn't do that, so it won't take the penalty that incurs. For large result sets where you don't intend to use the object, it is better to bypass the ORM.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

1.4m articles

1.4m replys

5 comments

57.0k users

...