0
I am developing a iPhone App coupled with a .Net Web Service as the Backend. Need few clarifications on the same.
The configuaration of my project.
SQL SERVER2008 to store the data, .Net Framework 3.5 to provide Web Service interface, Iphone 3.1.
The Project Description: The SQL Server will store my data in the form of XMLs. Each XML will contain a information about a particular entity. These entities will be displayed in the iPhone as topics in chronological order from A-Z. What is the best possible method to fetch those XMLs from SQL SERVER using a Web Service to the iPhone?
I have a solution like i will fetch all the XMLs available in DB and compress it into a ZIP file using GZIP and store the ZIP in a file system. Then on a request from iPhone to the Web Service, the Web Servie will embed the file system path as URLs in the response XML. The iPhone will recive the XML with the URL to fetch the ZIP embedded in it. Then iPhone will make a call to the URL and fetch the file and uncompress it into SQL Lite DB. What are the drawbacks that is found in this solution? What is the best way to transefr my XML files from Web Service backend to my iPhone as there may be more than 1000 files to be transferred and more than 1000 users will be accessing the system parallely?