Remote database; overhead / performance?

[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

[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.

[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

[kraada]

What sorts of throughput speeds do you generally get between client and server?

[teppei]

I get download speeds of ~800 k/s, and ~30-40 ms when pinging

[kraada]

You shouldn't have any problems then.

[teppei]

Thank you. I will setup the server this week and let you know how it worked out.

Jason

[WhiteRider]

Thanks - do please let us know how it works.