using database hosting: allow mysql queries to run a long time
Posted on 2013-11-18
using mysql workbench only to run query
I have long queries to run.
I am looking for a remote mysql server that has a long timeout time.
I can not use localhost on my desktop computer because we need remote access.
Currently I am using godaddy hosting which times out after 3 minutes.
If query times out, I have no data.
My client needs to see data.
I would prefer a host that allows this behavior instead of modifying data and shortening queries. I added sql server zone because I have run 10 minute queries in sql server but need to do long queries in mysql.
I am not looking to buy expensive dedicated server just to test this, I am looking for database hosting that is proven to work.
Maybe add more database zones so I can find database hosting.