Re: Would old version of mysql caused performance issue in Django

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 <fbruandrade@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 <samsun387@gmail.com>:

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.

--
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/msgid/django-users/ac4201dd-5267-4566-8d0a-82b2b2f043c4%40googlegroups.com.

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+unsubscribe@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/9efab471-ae94-4ff2-a62c-67650638c4e0%40googlegroups.com.

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+unsubscribe@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.

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 django-users+unsubscribe@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/CAM-7rO2meRJ31z%3D0%3D9h%3DseM1%3DtP5PLY_gP7NiwHT2XQC9fScag%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.