As discussed in http://www.elevatesoft.com/newsgrp?action=openmsg&group=5&msg=63497&page=1 :

Setting TDBISAMEngine.CreateTempTablesInDatabase := TRUE  is very important in a number of
situations.

Why isn't this TRUE by default?

Is there downside or risk if this property is TRUE ?


Thank you!

Rafael,

<< Setting TDBISAMEngine.CreateTempTablesInDatabase := TRUE  is very
important in a number of situations.

Why isn't this TRUE by default? >>

Because it causes temporary tables to be created in the same directory as
the database, which can be a performance issue if the database is on a drive
on another machine.  By default, these temporary tables are created on the
local drive in the Windows temporary files directory.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thank you!

Is there a "middle way" ?

IOW, is there a way for ALTER TABLE to make its temp tables in the DB dir, but for other
temp tables (for queries, etc.) to be local?

The only problem I am trying to solve for is for ALTER TABLE issues, as described in
http://www.elevatesoft.com/bulletin_9.htm

Your thoughts?

Thanks!

Sam

>Is there a "middle way" ?

Set TDBISAMEngine.CreateTempTablesInDatabase to True before you issue the alter table command and and back to False afterwards.

Roy Lambert [Team Elevate]

Rafael,

<< Is there a "middle way" ?

IOW, is there a way for ALTER TABLE to make its temp tables in the DB dir,
but for other temp tables (for queries, etc.) to be local? >>

Actually, sorry for not mentioning this, but yes, it currently works that
way.  The CreateTempTableInDatabase property only affects the ALTER TABLE
SQL/AlterTable method functionality.

--
Tim Young
Elevate Software
www.elevatesoft.com

>>>
Actually, sorry for not mentioning this, but yes, it currently works that
way.  The CreateTempTableInDatabase property only affects the ALTER TABLE
SQL/AlterTable method functionality.
<<<

Hip hip hooray!

So this is the perfect solution!

And it begs the question... why the property isn't true by default... but I am feeling sesations of happiness!

Thank you!

Rafael,

<< And it begs the question... why the property isn't true by default... but
I am feeling sesations of happiness! >>

Because we didn't want to break existing applications or cause slowdowns for
them if they weren't being affected by this AV software mess.

--
Tim Young
Elevate Software
www.elevatesoft.com