[TriPython] Places to look at performance tuning

[George Gergues]

For SQL table  add at least one index. it will improve table scans.

On Jun 6, 2017 11:44, "Ken MacKenzie" <ken at mack-z.com> wrote:

>    So I am in the demo and test phase of an early ReSTful API for
> reporting.
>    Currently a wider scale report set request hits the following marks:
>    TTFB: ~20s
>    Record Count: ~92k
>    Download Size: 15.8MB
>    Details:
>    Web Server: NGINX
>    Python App Server: Gunicorn
>    Web Framework: Falcon
>    Python version: 3.5 (in a venv)
>    DB: MS SQL Server Express using SQL Alchemy + pyodbc
>    Webserver OS: CentOS 7
>    Gunicorn is setup with 4 workers, on a private port, nginx does a proxy
>    pass to the port
>    DB Details, the table in question has a total of about 8 million rows.**
>    Sample query execution within SQL Server Mgmt Studio is ~7s
>    So my question is which of the following would be a better target to
>    improve performance, or do I need to as my performance should be
>    considered good enough.** I mean the server in this case is a surplus
> dual
>    core desktop right now.
>    add gzip compression to nginx for proxys
>    switch gunicorn to use a unix socket instead of a tcp port
>    consider leaner SQL and JSON marshaling requests instead of ORM's and
>    dictionary bundles.
>    Appreciate and advice or suggestions.** Thank you.
>
> _______________________________________________
> TriZPUG mailing list
> TriZPUG at python.org
> https://mail.python.org/mailman/listinfo/trizpug
> http://tripython.org is the Triangle Python Users Group
>
>
-------------- next part --------------
   For SQL table **add at least one index. it will improve table scans.
   On Jun 6, 2017 11:44, "Ken MacKenzie" <[1]ken at mack-z.com> wrote:

     ** **So I am in the demo and test phase of an early ReSTful API for
     reporting.
     ** **Currently a wider scale report set request hits the following
     marks:
     ** **TTFB: ~20s
     ** **Record Count: ~92k
     ** **Download Size: 15.8MB
     ** **Details:
     ** **Web Server: NGINX
     ** **Python App Server: Gunicorn
     ** **Web Framework: Falcon
     ** **Python version: 3.5 (in a venv)
     ** **DB: MS SQL Server Express using SQL Alchemy + pyodbc
     ** **Webserver OS: CentOS 7
     ** **Gunicorn is setup with 4 workers, on a private port, nginx does a
     proxy
     ** **pass to the port
     ** **DB Details, the table in question has a total of about 8 million
     rows.**
     ** **Sample query execution within SQL Server Mgmt Studio is ~7s
     ** **So my question is which of the following would be a better target
     to
     ** **improve performance, or do I need to as my performance should be
     ** **considered good enough.** I mean the server in this case is a
     surplus dual
     ** **core desktop right now.
     ** **add gzip compression to nginx for proxys
     ** **switch gunicorn to use a unix socket instead of a tcp port
     ** **consider leaner SQL and JSON marshaling requests instead of ORM's
     and
     ** **dictionary bundles.
     ** **Appreciate and advice or suggestions.** Thank you.

     _______________________________________________
     TriZPUG mailing list
     [2]TriZPUG at python.org
     [3]https://mail.python.org/mailman/listinfo/trizpug
     [4]http://tripython.org is the Triangle Python Users Group

References

   Visible links
   1. mailto:ken at mack-z.com
   2. mailto:TriZPUG at python.org
   3. https://mail.python.org/mailman/listinfo/trizpug
   4. http://tripython.org/