Jump to content
Lockdown345

PIREPS So SLOW! After DB Restore.

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.

Share this post


Link to post
Share on other sites

You are running this locally using XAMPP?? For a production site?

Google "site updates slowly after database restore" for possible solutions.

Edited by ProAvia

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

  • Like 1

Share this post


Link to post
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.

Share this post


Link to post
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...