Hi there,
So I'm aware that my use case is definitely pushing it for this type of hosting as I have a very large database and PA storage is networked, so db hits are a lot more expensive. I've done some work in the past to optimise my pages to this end.
However, I didn't expect the difference to be this pronounced. If I load a table of 2.7m entries in my Django admin panel (which also has three filters, so at some point must evaluate what those filter values could be) on my local machine it takes 5 seconds, while on remote it instead loads for 2 minutes and 12 seconds.
My question is: is this magnitude of slowdown to be expected for any remote hosting solution? And should my PythonAnywhere app be this slow by comparison? Is there anything I can do to improve this for such a large database?
Thanks for the help!
Kirkmania