I am working on an application in C# .Net, my backend is SQL Server 2005.
I am developing a sale point form, in my table
tblInvoiceDetail may be added 10000 rows per day .
This is a heavy volume of data, please guide me when 6 months data will be added in a table.
Then is it effects on the speed of data retrieving ? If yes then what should we do?
Please help me about this.