Hello All....
I have kind of Listing application for iPhone application, which always calling a web service to my php server and fetching the data and displaying it onto iPhone screen.
Now, the thing to consider in this scenario is, my iPhone application everytime requesting on the server and fetching the data.
But now my requirement is like I want to replace following set of actions with above one :
- Everytime when my application is launched in iPhone, it should check
for the new data at the server`.
- And if server replies "true" then only my iPhone application will made a
request to fetch the data.
- In case of "false", my iPhone application will display the data
which is already cached in local phone
memory.
Now to implement this scenario at server side (which has php, mysql), I am planning with the following solution :
Table : tblNewerData
id newDataFlag
== ============
1 true
Trigger : tgrUpdateNewData
Above trigger will update the tblNewerData - newDataFlag field on Insert case of my main table.
And every time my iPhone app will request for tblNewerData-newDataFlag field, and if it found true then only it will create new request, and if it founds false then the cached version of data will be displayed.
So, I want to know that, is it the correct way to do so ? or else any other smart option available ?
Thanks in advance.
