Hi, we are developing the hospital management system for very big hospital in tryton. daily,more than 900 patients would come to the hospital. every day we store the datas in the database. for single patient,doctor prescribes 10 drugs that created 10 records in the database. so that my question is after two years, if the database is fully loaded then search the record speed is slow or not. what is the scalability of the database??
I am eagerly waiting for the answer
