Subject Re: [firebird-support] Re: Performance tuning large FDB
Author Jan Bakuwel
Hoi Ali,

Wouw, you respond quickly! :-)

> FB has not any sort file size paramater if i know correctly, and
> not required.
>
> These config paramaters and sort in RAM, written and added by
> D.Yemanov a few years ago.

I don't understand. These are not FB parameters? They are in the FB
config file... (and seem to have an effect on the amount of memory FB
allocates)?

> I have no idea about your HW but,
> alot of main boards has two independent SATA controller chips.
> so, if you made an 4 DISC RAID system this mean, they are controlled
> by a software at OS level.

Nope. They are controlled by a dedicated controller with onboard
processing and memory capacity. The OS only sees one disc.

> Ok, i understand. i have such problems too, but i am not luckily as
> you because my Firebirds runs on fossil computers.

:-) yep... I know I'm a lucky bastard and can you believe it: I still
want more... :-)

> Linux caches may helps more here.

Thats good to know. Its just that I don't know what is more efficient,
the Linux caches or FB's caches...

> DB splitting increases complexity i think. buying an extra 8GB will
> be more cheap for you. ( so, OS can cached your DBfile fully)

Yes, it increases complexity quite a bit so to know whether its worth
the trouble, it would be good to know who's better at managing a RAM
cache: Linux or FB. I would say theoretically FB has the better cards
because it knows more precisely what is going on. The OS can only look
at disc blocks being accessed. The programmer can help FB if its own
caching mechanisms aren't able to utilise the full 8- GB.

My luck has run out with 8GB. Server memory banks are full and available
budget has been all used. Should get me a long way though...

cheers!
Jan


--

A journalist once asked the late Gandhi what he thought of the western
civilization. Gandhi replied: "Western Civilization? That would be a
good idea!".

----

Ships Unit
Information, Communication, Technology
Greenpeace International
Ottho Heldringstraat 5
1066 AZ AMSTERDAM
Netherlands (MET)

direct +31 (0)20 7182084
fax +31 (0)20 5148151
reception +31 (0)20 5148150
email jan.bakuwel&int.greenpeace.org
private jan.bakuwel&hccnet.nl
(replace & by @ in the emailaddress)