I will look into the Web service approach. I am creating the XML and could generate 50 seperate SQLite files but I understand accessing those across a network is "iffy" even though the "hopefully" large number of users would only be reading them.
Thanks Gene Augustine On Jul 23, 3:12 pm, Mark Murphy <mmur...@commonsware.com> wrote: > I'd build a smarter server, one that returns just the data you need, > via a GET request. Even if, for whatever reason, you cannot make your > current server smarter, you can create a separate Web service (e.g., > Google App Engine, Slicehost) that gets the data from the existing > server, puts it in a database, and serves up what you need to the > client. > > Or, if the data does not change frequently, have your smarter server > generate a SQLite database that you download periodically and use > locally on the device. > > Expecting a phone to be able to do bulk data parsing and processing > quickly is unrealistic, even in today's Snapdragon-y world. > > On Fri, Jul 23, 2010 at 3:05 PM, Capt Spaghetti <gene_august...@msn.com> > wrote: > > I have 50 XML files located on a remote server, one formatted for > > each state. I am able to read each of the 50 files by selecting a > > state from a spinner and using a SAX parser but I cannot seem to find > > out how to pull out information from each file by city. I have tried > > unsuccessfully to pass a city variable to the characters method of the > > Handler. > > Each state has thousands of records and I am looking for a way to > > speed up the search since reading the entire file for a state takes > > several minutes. I used SAX since it was supposed to be the fastest > > way to read but it limits me in selecting specific information. If I > > understand things correctly I could use a DOM parser to find my state > > and city specific data but that would make retrieval even slower. Any > > suggestions would be appreciated. > > -- > Mark Murphy (a Commons > Guy)http://commonsware.com|http://github.com/commonsguyhttp://commonsware.com/blog|http://twitter.com/commonsguy > > Android Development Wiki:http://wiki.andmob.org -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
