Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
But, Why is the Admin Slow?
Search
Jacinda Shelly
September 08, 2015
Technology
450
1
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
But, Why is the Admin Slow?
DjangoCon 2015 Talk
Jacinda Shelly
September 08, 2015
Transcript
48 slides
BUT, WHY IS THE ADMIN SLOW? Jacinda Shelly DjangoCon 2015
ABOUT ME • Platform Engineer at Doctor On Demand •
Been using Django for 4+ years • Given two tutorials on the admin • Second time speaking at DjangoCon • Love reading and rowing
SO, YOU JUST STARTED USING THE ADMIN
FIRST, YOU FEEL LIKE THIS
None
THEN PEOPLE START USING IT
None
BUT THEN…
None
AND NOW YOU’RE DEALING WITH…
None
A LIBRARY
None
class LibraryUser(AbstractUser): ''' Custom user for our library project. Inherits
from AbstractUser, which has the following fields: - username - first_name - last_name - email - is_staff - is_active - date_joined ''' birthdate = models.DateField('Date of Birth', null=True, blank=False) gender = models.CharField('Gender', max_length=1, choices=GENDER_CHOICES, blank=False) books = models.ManyToManyField('stacks.Book', through='stacks.LoanedBook') def __unicode__(self): return self.get_full_name()
class Author(models.Model): last_name = models.CharField(max_length=32) first_name = models.CharField(max_length=32) def __unicode__(self):
return self.full_name()
class Book(AbstractItem): authors = models.ManyToManyField(Author, related_name='works') page_count = models.PositiveIntegerField() title
= models.CharField(max_length=4000) daily_fine = models.DecimalField( max_digits=4, decimal_places=2, default='0.25', help_text=_("Amount the patron will be fined per day for an overdue library book")) def __unicode__(self): return self.title
class LoanedBook(models.Model): patron = models.ForeignKey(settings.AUTH_USER_MODEL) book = models.ForeignKey(Book) checkout_date =
models.DateField() due_date = models.DateField() return_date = models.DateField(null=True, blank=True) times_renewed = models.IntegerField(default=0) fine_paid = models.NullBooleanField() def __unicode__(self): return ': '.join([str(self.patron), str(self.book)])
https://github.com/django-debug-toolbar/ django-debug-toolbar INSTALLED_APPS = ( # … 'debug_toolbar' )
Quick Tip! * INTERNAL_IPS is a whitelist of IPs making
requests to your server
None
None
None
def __unicode__(self): return ': '.join([str(self.patron), str(self.book)]) Problem: Solution 1: @admin.register(LoanedBook)
class LoanedBookAdmin(admin.ModelAdmin): list_display = ('patron', 'book') Solution 2a: @admin.register(LoanedBook) class LoanedBookAdmin(admin.ModelAdmin): list_select_related = True Solution 2b: @admin.register(LoanedBook) class LoanedBookAdmin(admin.ModelAdmin): list_select_related = ('patron', 'book')
None
@admin.register(LoanedBook) class LoanedBookAdmin(admin.ModelAdmin): list_select_related = ('patron',) Let’s Try:
None
None
@admin.register(LoanedBook) class LoanedBookAdmin(admin.ModelAdmin): list_select_related = (‘patron’, ‘book') Full Solution 2b:
None
@admin.register(LoanedBook) class LoanedBookAdmin(admin.ModelAdmin): list_select_related = ('patron', 'book') def get_queryset(self, request):
qs = super(LoanedBookAdmin, self).get_queryset(request) qs = qs.only('patron__first_name', ‘patron__last_name', 'book__daily_fine') return qs Well, let’s see…
None
None
@admin.register(LoanedBook) class LoanedBookAdmin(admin.ModelAdmin): list_select_related = ('patron', 'book') def get_queryset(self, request):
qs = super(LoanedBookAdmin, self).get_queryset(request) qs = qs.only('patron__first_name', ‘patron__last_name', 'book__title') return qs Fixed!
None
Now, we want to try something else # models.py class
Book(AbstractItem): authors = models.ManyToManyField(Author, related_name='works') def authors_display(self): return '; '.join([str(author) for author in self.authors.all()]) # admin.py @admin.register(Book) class BookAdmin(admin.ModelAdmin): list_display = ('__unicode__', 'authors_display') list_select_related = True
None
None
Solution @admin.register(Book) class BookAdmin(admin.ModelAdmin): list_display = ('__unicode__', 'authors_display') def get_queryset(self,
request): qs = super(BookAdmin, self).get_queryset(request) qs = qs.prefetch_related('authors') return qs
None
None
Next Up - Counting! # models.py class Author(models.Model): def book_count(self):
return self.works.count() # admin.py @admin.register(Author) class AuthorAdmin(admin.ModelAdmin): fields = ('first_name', 'last_name') list_display = ('__unicode__', 'book_count')
None
Custom Querysets to the Rescue (again)! from django.db.models import Count
@admin.register(Author) class AuthorAdmin(admin.ModelAdmin): fields = ('first_name', 'last_name') list_display = ('__unicode__', 'book_count') def get_queryset(self, request): qs = super(AuthorAdmin, self).get_queryset(request) qs = qs.annotate(book_count=Count('works')) return qs
None
None
Side Note # models.py class Author(models.Model): def book_count(self): return self.works.count()
book_count.admin_order_field = 'book_count'
A FEW RANDOM NOTES Decrease ModelAdmin.list_per_page Set ModelAdmin.show_full_result_count to False
Remove pagination
THANK YOU @jacindashelly
[email protected]
More Decks by Jacinda Shelly
See All by Jacinda Shelly
But Why is the (Django) Admin Slow? - PyCon 2019
jacinda
0
140
Programming After Progeny: A New Parent's Perspective
jacinda
0
40
Other Decks in Technology
See All in Technology
AWS Well-Arhitected Frameworkセキュリティの柱 について
miu_crescent
PRO
2
250
ワークフローからハーネスへ — Web フレームワークの作者たちが AI エージェントに向かう理由
azukiazusa1
2
830
お風呂場をサーバルームにしよう
yusuke427
0
400
ブース設計、 お前もプロダクトだったのか / So Booth Design Was a Product All Along
akihiro0038
0
150
現地速報! Microsoft Ignite アップデートレポート
kasada
1
460
技術書典で本を売る流れ
yoshimura_datam
0
130
【Oracle AI SPOTLIGHT ウェビナー】AI時代、狙われるデータと止められない業務をどう守るか?
oracle4engineer
PRO
1
140
Kansai WordPress Meetup@大阪『ブロックテーマを作る上で知っておくべきこと
torounit
0
310
Re:ゼロから始めるシェアハウスのペットな鯖
silmin_
0
270
フロントエンドのテストカバレッジは 100%強制がいい
bengo4com
5
1.5k
Del vibe coding a un Desarrollo (agéntico) fiable
jcabot
0
220
Agent Routerで作るマルチテナント 推論基盤 #CNDW2026 / Building Multi-Tenant Inference Platform with Agent Router #CNDW2026
everpeace
5
600
Featured
See All Featured
Marketing to machines
jonoalderson
1
6k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
56
3.5k
Leveraging Curiosity to Care for An Aging Population
cassininazir
1
580
Digital Ethics as a Driver of Design Innovation
axbom
PRO
2
560
Agile Leadership in an Agile Organization
kimpetersen
PRO
0
320
Keith and Marios Guide to Fast Websites
keithpitt
413
23k
Beyond borders and beyond the search box: How to win the global "messy middle" with AI-driven SEO
davidcarrasco
3
310
Google's AI Overviews - The New Search
badams
0
1.7k
WCS-LA-2024
lcolladotor
0
1k
16th Malabo Montpellier Forum Presentation
akademiya2063
PRO
0
470
Ethics towards AI in product and experience design
skipperchong
2
470
Why You Should Never Use an ORM
jnunemaker
PRO
61
10k