Satisfactory Query Time

Started by x asasaxaxabout 18 years ago2 messagesgeneral
Jump to latest
#1x asasaxax
xanaruto@gmail.com

Hi,

I have a query that takes 0.450 ms. Its a xml query. Is that a good time
for a query? If a have multiple connections on the database, will this time
makes my db slow? How much time is good for a xml query?

Thanks

#2Merlin Moncure
mmoncure@gmail.com
In reply to: x asasaxax (#1)
Re: Satisfactory Query Time

On Jan 13, 2008 4:55 PM, x asasaxax <xanaruto@gmail.com> wrote:

Hi,

I have a query that takes 0.450 ms. Its a xml query. Is that a good time
for a query? If a have multiple connections on the database, will this time
makes my db slow? How much time is good for a xml query?

You have provided zero relevant information. In fact, your question
is probably one of the vaguest I've ever read! Anways,

0.450 ms is extremely fast (a disk seek on a good drive will cost 2-5
ms). That computes to over 2000 txn/sec (over 7 million txn/hour). I
wouldn't worry to much.

merlin