There may be something wrong there... I don't experience any delays when using ssh. I mostly use Ubuntu though, but still doesn't make sense that it would take that long, there may be some sort of database problem.
Although I'm not a noob when it comes to programming, I have zero experience of web services so I'm seeking advice!
For one of our departments at work I have developed a simple CRUD application using Apache, MySQL and PHP on a local network server. This works fine
Due to expansion of the department, the database is to be migrated to the main DB server to which I will not be able to make direct calls from my PHP code due to security. They are happy however to create a webservice that I can use that will in turn access the database. I have total say in how the data will be returned to me for interpretation by my PHP pages and how I send data to the web service.
Which is the recommended way (I hear alot of 'talk' about JSON nowadays) and do you know of any good tutorials that you would recommend?
(I'm posting here as I'm not sure where is best, and from my side of things PHP will be doing all the communication with the service)