Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Loading a large records from database to htm select control

 
Kazeem Akinrinde
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please what is the best and most professional way of loading records that is as large as 50,000 rows to populate an HTML select control.

Thanx in advance.

Kazeem
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65337
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Simple: don't.

That's way way way too much info for a select. Or any other mechanism.

When faced with a situation where a user must select from a large dataset, I present them with what I've called a "picker": a popup window (actually a floating div rather than a new window) that allows them to page and search through the data to locate their selection(s). That way they are not overwhelmed with a huge amount of data.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kazeem,
I completely agree with Bear. It isn't usable to have that much data available to the user at once.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic