Tim

Will it be possible to store the metadata for temporary tables in the catalog? The sort where they are created in memory as and when needed rather than stored on disk, and where there may be several tables created with that structure eg where there are multiple threads.


Roy Lambert

Roy,

<< Will it be possible to store the metadata for temporary tables in the
catalog? The sort where they are created in memory as and when needed rather
than stored on disk, and where there may be several tables created with that
structure eg where there are multiple threads. >>

Sure, all table information is stored in the catalog for the database,
including the "Memory" database, which has its own catalog just like any
other database.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

No ability to have separate (multiple) in-memory databases
in V5 then?

Sean

Tim Young [Elevate Software] wrote:
> Roy,
>
> << Will it be possible to store the metadata for temporary tables in the
> catalog? The sort where they are created in memory as and when needed rather
> than stored on disk, and where there may be several tables created with that
> structure eg where there are multiple threads. >>
>
> Sure, all table information is stored in the catalog for the database,
> including the "Memory" database, which has its own catalog just like any
> other database.
>

Sean,

<< No ability to have separate (multiple) in-memory databases in V5 then? >>

Not initially.  However, the capability is internally in there, so it's
something we can enable when we have the initial release tamed.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks. Look forward to it.

Sean

Tim Young [Elevate Software] wrote:

> Sean,
>
> << No ability to have separate (multiple) in-memory databases in V5 then? >>
>
> Not initially.  However, the capability is internally in there, so it's
> something we can enable when we have the initial release tamed.
>