Daniel Rail wrote:

>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?
>
>

Yes i have a lots of trigers.

>
>
>>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.
>
>
>

Yes only one connection,

Very good explenation could some one make it a FAQ.

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

tnx