Lockdown345 Posted June 21, 2019 Report Share Posted June 21, 2019 Hi, When I accept/reject a pirep it takes literally ages to accept. I watch the database it changes straight away but the website is just so slow. This all started after we had to restore the database back a day after one of my staff accidentally deleted it while working on it (Don't ask). I've tried so many things to fix it Database defrag etc... The Server is really powerful 4 Xeon E5 v4 Cores and 8GB RAM. Running on Windows Server 2019 IIS and MySQL from XAMPP. Not sure where to go next, Have surfed this forum for hours and i cant see anyone thats had a similar issue. Quote Link to comment Share on other sites More sharing options...
Lockdown345 Posted June 27, 2019 Author Report Share Posted June 27, 2019 *Bump* This seems to surpass my knowledge. Sorry to bump this but i could really use the help. Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted June 28, 2019 Administrators Report Share Posted June 28, 2019 (edited) You are running this locally using XAMPP?? For a production site? Google "site updates slowly after database restore" for possible solutions. Edited June 28, 2019 by ProAvia Quote Link to comment Share on other sites More sharing options...
Lockdown345 Posted June 28, 2019 Author Report Share Posted June 28, 2019 Haha yes it was only intended for a few pilots but we have exploded in recent months I am looking for a better solution. I'll have a look at Google now and post back. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted June 28, 2019 Administrators Report Share Posted June 28, 2019 How big is the database? It could be that MySQL itself isn't properly tuned for the amount of data that you have. The default MySQL settings are ok for general workloads. 1 Quote Link to comment Share on other sites More sharing options...
Lockdown345 Posted July 5, 2019 Author Report Share Posted July 5, 2019 Thanks for the replies. Moved to a better hosted service. Seems you were right @Nabeel The new server has much better setup for MySQL it must seem because as soon as we migrated over the issue went away. Looks like whatever XAMPP's settings are its not enough for an airline with over 500 Members and around 20-30flights submitted daily. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.