chirstophe_daoud schrieb am 21.02.2011 um 14:49 (-0000):

> We installed one of our old application on an Intel Xeon server with
> Firebird 2.1 and Windows 7 professionnal and it get much slower than
> previoulsy.

Same FB, FB configuration, OS, data?

> After auditing our old application I discover that the big number of
> consecutives transactions was the cause of this slowdown. So I done
> the following test : executing 30 times the same select within a
> single transaction (Method 1) and then executing those 30 times select
> with a new transaction for each select execution (Method 2).
> The result is :On Xeon server : Method 1 : 297 ms Method 2 : 1 500 ms
> (5 times slower !!)
> On Intel Core2 Duo :Method 1 : 172 msMethod 2 : 188 ms (almost the same
> execution time)

I doubt this is related to the hardware the application is running on.

> Could some one explain me the difference?

I'd look at other aspects:

* exact FB version
* FB configuration
* data
* OS

--
Michael Ludwig