We are facing a strange issue. 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. 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 msMethod 2 : 1 500 ms
(5 times slower !!)
On Intel Core2 Duo :Method 1 : 172 msMethod 2 : 188 ms (almost the same
execution time)
Could some one explain me the difference? Is there anyway to solve the
problem? Of course we are not suppose to use as many different
transaction but as I said it's an old program that we don't want to
re-write it.
Xeon spécifications:Intel Xeon X3450 - 2.67 Ghz (8 cores) - 4 Gb Ram
(only 3 Gb used because of Windows 32bits)HDD Raid 1Windows 7 (32 bits)
professionnel editionFirebird 2.1 (SuperServer) --> We also test the
Classic version but not better
Intel Core2Duo spécifications:Intel Core2Duo E4600 - 2.40 Ghz - 1.96
Gb Ram HDD (IDE controler)Windows XP (32 bits) professionnel edition
(SP3)Firebird 2.1 (SuperServer)



[Non-text portions of this message have been removed]