Re: Question about speed: Weird Behavior

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Question about speed: Weird Behavior
Дата
Msg-id 4DF5B7B3.7010708@postnewspapers.com.au
обсуждение исходный текст
Ответ на Question about speed: Weird Behavior  (Israel Ben Guilherme Fonseca <israel.bgf@gmail.com>)
Ответы Re: Question about speed: Weird Behavior  (Israel Ben Guilherme Fonseca <israel.bgf@gmail.com>)
Список pgsql-jdbc
On 13/06/11 11:14, Israel Ben Guilherme Fonseca wrote:

> At every stop, I print the milliseconds occurred between the begin and
> the end of the operation. The results were basically
>
> 1st  operation: 0.05 miliseconds
> 2nd operation: 0.1 miliseconds

I suspect you're right on the border of the precision the timers you are
using can offer you. It's hard to be sure as you didn't mention you
platform, CPU, or JDK version.

Try using System.nanoTime() for your timing, and/or (much better) do
many iterations rather than just one to try to smooth out error and jitter.

http://download.oracle.com/javase/1,5.0/docs/api/java/lang/System.html#nanoTime()

> Anyway, that speed increases is definitely a good thing, but why this
> happens it's a mystery for me. The problem is that my benchmark tests
> are influenced with this, cause the order of the tests can influence the
> outcome of the total time.

You really need to tweak your benchmarks to reflect more of a real-world
workload. Timing tiny statements stand-alone will not give you data with
any relationship to what will happen under real load with many such
operations happening concurrently or thousands of them being executed in
rapid sequence.

--
Craig Ringer

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Radosław Smogura
Дата:
Сообщение: Re: Question about speed: Weird Behavior
Следующее
От: Israel Ben Guilherme Fonseca
Дата:
Сообщение: Re: Question about speed: Weird Behavior