On Fri, 2002-08-02 at 17:26, Scott Taylor wrote:

> On 2 Aug 2002, William L. Thomson Jr. wrote:
>
> Quite possibly, but 7.4 or 8.2 will be the next "stable" release, see the
> pattern? This is begining to get off topic.

Are you going by the odd numbers not being stable rule of thumb?
Since off topic I will not continue on this topic, beyond that question.

> > I have never had anything in my /tmp dir on my Firebird server. I do
> > some sorts, but not many?
>
> Try adding a few indexes, and build reports with them, or maybe you need
> to build reports that don't use indexes but use order by, not sure which
> does it.

Now indexes I have a ton of and do queries based on them, mostly using
containing queries using the indexes.

So it must be a sort thing? I may have to make a few more and see. As
when I do my partitions on my DB server I do not allocate much to /tmp
as I never see it being used?

I believe I have like 100+MB for /tmp, give or take 10-20MB's.

So far that has been enough but if I do use sort, and /tmp files are
needing to be written. Is there a negative outcome of the server trying
to write/use a file in /tmp and not being able to?

I just would like to know before I find myself in that situation.

Thanks

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