Favorite tips link

Django Self contained filter() Inquire about model Table skills

1.filter The screening criteria for

2.filter Multi criteria query of

3. Yes model Foreign key query
In fact, it's equivalent to model Set the foreign key name ( F_modelname ) It points to Ben model Another link to the foreign key mode, So the usage is ： Foreign key name F_modelname__ Foreign keys model Field __ filter = ”xxxxx“

BootStraptable Using skills

Basic use
BootStraptable Parameters
Parameters are basically used

JS string manipulation

JS Complete collection of string processing

Django View function of view

Django View function of view

Django Improve rendering speed

There is a project , once filter Out of Queryset Yes 4000 Multiple data , Every piece of data 7、8 A field
So much data is used {%for%} Iterative rendering to the front end takes 20s many , Too slow
Searched for ways to improve rendering speed for half a day , I don't know what to say
And then I wonder if it could be Queryset The problem of data structure , Iterative access is too slow
And search for it , There is really this problem , Then the solution is to use values_list(), Dictionary （ Key value pair ） Structure into tuples （ Pure value ）
Final 4000 It takes a few seconds to render the data ,1000 Less than... Pieces of data 1 second
Use as follows ：

data = StudentCgg.objects.filter((Q(id__icontains=q) | Q(name__icontains=q)) & Q(age__icontains=q)).values_list()
data = StudentCgg.objects.all().values_list()

The rendering uses the following ：
{% for val in data %}
{ { val.id }} ==> { { val.0 }}
{ { val.name }} ==> { { val.1 }}
{ { val.age }} ==> { { val.2 }}
{% endfor %}
Subscript order is in the order of table fields
This is the website that provides my ideas