Jump to content

PIREPS So SLOW! After DB Restore.


Lockdown345

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...