Wednesday, March 28, 2012

Network

We are developing with SQL 7 Developer Edition and planning to install
MSDE with the VB application. We received the following question from
the IT dept. of our client:
"Does your version of SQLServer database work well across a frame
relay wide area network?"
Should there be any problems regarding speed, etc.?

Thanks!

Ernie Adsett"Ernie Adsett" <ernie@.amt.nb.ca> wrote in message
news:JhAPb.69757$IF6.1700023@.ursa-nb00s0.nbnet.nb.ca...
> We are developing with SQL 7 Developer Edition and planning to install
> MSDE with the VB application. We received the following question from
> the IT dept. of our client:
> "Does your version of SQLServer database work well across a frame
> relay wide area network?"
> Should there be any problems regarding speed, etc.?
> Thanks!
> Ernie Adsett

If your application is written to avoid unnecessary network traffic (use
stored procedures, avoid returning unnecessary rows in result sets etc.),
then there shouldn't be any special considerations. But to get a definite
answer, you would need to test it, of course.

Simon|||"Ernie Adsett" <ernie@.amt.nb.ca> wrote in message
news:JhAPb.69757$IF6.1700023@.ursa-nb00s0.nbnet.nb.ca...
> We are developing with SQL 7 Developer Edition and planning to install
> MSDE with the VB application. We received the following question from
> the IT dept. of our client:
> "Does your version of SQLServer database work well across a frame
> relay wide area network?"
> Should there be any problems regarding speed, etc.?

Depends entirely on your design and how good it is.

> Thanks!
> Ernie Adsett

No comments:

Post a Comment