Subject Re: [ib-support] Firebird makes /tmp/core file, and it is HUGE
Author Helen Borrie
At 07:00 PM 02-08-02 -0700, you wrote:
>So if my /tmp file is always empty does that mean that any files created
>are always being cleaned up?

Yes: and you are not looking at it when users are doing sorts. <g>

>I should not assume that it is not using them at all should I? you have users getting ordered result sets then they got
them via sort files.

>In that case is there a rule of thumb to use on /tmp file size based on
>the size of the queries. Some sort of ratio.

Not really. You have to use your own rules of thumb, derived from
soak-testing your own query scenarios. I've seen suggestions varying from
"twice the size of your largest table times the peak number of users" to "a
dedicated large, fast drive in a fast RAID". I don't think there is any
reliable alternative to good QA for establishing your runtime and growth

>I do not remember seeing anything about it in the docs, but that does
>not mean it's not there. As I have proven in the past to miss the
>obvious in the docs. :)

It's there - either totally internalise where to find stuff in the Borland
OpGuide and Firebird release notes; or get hold of the Using Firebird
manual, which has a whole chapter dedicated to configuration.

>I do not mean to, but my little brain can only take in so much at one
>time. :)

<hobby horse on>
Oh, you're not alone in this. I think it's a stretch for folk to believe
they can get all their answers from a single source of
documentation....especially if they are determined not to part with any
money to acquire or promote resource materials developed to assist them in
the learning curve.

Don't take this personally, since I know you are one who has taken steps to
get these resources. Producing documentation is horrendously
expensive. Everyone wants the book but too few are willing to contribute
to its development or maintenance.
<hobby horse off>


All for Open and Open for All
Firebird Open SQL Database · ·