Home » Forum Home » Development

Topic: database relocation
Replies: 19   Views: 2,216   Pages: 2   Last Post: Oct 15, 2020, 2:11 AM by: rainwolf

Search Forum

Back to Topic List
Replies: 19   Views: 2,216   Pages: 2   [ Previous | 1 2 ]
rainwolf

Posts: 691
Registered: Apr 12, 2008
From: Singapore
Age: 40
Home page
Re: database relocation
Posted: Sep 27, 2020, 9:22 AM

It should be a ton better now, give it a try.

\_(ツ)_/

rainwolf

Posts: 691
Registered: Apr 12, 2008
From: Singapore
Age: 40
Home page
Re: database relocation
Posted: Sep 30, 2020, 6:51 AM

I'm going to move the database server back one of these weekends, the old server was a lot closer to pente.org while the newer/stronger server is halfway across the world.
The search does not appear super slow anymore, but not fast either, I'm hoping moving the server back will alleviate that. I now believe the queries suffered mostly from network traffic, rather than the lack of computing power, and I've reduced the network traffic to a minimum now.

\_(ツ)_/
rainwolf

Posts: 691
Registered: Apr 12, 2008
From: Singapore
Age: 40
Home page
Re: database relocation
Posted: Oct 1, 2020, 2:18 AM

Done, it looks okay to me now, what about for you?

\_(ツ)_/
madmike

Posts: 109
Registered: May 27, 2014
From: Houston
Age: 64
Re: database relocation
Posted: Oct 13, 2020, 4:00 PM

I've taken a few days, and used different machines from different locations. Even different parts of the state.

I does seem better most of the time. there is still an occasional delay with results but they are rare and the delay is not very long.

Thanks for you efforts!!!!!

rainwolf

Posts: 691
Registered: Apr 12, 2008
From: Singapore
Age: 40
Home page
Re: database relocation
Posted: Oct 15, 2020, 2:11 AM

Thank you for the kind words, and all the testing. I decided to keep the database on the more remote machine because that one has an extra core which offsets the network delay most of the time.

There's one more speedup I want to try out once I find some time to implement it.

\_(ツ)_/
Replies: 19   Views: 2,216   Pages: 2   [ Previous | 1 2 ]
Back to Topic List


Powered by Jive Software