I think you can use second level caching , I have seen similar cases where DB becomes slow while fetching reports of several thousand cases.
You can use elastic search as a middle level layer to index all data and search them. Thanks On Wed, Feb 7, 2018 at 10:03 AM Hari Haran <[email protected]> wrote: > Team, > > I have large database and my application is very slow due to this. I could > not see the balance sheet and some of the reports. > > I have disbursed 1 lakh + loans and enabled accounting for the same. > > How to configure the database to make my application faster.I have > hosted 17.07.01 version. > > *PFB Server Details.* > EC2 large instance and I have installed MySQL in the system. > *Processor :* Intel zepn CPU [email protected] > *RAM : *8 GB > *Storage : *50 GB > > -- > > > ------------------------------ > Regards, > Hariharan.G > Technical Consultant | Habile Technologies > www.habiletechnologies.com | (O): +91 44 4202 0550 > <+91%2044%204202%200550> | (M): + 91 90030 25156 <+91%2090030%2025156> > Skype: hari.mitteam | https://www.facebook.com/HabileTechnologies > <https://www.facebook.com/HabileTechnologies> > > ------------------------------ > DISCLAIMER: > All emails and any files transmitted with them are confidential and > intended solely for the use of the individual or entity to whom they are > addressed. If you have received an email in error please notify your system > manager. The message in the email you have received contains confidential > information and is intended only for the individual named. If you are not > the named addressee you should not disseminate, distribute or copy the > email. Please notify the sender immediately by email if you have received > an email by mistake and delete the email from your system. If you are not > the intended recipient you are notified that disclosing, copying, > distributing or taking any action in reliance on the contents of the > information is strictly prohibited. >
