×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

It's a difficult question. Maybe you missed something. What's kind of records? I think you should answer this question in these following aspects.

First, where you keep the records? what kind of object to hold the data? If the records are from a local database, things may be a little easier.
Second, make clear how this grid should be used, then you can decide, then design the interface between grid and data with optimum buffer strategy.
Third, if the records are not of database, you'd store them with well designed storing strategy, in order to find and get the records easily and quickly, just like you are designing your own simple database( index tree, physical storage,..). you know, 10 million is not a small number, an operation as simple as moving pointer may take you several minutes if it's poor designed.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / My interview question: Describe how to populate a screen grid when there are over 10 million records? I did't answer well and I think I lost this chance. Anyone know the exact answer? Thx
    • Provide "Next","Previous","Pageup","Pagedown","Last Recorder","First Recorder" buttons ( I am not sure for my answer) .
    • It's a difficult question. Maybe you missed something. What's kind of records? I think you should answer this question in these following aspects.
      First, where you keep the records? what kind of object to hold the data? If the records are from a local database, things may be a little easier.
      Second, make clear how this grid should be used, then you can decide, then design the interface between grid and data with optimum buffer strategy.
      Third, if the records are not of database, you'd store them with well designed storing strategy, in order to find and get the records easily and quickly, just like you are designing your own simple database( index tree, physical storage,..). you know, 10 million is not a small number, an operation as simple as moving pointer may take you several minutes if it's poor designed.