Hi,

At December 11, 2004, 09:27, Tanovic Branko wrote:

> Hello I running firebird 1.5.1 Classical Server on MDK 10.1

> Dual 800 FSB 3.0 GHZ Xeon HT
> 2GB Ram
> RAID 0+1 WITH 4 x 36GB 15K SCSI HDD.

> I would like to optimize my firebird.conf
> What should i change.
> On more thing I work with 120MB database curently.
> I run delete rows it need more than 4 hours to complete.

How many rows are deleted? Do you use triggers?

> with only 22 % usage for all cpus.

Are you using only one connection to the database? If the answer is
yes, then that would be your answer. When connecting to Classic,
Classic will spawn a new single-thread process for each connection.
So, a single connection will only run on one virtual CPU and not use
all four virtual CPUs. So what you are seeing is one Classic instance
using CPU time on one virtual CPU.

> My questions is what do i need to change in fibird.conf to speed up this.

None.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)