What is the best solution for large database table?

i am developing a web application these days ,this application will use to insert about 100,000 record per day,so the db will be very large by time , Is there a solution to be wary of slow down the db querying or performance