Re: Turtle like speeds connecting to db across network

It depends on the type of database.

My findings:

If the DB is a true server, like MS SQL Server and Oracle 8/9, it shouldn't impact performance. In
fact it may improve performance slight if the DB server is a powerful computer (multiple CPUs,
fast disks, etc) and you have a 100MBit network with lots of free bandwidth, compared to having
the DB on a laptop dev machine with a single processor.

If the DB is of a disk based, like MS Access, your in for a real performance degradation when
moving the DB to a network drive. There's nothing to be surprised by. Try loading your VStudio dev
project from a network drive and you'll experience the same thing, especially during disk intense
processing like compiling.

If your DB is not disk based and you experience a 1:10 performance degradation, there is a)
something fishy with you network, b) your DB server is under real preasure serving either lots of
users or lots of complex queries or c) your DB server is just plain old and slow.

Hope this helps!

/Christer

--- Robert Saye <[email protected]> wrote:
> Hi all,
>
>    Just kind of a general question. I had my database on my development
> computer, recently I moved it to a network drive. This slowed my
> application down by at least a factor of ten. Is this normal? Are there any
> optimization techniques out there which aren't general knowledge? Best
> practice kind of things when connecting across a network.
>
> Thank you,
> Robert
>
> You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
> or subscribe to other DevelopMentor lists at http://discuss.develop.com.


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.