On 27 Apr 06:20, dineshkumar wrote: > 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 assume you will use PostgreSQL as backend. About search of record, it depends of the search but postgresql has indexes (by default B-tree for Tryton) so if your search can use this index the search will be in O(log n) when the space to store the index will be O(n). Other kind of indexes can be used on PostgreSQL like GiST see http://www.postgresql.org/docs/current/static/indexes-types.html If you are doing full text search, you should read http://www.postgresql.org/docs/current/static/textsearch.html But before going to full text search, you should see if a trigram index is not enough because it could help a lot for LIKE clauses http://www.postgresql.org/docs/current/static/pgtrgm.html So as you can see we have a lot of tools to solve issues about searching. -- Cédric Krier - B2CK SPRL Email/Jabber: [email protected] Tel: +32 472 54 46 59 Website: http://www.b2ck.com/
pgpsu1KJDNnCI.pgp
Description: PGP signature
