Hi guys,

I'm developing a database (a student tracking system actually) of which one table (with exam results of students) has to hold over 100,000 records in the future (this table consists of 7 fields of which 3 are lookup-fields). Is this physically possible and if so, how do you guys think it will affect the performance of the database?

tblResults

resultID (PK)
studentID (FK)...