I have not experience performance issues on pythonanywere but I have not used MySQL. One possibility is that on your local machine the database and the server run on the same machine. On pythonanywhere (and most hosting) they may run on different machines therefore you have network latency. Moreover I do not know if the mysql instance if dedicated or shared between many users.
If this is a latency/bandwith issues you may want to consider rewriting your select so that you retrieve only the columns you actually need. On Saturday, 21 March 2015 15:21:40 UTC-5, NeoToren wrote: > > My website is using MySQL and consists mostly of queries and simple > display of textual results. No images or fancy CSS. > > Locally, queries response time is *sub second*. > Deployed to PythonAnywhere (using the couple of basic efficiency tricks in > the book) - and the same queries may take *7-8 seconds each !* > PA support mentioned that inefficiencies in my code, which are not evident > locally may become an issue on the network. > Ok...what kind of inefficiencies should I look for ? > > Any ideas how I can improve the performance when hosted at PythonAnywhere > ? > Anybody experienced similar issues ? > > Thanks > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
