Hi all,
I’m going to use a bit of an analogy to describe what I’m looking to do; in most respects it’s the same and definitely easier to follow.
You know how in itunes, the search window at the top right refines the results below based on keywords in artist, album, or songname in realtime? I’m needing to do something like this.
There will be between 0 and approx 30,000 records in the db (or xml file, depending on how I do this). Just like with itunes, the db will rarely change (writing this, I’m realizing it’s uncannily similar). However, when it does change, I’d need to refresh the table, hopefully without reloading the entire data set..maybe just those that changed. The client side can sense when a reload is necessary.
I’d like the user to be able to scroll through ALL results, be it 10 if a distinctive search term is entered or all 30,000 is nothing is entered. I’m reluctant to paginate so that the scrollbar motion accurately reflects the number of results and so it doesn’t hang when it autoloads data when scrolling, for example.
It should be as fast as possible.
So now I’m not sure what to do. Querying a db with a search term and callback()ing the results might be noticeably slow, but having js deal with up to 30,000 rows might not be the best thing either.
What do you suggest?
For now, I unfortunately have to avoid all things like jquery, but if you have only examples with those that’s alright.