vultesmactems
New Member
We are currently working on a mobile web app for a client. It's essentially a straightforward app to allow customers to search their product database. The database contains over 5,000 items, and consists of two fields that can be searched - Part Number and Part Nomenclature.The thinking behind the team is that we should store all of the product data in an XML file, and store it in the manifest for the app. This would then allow searching via jQuery or similar technologies. The problem comes becuase the XML file itself is 606 Kb in length, and trying to search it using jQuery sometimes crashes the application.We're using the following method to search the file:\[code\]var $myXML = $(myXMLString);var $matches = $myXML.find("number:contains('part_number')");\[/code\]For reasons beyond our control, the app MUST run in offline mode, and the searching should be performed even when the phone has no active data connection. There was a suggestion to use WebSQL, but I'm concerned for the longevity of this solution, as it's been dropped by the W3C in the most recent specs of HTML5. I guess my question is, what's the best approach for storing such a large amount of data and searching it using an offline mobile web application. We can essentially use HTML5, jQuery or vanilla JavaScript.