On Fri, 2002-08-02 at 19:27, Helen Borrie wrote:

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

Well I will have to start doing that then. :)

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

Good to know.

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

Great, looks like I will need to allocate additional time for that as
well. :)

>
> >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 plan to purchase the CD or better yet a subscription. I assume the
subscription last for a year. So I will need to add them to out yearly
budget.

I just have some other software and hardware that needs to be purchased
first. Then I will make the purchase. As it looks like I will need to
make the purchases as a Corporate buyer.

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

The curve can be great at times, but the more docs, the better. At least
they can be used as references as all the pieces in the puzzle start to
come together.

> Don't take this personally, since I know you are one who has taken steps to
> get these resources.

Or at least doing my best to acquire what I can.

> Producing documentation is horrendously
> expensive. Everyone wants the book but too few are willing to contribute
> to its development or maintenance.
> <hobby horse off>

No way would I take it personal. I can imagine the time it takes to make
things like a DB engine and etc. Much less going back through and making
thorough documentation on your work. Also in the process breaking down
some what complex issues so us little brains out there can understand
what the genius have built, and what we can do with it.

All for free, just so others can benefit and profit off your work.

So I will do my best to contribute my part, or my cash. So that the work
is not being done in vain, but more importantly so work can continue to
take place.

As I am I am sure many other appreciate it and will be using it.

Plus with the docs and etc, I will have a better advantage over others
who do not have them. Which hopefully will help me make the right
choices.

--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989
http://www.obsidian-studios.com