Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Mon, Apr 14 2008 12:28 PM	Permanent Link
"Jose Eduardo Helminsky"	Tim If I would create a temporary table, it will be created always on disk ? Eduardo
Mon, Apr 14 2008 1:59 PM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Jose >If I would create a temporary table, it will be created always on disk ? As things currently are - yes. I asked Tim the same question some time back and I'm hoping he'll alter it so they can go into memory but I'm doubtful. You can always just create them in a memory database yourself. The only problem is that it makes it a bit more awkward when joining etc, and the component HAS to be linked to the memory database rather than the disk one and all references to the disk ones need fully qualifying. The reason I've opted for in-memory rather than temporary is I can guarantee (even with M$'s stuff) that memory tables are cleaned up by a reboot Roy Lambert [Team Elevate]
Mon, Apr 14 2008 3:49 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Eduardo, << If I would create a temporary table, it will be created always on disk ? >> As Roy indicated, yes. I'm looking into adding an in-memory option at some point also. -- Tim Young Elevate Software www.elevatesoft.com