help with Benchmark

Hi guys!! does any one know a page at microsoft.com or another site that has
the time sql 2005 takes to insert a row ??
i saw at microsfot.com some benchmarks but based on transactions and
comparing Sql with Oracle and IBM, that's not what i'm looking for, i'm
looking for times in mili seconds or micro seconds Sql takes to do it

Thanks!!

No, that information isn't available from Microsoft (and it would be a
license violation for anyone else to publish it without Microsoft's
permission).  One major reason is that you have to say under what
conditions.  Is it in a user-defined transaction or not?  How many indexes
of what type?  Do you need to split a b-tree node?  Are there concurrent
users?  Are there any conflicts?  blah blah blah.  In other words, it's not
a useful number in this day and age.  Now if there were a standardized
benchmark that gave this information it might be interesting, in the context
of that benchmark.  Old benchmarks like Wisconsin used to do some of this
(though it was more query than insert/update focused).  But most such
benchmarks are no longer published.

You might find some data in comparisons the MySQL folks publish as they (a)
try to make themselves look good by focusing on single-statement comparisons
rather than complex application comparisons and (b) they don't seem to mind
violating Microsoft (and others') license agreements.  At least that was the
situation when I looked a couple of years ago.

--
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com


"Rick" <elmargaro@hotmail.com> wrote in message
news:OMlF5gCVGHA.5808@TK2MSFTNGP12.phx.gbl...
> Hi guys!! does any one know a page at microsoft.com or another site that
> has the time sql 2005 takes to insert a row ??
> i saw at microsfot.com some benchmarks but based on transactions and
> comparing Sql with Oracle and IBM, that's not what i'm looking for, i'm
> looking for times in mili seconds or micro seconds Sql takes to do it
>
> Thanks!!
>
>
>

oki doki, thanks Hal, i'll look for some comparisons.

Regards.

"Hal Berenson" < hberenson@scalabilit
yexperts.com> escribió en el mensaje
news:eSysFQJVGHA.4864@TK2MSFTNGP12.phx.gbl...
> No, that information isn't available from Microsoft (and it would be a
> license violation for anyone else to publish it without Microsoft's
> permission).  One major reason is that you have to say under what
> conditions.  Is it in a user-defined transaction or not?  How many indexes
> of what type?  Do you need to split a b-tree node?  Are there concurrent
> users?  Are there any conflicts?  blah blah blah.  In other words, it's
> not a useful number in this day and age.  Now if there were a standardized
> benchmark that gave this information it might be interesting, in the
> context of that benchmark.  Old benchmarks like Wisconsin used to do some
> of this (though it was more query than insert/update focused).  But most
> such benchmarks are no longer published.
>
> You might find some data in comparisons the MySQL folks publish as they
> (a) try to make themselves look good by focusing on single-statement
> comparisons rather than complex application comparisons and (b) they don't
> seem to mind violating Microsoft (and others') license agreements.  At
> least that was the situation when I looked a couple of years ago.
>
> --
> Hal Berenson, President
> PredictableIT, LLC
> http://www.predictableit.com
>
>
> "Rick" <elmargaro@hotmail.com> wrote in message
> news:OMlF5gCVGHA.5808@TK2MSFTNGP12.phx.gbl... 
>
>