I am looking for opinions and ideas on what tool could be used to develop an app on the Palm that will allow filtering and viewing data from a pdb with as many as 100,000 records. Each record would be a maximum of 100 characters in size. We may want to filter on one of two different fields to narrow down the search for the user then allow them to specifically select one record to view.
Example: The app has 100,000 records of an inventory database. The user can select a view for all parts with a part number that begins with an "N". Or the user can select a view for all parts with a description that begins with "Bed". Once the filter is put in place they get a grid of the available matching parts. They tap on one of the items in the grid and view the detail of that record. Data is transferred in only one direction: from the PC to the Palm. No modifications, deletions, additions will be performed on the Palm. The data may be refreshed periodically (once or twice a day in extreme cases). We have experimented with Satellite Forms but it is very slow with just 5,000 records, so I can't imagine how slow it would be with 100,000 records. We would prefer this to be a self-contained app, meaning all data is on the Palm unit. We have the capability to use Symbol 1740 devices with wireless networking back to an Access Point (Spectrum 24) but would prefer not to add that setup complexity to the app. However, if someone has a great idea on how to create this app using this form of technology I would be more than willing to hear it. We have developed a couple apps with Code Warrior. We have considered tools such as Pocket Technologies, App Forge and Satellite Forms. Each has it's own strengths and weaknesses. Code Warrior being the bare metal programming way to go, but it is not very RAD. Thanks in advance for any suggestions, ideas or opinions. -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/tech/support/forums/
