I am using MS-SQL 2005 DB. One of the tables in the DB, that I inherited, has gotten upto 37000 records. And it will go up by another 50k records soon. Does that make too much data for one table? The table has about 25 columns, most of which contain VARCHAR type data.
Also, since the DB acts as a back-end to the web interface, would about 90k-100k records make the pages load slower? Since the web pages also include a 'search' functionality, every search will have to go through so many records at a time. In other words, what is the performance hit I will take for having so much data together?
Am I being paranoid about the amount of data, or does something need to be done - and if I do, what are my options?