Database Management

[mikejaytlabustro]

What is the best practice for data management once
your data base stored too much records eg. Loan records
being used for 5 years already? Should I transfer manually
those who have remaining balances into new database? Or
there's other easy way to handle this? Thanks!

 

[Galaxiom]

This question comes up regularly. It depends what you mean by too many records. Some new devlopers worry unnecessarily over a few tens of thousands of records which is next to nothing really for a database.

One alternative is to add a boolean field for Inactive and modify the queries on that table to leave out the Inactive records.

Include an index on the field and it will be nearly as fast on selects as the records not being in the table at all.