Re: multiple performance

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 19 Apr 2007 15:36:44 +0200
Message-ID: <58p9itF2i3qe1U4@mid.individual.net>

On 19.04.2007 15:14, Alexander Smirnov wrote:
> Theoretical question.
>
> For example
>
> 1) 10 sessions, each in its own thread, each connected to the same
> database and executes 10 updates on the same table, each update
> affects 1 row.

The same row or different rows?

> 2) 1 session in one thread executes 100 updates on the same table,
> each update affects 1 row.
>
> What is faster?

Practical answer: my Seat Leon.

Seriously: I don't know what others will tell you but I can imagine situations where either is faster.

Regards

robert Received on Thu Apr 19 2007 - 08:36:44 CDT