The database has around 2 million records. as a text file it's more than half the disk space of the android.
On 29 Μαρ, 01:12, Diego Pino <[EMAIL PROTECTED]> wrote: > I think you should rather store your data on a local sqlite database, > and access to it via a ContentProvider. > > You can use the method onKeyDown(int keyCode, KeyEvent event) to catch > a key press event. You could then, query your data to retrieve a brief > set of cities (set a LIMIT on your query) and populate the Spinner > using and ArrayAdapter. Just an idea... > > On Mar 28, 11:05 pm, dr123 <[EMAIL PROTECTED]> wrote: > > > Hi, > > i'm again the guy with the 8mb question. actually it's not 8mb it's a > > little larger but here is my problem to which i can't get any > > solution. > > > I need to have the user choose his country and then populate > > "something" with all the cities of the country. > > In order to be exact, i have a database with 18000 cities for greece > > only for example. > > Going through that kind of text or html file is not feasible as it > > would have to take extreme space and memory. > > > I tried two solutions: > > first one is having the database on my server and collecting the data > > through xmlrpc. this fails cause the data is bigger than the > > kxmlrpclitent can hold (or some other limitation but in the debugger > > it only gets a couple of hundred cities or so). > > > the second one is better (i think): > > i open up a php page on my server with webkit that has all the cities > > and i can easily see them with a normal browser. > > > *BUT*: the android browser (at least the one that opens with a new > > intent and a uri) > > translates the html combobox into something like a spinner. this is > > extremely slowly generated (i wait for minutes before it opens up and > > have to press the button 2-3 times) and second and most important: > > i can't find a way to press the "r" key for example and the box > > transfers me to the first city which starts with "r". > > Noone can scroll down a list with 18000 cities. > > > I know i should get something with less cities but first of all that's > > the only database that has all the cities (i wouldn't want only the 10 > > bigger cities cause in the united states for example that would also > > be some thousands). > > > My app which is going for the challenge (i'm in a hurryyyyyyyy) is a > > social app *depends* on good geographical selection (not gps , i > > know). > > > any help *very* appreciated --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] Announcing the new M5 SDK! http://android-developers.blogspot.com/2008/02/android-sdk-m5-rc14-now-available.html For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---