Page 1 of 1

Remote database; overhead / performance?

PostPosted: Mon Jan 04, 2010 4:08 pm
by teppei
Hello,

I'm thinking of using my dedicated server to host my postgresql database for PT3. I'm wondering if the performance loss due to the overhead caused by network latency is noticable at all?

I lost my previous database due to a hard drive crash, so my current one is really small (~5k hands). But it'll grow again eventually; how would a remote database affect performance when I get to ~300k hands?

Thanks

Re: Remote database; overhead / performance?

PostPosted: Mon Jan 04, 2010 4:21 pm
by kraada
Having the database on a remote server, assuming it's on a local network, will actually work quite a bit better than having it on your current machine. And a 300k hand database is quite small for these sorts of things; you shouldn't have any trouble there at all.

Re: Remote database; overhead / performance?

PostPosted: Mon Jan 04, 2010 4:32 pm
by teppei
The remote db wouldn't be on the local network; it would be on my dedicated server located in NYC (I'm in Québec City).

I should have mentionned that, sorry

Re: Remote database; overhead / performance?

PostPosted: Mon Jan 04, 2010 4:55 pm
by kraada
What sorts of throughput speeds do you generally get between client and server?

Re: Remote database; overhead / performance?

PostPosted: Mon Jan 04, 2010 5:17 pm
by teppei
I get download speeds of ~800 k/s, and ~30-40 ms when pinging

Re: Remote database; overhead / performance?

PostPosted: Mon Jan 04, 2010 5:23 pm
by kraada
You shouldn't have any problems then.

Re: Remote database; overhead / performance?

PostPosted: Tue Jan 05, 2010 12:55 am
by teppei
Thank you. I will setup the server this week and let you know how it worked out.

Jason

Re: Remote database; overhead / performance?

PostPosted: Tue Jan 05, 2010 5:46 am
by WhiteRider
Thanks - do please let us know how it works.