Performance issues of hospital system using MySQL

To provide the better treatment in the hospitals, it is required to integrate all the hospitals of the country via internet. While visiting to hospital for treatment, a smart card with 10 digit unique patient-ID with his personal information is issued to the patient from the administrator of the hospital. As per unique patient-ID, all the doctor prescriptions, test reports, MRI, CT-scan images are stored in the database of the local server of the hospital and main centralized server of all the hospitals. Application of the smart card based on line hospital system has been developed as front end in .Net and back end in MySQL. In the development of application, all kinds of optimization have been covered at application level, database design level, memory utilization and optimization of queries for accessing the database. In this paper, some performance issues have been proposed for fast retrieval of patient data.