It seems like some thing in your app view. Did you try to dump real database and run localy in your workstation?
2017-07-18 16:05 GMT-03:00 Kevin Yu <[email protected]>: > > <https://lh3.googleusercontent.com/-jIXPWhwHNUw/WW5biPCMzlI/AAAAAAAADe4/BnmWrwpKd88NFW-PswfbXcBNZSN04c36ACLcBGAs/s1600/Screenshot%2Bfrom%2B2017-07-18%2B12-03-18.png> > > I even noticed when i do runserver on my local to connect to the older > version of mysql db, the starting of dev server is noticeably slower. > > What I mean is here: > kevin@kevin-OptiPlex-7020:~/repo/Infosite_Django/app$ python manage.py > runserver > Performing system checks... > > System check identified no issues (0 silenced). > July 18, 2017 - 19:00:12 > Django version 1.11.2, using settings 'infosite.settings' > Starting development server at http://127.0.0.1:8000/ > Quit the server with CONTROL-C. > > > On Tuesday, July 18, 2017 at 11:43:53 AM UTC-7, Felipe wrote: >> >> Try to debug in chrome.... just press F12 and go to network tab and see >> the times fot load content >> >> 2017-07-18 15:18 GMT-03:00 Kevin Yu <[email protected]>: >> >>> I've eliminated the possibility of mysql performance issue by directly >>> running the query on the database. It's not network issue either since my >>> ping is just fine. >>> >>> >>> On Tuesday, July 18, 2017 at 11:00:58 AM UTC-7, Kevin Yu wrote: >>>> >>>> Hi All, >>>> >>>> I'm rewritting an web application using Django 1.11. When i hooked up >>>> to my test mysql database (version 5.7), the performance is amazing. The >>>> page renders within 1 second. However, when I connect to the existing >>>> production mysql (version 5.1), the page takes more than 10 seconds. >>>> >>>> I installed the debug toolbar, and I found out the the query time is >>>> actually not the issue. Most of the time are in the CPU. >>>> >>>> I am wondering whether the Django is having issues with older mysql >>>> version when Django receives the data and try to map it to objects via ORM. >>>> >>>> >>>> <https://lh3.googleusercontent.com/-lti9EnCOwpI/WW5My639ZTI/AAAAAAAADes/gUJgzX0Wy5IvrGpf2xGDKFbAkoqN7za2gCLcBGAs/s1600/Screenshot%2Bfrom%2B2017-07-18%2B10-59-30.png> >>>> >>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Django users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at https://groups.google.com/group/django-users. >>> To view this discussion on the web visit https://groups.google.com/d/ms >>> gid/django-users/ac4201dd-5267-4566-8d0a-82b2b2f043c4%40googlegroups.com >>> <https://groups.google.com/d/msgid/django-users/ac4201dd-5267-4566-8d0a-82b2b2f043c4%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/django-users. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/django-users/9efab471-ae94-4ff2-a62c-67650638c4e0%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/9efab471-ae94-4ff2-a62c-67650638c4e0%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAEYpY_%2BZEvgOC9zovuE9hw2Mid68RN7Y%3DgDC2D0a7p46L5pY%2Bw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
