database managment problem

Question

i am developing database driven application .net platform,
performance issues does not arrives when der is not much load of data.
in live projects, der can be thousand of records in database.
frequentlyin my application there are some tables which will required lot of DML operations, but a perfomance issue arrives when there are of thousand of records

guys pls help me out, how can i overcome this problem

i mean, i should maintain several backups, or copy database to another location
or any such other method

lf possible pls provide brief details any of the method

thanks in advance

Mahesh Chand · Answer

If you have millions of records you are not going to display millions of records in the application at one time. The way you handle this is bring a few records (say 100 500 or 1000) record at once. When user is done with these records then you bring next batch of records from the server to the application. You can implement this by using paging mechanism. In most of the cases you want your business logic filtering applied in the database server and once records are filtered based on your business rules you only bring the wanted records in the application.