Re: Turtle like speeds connecting to db across network

Thats rather surprising (10x), it depends a lot on:

- The DB schema
- The type & syntax of your DML (selects, inserts etc)
- The data access interface being used by client(s) (ADO, OLEDB, ODBC etc)

How you can optimise a schema is largely dependent on the RDBMS for it's
"optimisation rules"
Design the schema/parts of the schema with it's intended purpose in mind
(OLAP, OLTP)
Don't blindly follow the normalisation rules, doing so can have a
deletorious effect
Bear in mind that the use of SPs, in performance terms, can outstrip DML in
some circumstances
Match the solution to the requirement
Read the RDBMS documentation sections concerning performance thouroughly

Regards,
Phillip Allan-Harding

Graphicboost Ltd.
Tel: +44 (0)161 980 4136
Mobile: +44 (0)7778 561119
Email: [email protected] <mailto:[email protected]>
Web: http://www.graphicboost.com



-----Original Message-----
From: Robert Saye [mailto:[email protected]]
Sent: Thursday, 03 October 2002 22:23
Subject: Turtle like speeds connecting to db across network


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.

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