Yes, my local database is actually a mysqldump of the production so in terms of data set, it's the same
On Jul 18, 2017 12:13 PM, "Felipe Brunelli de Andrade" < fbruandr...@gmail.com> 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 <samsun...@gmail.com>: > > <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 <sams...@gmail.com>: >> >>> 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...@googlegroups.com. >>> To post to this group, send email to django...@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/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 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/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 a topic in the Google Groups "Django users" group. To unsubscribe from this topic, visit https://groups.google.com/d/ topic/django-users/_EOK0u_We5k/unsubscribe. To unsubscribe from this group and all its topics, 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/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. -- 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/CAMV-ozmB9f-9TntHj%2BJJBUQZ9%3DJXHVhTHvagrhpk0zq3itJVJA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
