why you try update the databases 5.1 to 5.7? try dumpdate with manage.py django in .json all apps y then loaddata in new database!
https://docs.djangoproject.com/en/1.11/ref/django-admin/#dumpdata cheers On Tue, Jul 18, 2017 at 1:12 PM, Felipe Brunelli de Andrade < [email protected]> wrote: > 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%40goog >>>> legroups.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/ms >> gid/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 > <https://groups.google.com/d/msgid/django-users/CAEYpY_%2BZEvgOC9zovuE9hw2Mid68RN7Y%3DgDC2D0a7p46L5pY%2Bw%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- att. Carlos Rocha -- 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/CAM-7rO2meRJ31z%3D0%3D9h%3DseM1%3DtP5PLY_gP7NiwHT2XQC9fScag%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
