Databases
StackOverflow2013
Postsdbo
PODjango pagination on a largeset of data
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODjango pagination on a largeset of data
    text
    copied!<p>I am using a template for displaying a table which has more than <code>2000</code> rows.But implementing django pagination in this makes it too slow as the data is too much.What is the best way to go about this.Or how can i make the pagination load 200 rows per page and make the page faster. How can i make the page load faster</p> <pre><code> {% extends "base/admin_base.html" %} {% load pagination_tags %} {% autopaginate response_dict.taggeddata 100 %} &lt;div align="right"&gt;{% paginate %}&lt;/div&gt; &lt;form action="/users/saveuser/" method="post"&gt;{% csrf_token %} &lt;b&gt; &lt;table&gt; &lt;tr&gt;&lt;td&gt;&lt;font&gt;*&lt;/font&gt;Select Category group for tagging&lt;/td&gt;&lt;td&gt; &lt;select id="cgroup" onchange="getcategory('1');"&gt; &lt;!--&lt;option value="-1"&gt;Select Category group&lt;/option&gt; --&gt; {% for group in response_dict.categorygroup %} &lt;option value="{{group.id}}"&gt;{{group.name}}&lt;/option&gt; {% endfor %} &lt;/select&gt; &lt;/td&gt;&lt;/tr&gt; &lt;/table&gt; &lt;/b&gt; &lt;table id="box-table-a"&gt; &lt;colgroup&gt; &lt;col class="vzebra-odd"&gt; &lt;col class="vzebra-even"&gt; &lt;col class="vzebra-odd"&gt; &lt;col class="vzebra-even"&gt; &lt;col class="vzebra-odd"&gt; &lt;col class="vzebra-even"&gt; &lt;col class="vzebra-odd"&gt; &lt;col class="vzebra-even"&gt; &lt;/colgroup&gt; &lt;thead&gt; &lt;tr&gt;&lt;th id="vzebra-comedy" scope="col"&gt;Field1&lt;/th&gt;&lt;th id="vzebra-adventure" scope="col"&gt;Field2&lt;/th&gt;&lt;th id="vzebra-comedy" scope="col"&gt;Field3&lt;/th&gt;&lt;th id="vzebra-adventure" scope="col"&gt;Field4&lt;/th&gt;&lt;th id="vzebra-comedy" scope="col"&gt;Field5&lt;/th&gt;&lt;th id="vzebra-adventure" scope="col"&gt;Field6&lt;/th&gt;&lt;th id="vzebra-comedy" scope="col"&gt;Tag&lt;/th&gt;&lt;th id="vzebra-adventure" scope="col"&gt;Actions&lt;/th&gt;&lt;thead&gt;&lt;/tr&gt; &lt;tbody&gt; {% for td in response_dict.taggeddata %} &lt;tr id="{{td.id}}"&gt; &lt;td width="20%"&gt;{{td.field1}}&lt;/td&gt; &lt;td&gt;{{td.field2}}&lt;/td&gt; &lt;td&gt;{{td.field3}}&lt;/td&gt; &lt;td&gt;{{td.field4}}&lt;/td&gt; &lt;td&gt;{{td.field5}}&lt;/td&gt; &lt;td&gt;{{td.field6}}&lt;/td&gt; &lt;td class="tg"&gt;Select category&lt;/td&gt; &lt;td &gt;&lt;img src="/media/img/cancel.png" alt="delete" height="20" width="20" onclick="delete_row('{{td.id}}')"&gt;&lt;/td&gt; &lt;/tr&gt; {% endfor %} &lt;/tbody&gt; &lt;/table&gt; &lt;input type="button" value="Add" id="addbtn" onclick="validate();"/&gt; &lt;/form&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload