Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

It seems our developers are concerned with the latency they are getting between their dev machines at site a and the database which is at site b.

Ofcourse the obvious thing is to have as little as possible hops between site a and b and make sure we have stable and speedy internet connection.

What else should be looked at to improve the latency? And what minimum spec network should they have between the developer machines and the oracle db servers. Is the spec of the server/machines important, if so what would be your recommendations?

share|improve this question
    
That's a rather broad question. Please show what sort of latency are you getting? Is it pure network latency, i.e. ping latency, or application latency, i.e. plsql latency or jdbc latency? –  Dmitri Chubarov May 1 '12 at 9:27
add comment

2 Answers

up vote 1 down vote accepted

And what minimum spec network should they have between the developer machines and the Oracle db servers. I

The same as production. Actually they should not work on a production db at all but have a db for development only. On a separate machine. Preferably in their office.

Is the spec of the server/machines important,

Depends on what you do on the database, but no, it will not influence latency at all.

If so what would be your recommendations?

Something that is good enough. On my last project our development environment consisted of an ExaData cluster for about 250.000 euro - because we needed it. What you need depends on what you do, so the spec question is VERY open. THAT said: most of the time they should have a virtualization cluster and just allocate what they need for database servers for testing and development.

share|improve this answer
    
Thanks this is in line with what I was thinking! –  Anicho May 1 '12 at 10:19
add comment

If it's network latency then, depending on your budget, you could opt for a leased line, but that's really expensive. The capacity would depend on how much data needs to be transferred between site a and b. So you will need to measure this.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.