Remember that the users will not work with 100 000 data at the same time, so when you want to give the user to work with data, you must always filter the data and give only what is needed at that time.
I once worked on the a timetabling System, the Mistake they made when they design the system , is that they brought unneccessary data, at first there was no problem with perfomance because few people accesed , but when it was requested that the whole University(More than 300 000 Students) should access the data, it was a problem, because students could see other students timetable, that is "Information Oveloading" , the Solution to this problem , brought us back to the basics. You must only show people what they need , not extra.
So to finnaly asnwer your question. You must always filter your data.
Thank you for posting at Dotnetfunda
Gaddad, if this helps please login to Mark As Answer. | Alert Moderator