Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Temporary tables x Memory tables
Mon, Apr 28 2008 2:09 PMPermanent Link

"Jose Eduardo Helminsky"
Tim

I would like to know your opinion about the speed difference between
Temporary tables and memory tables.

I know Temporary tables is a disk table created with ReadOnly and Exclusive
flags and Memory tables are created in RAM, but if I change *ALL* my SQLs
from DBISAM to ElevateDB and start using Temporary tables, am I missing some
performance ?

Eduardo

Mon, Apr 28 2008 2:41 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Eduardo,

<< I know Temporary tables is a disk table created with ReadOnly and
Exclusive flags and Memory tables are created in RAM, but if I change *ALL*
my SQLs from DBISAM to ElevateDB and start using Temporary tables, am I
missing some performance ? >>

You most likely will never even notice the difference.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image