So here is the problem. iPhones are amazing, but bandwidth and latency are serious problems with applications that have server requirements. My initial plan for resolving this issue was to make several requests for data bits (pun intended), and this will handle the problem with a lot of incoming / outgoing data. This is a bad idea for many reasons, the most obvious for me is that my poor database (MySQL) cannot handle this very well. From what I understand, it’s better to request large chunks right away, especially if I ask for it all the same.
Now the problem is that I'm waiting again for a lot of data. I was wondering if there is a way to send the server a lot of identifiers to get from the database, and then this SINGLE request sends a lot of small responses, each of which contains all the information about one db record. The order does not matter, and ideally I could send another request to the server telling him to stop sending me things, because I have what I need.
I understand that this is probably NOT a simple thing if you (wonderful) guys could point me in the right direction, which would also be unbelievable.
The current system is iPhone (Cocoa // Objective-C) -> PHP -> MySQL
Thanks for the ton in advance.