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 django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. 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/ac4201dd-5267-4566-8d0a-82b2b2f043c4%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
