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): base_i

Django Simple Query very slow at thousand data.

2020-02-07 Thread Eric Kiser
Okay so I've used django on two of my projects with the following criteria: Hosted @: PythonAnywhere Database: MySQL and SQLite PROBLEM: At first with a few hundred data the query is okay, but when I am querying 2,000 of data it takes 3 minutes to load it on a simple table. This is not normal b