Grham,

Can you help me make my app(s) run faster on apache with mod_wsgi (latest 
version)

Application Description:
The flask application takes an excel worksheet and writes the rows to and 
Oracle table. My stack includes flask, sqlalchemy, openpyxl, cx-oracle. For 
excel worksheet with 263,000 rows, it took about 2 minutes 50 seconds for 
the excel sheet to be uploaded and the data to be written to oracle when I 
assigned 4 processes and 4 threads in my wsgidaemonprocess as:

WSGIDaemonProcess fbbidataupload.cat.com \
        user=http group=http processes=4 threads=4 \
        
python-home=/WebHA/catworld/featureanalytics-443S/all_virtual_envs/data_upload_tool
 
\
        python-path=/WebHA/catworld/featureanalytics-443S/dataupload_app


I changed the processes to 8 and threads to 8 and tested but the results 
are the same. I was hoping that increasing the number of processes and 
threads would help with performance but that was not the case.

The server is redhat 6.7 with apache 2.2.15 , 32 gb of ram, 8 cpus; each 
cpu has 1 cpu core. Is there anything I can do to increase the performance 
of my application? If you need any more information about the application, 
server, virtualhost, please let me know. Thanks.

-- 
You received this message because you are subscribed to the Google Groups 
"modwsgi" 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/modwsgi.
For more options, visit https://groups.google.com/d/optout.

Reply via email to