keep in mind that a desktop browser has a *lot* more memory and a lot more CPU than the one running on a cellphone
2008/3/28 dr123 <[EMAIL PROTECTED]>: > > > trie seems nice but the challenge is in two weeks :) > > i don't try to populate the spinner with 18000 entries, i have them on > my web page...but i find it strange that the browser from android has > such a hard time reading the select box which a normal browser can > read. xmmm > > On 29 Μαρ, 01:59, Digit <[EMAIL PROTECTED]> wrote: > > You should use XMLrpc to only retrieve a small number of cities, based > on > > the characters that the user has already typed, like what "Google > suggests" > > implements. > > trying to read 18000 entries from the server is not going to work or > even be > > fast. trying to populate a spinner with 18000 entries is insane, not > only is > > it bad UI but a waste of resources. > > > > if you absolutely want to store the data on the device, you should > consider > > a packed binary format that's amenable to lookups and serial access. I > guess > > that a trie would be very appropriate here (seehttp:// > en.wikipedia.org/wiki/Trie) > > > > 2008/3/28 dr123 <[EMAIL PROTECTED]>: > > > > > > > > > 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 [email protected] 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 -~----------~----~----~----~------~----~------~--~---
