Re: [firebird-support] Re: Is Firebird favor Intel's CPU?

[trsk...@yahoo.com [firebird-support]]

Yes it was update only 1 record at the time.

But total records need to be updated is about 19.500.000.

So I made a small program that update 1.000.000 record and that's how the 
calculation came out.

If only updated 1000 records at the time, the desktop runs faster but when it 
reach 1.000.000 records , 2.7GHz speed of notebook is about same speed with 
3.0-3.5GHZ on desktop.

Re: [firebird-support] Re: Is Firebird favor Intel's CPU?

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Your last query update only one record then i cannot imagine how do you measure 
this.But i have answered your question based on information provided. CPU can 
be used in stricte calculations like  a*b or e.g sort operations. To see simple 
what do CPU in particullar database operation and if you can benefid from 
faster CPU, put your db on RAM disk and measure times in your specific DML like 
select, update on both machines. This is also limited because of dufference in 
motherboard, speed of RAM ...Regards,Karol Bieniaszewski
null

[firebird-support] Re: Is Firebird favor Intel's CPU?

[trsk...@yahoo.com [firebird-support]]

I don't think so.

When notebook speed limit to only 0.8GHz, process drop significantly.

Update query, something like  : update tbl, set ln=-999 where id = 1
Id is primary key in tbl.

I think CPU processing was used to search for index.