Re: Django query with few data(1,000-3,000) takes too long(1min) to load

2020-02-07 Thread Stephen J. Butler
You've got a lot of foreign key fields where the fetch is being deferred until template render time, and it being done individually for each row instead of in bulk. I think if you added this attribute to your ListView subclass you'd see better performance: queryset =

Django query with few data(1,000-3,000) takes too long(1min) to load

2020-02-07 Thread Eric Kiser
I created an app with the following details: Hosting: PythonAnywhere Database: SQLite and MySQL Problem: When I load the data in a table it takes minutes to load it. My data hasn't even reached a million its just a few thousands. How I did it: models.py class Outgoing(models.Model):