iphone - how to implement picker for a large amount of values -


i have 20,000 records (coming sqlite db) need present user possible choices, conventional picker control out of question.

another possibility indexed uitableview user check desired value, keeping 20k records in memory doesn’t seem idea.

how should go implementing ui it? edit: possible auto-complete combo-box?

i'd @ sort of nested ui i.e. uitableview has a, b, c etc start , when user presses on row show table view results starting a.

there need query got number of results started a, b, c etc showed letters in first table has results each query in second table simple - results starting 'a' etc.

you'd never have load 20,000 results memory @ same time :)

however, should make sure have index on field you're querying, otherwise queries going rather slow :(


the other solution use search box @ top of table view - user types in letters , each time list reduced results starting letter. that's pretty simple query implement :)

however, still have problem of if user hasnt typed in - show message asking them type or show 20,000 results in enormous list?


Comments

Popular posts from this blog

ASP.NET/SQL find the element ID and update database -

jquery - appear modal windows bottom -

c++ - Compiling static TagLib 1.6.3 libraries for Windows -