Am Sonntag, 27. April 2014 15:20:37 UTC+2 schrieb dineshkumar: > > 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?? >
As most of the databases used are Postgres-DB, I think you should ask this question better in the Postgres group. Tryton itself supports distinct DB-servers, it should be possible to use a DB-cluster. You may as well ask in the GNU Health Group for experience, as they are implementing GNU Health for a whole country (Jamaica) HTH Axel
