This question is just for contentment, because it's my first application that deals with databases,
I'm beginner in databases, I build a company accountant system that contains (or will contain) a huge mount of records after years,
I developed a c# win forms application as user interface and sql server 2014 database,
I for example when user search for all cash transactions for specific year it will be a huge mount of records that will loaded in Datagridview,
Or when search for specific invoice the system will search for it( using SELECT statement) will search in huge mount of records,
Data handling performance is good when testing on a few data
I just want to make sure that the program will stay in the same performance after years of inserting data
What I have tried:
I want to avoid any future problem while using the program
If anyone can help me with informations about searching in huge data and give me numbers for example