Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 7 of 7 total |
TDBISAMEngine.CreateTempTablesInDatabase: Any down side to TRUE ? |
Fri, Jan 15 2010 1:33 PM | Permanent Link |
Sam Jones | 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! |
Fri, Jan 15 2010 2:48 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sun, Jan 17 2010 12:50 AM | Permanent Link |
Sam Jones | 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! |
Sun, Jan 17 2010 8:31 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Mon, Jan 18 2010 4:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Jan 20 2010 12:37 AM | Permanent Link |
Sam Jones | >>>
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! |
Wed, Jan 20 2010 8:08 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |