Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Reusing deleted record space
Wed, Feb 7 2007 4:00 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

I remember from a previous thread that ElevateDB wasn't going to reuse deleted record space. Looking at the SQL manual I see OPTIMIZE made it through so does this mean that space is reused?

Roy Lambert
Wed, Feb 7 2007 4:56 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< I remember from a previous thread that ElevateDB wasn't going to reuse
deleted record space. Looking at the SQL manual I see OPTIMIZE made it
through so does this mean that space is reused? >>

It re-uses the space.  It doesn't re-use row and BLOB space only in the case
of replication being in effect.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Feb 8 2007 4:15 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


>It re-uses the space. It doesn't re-use row and BLOB space only in the case
>of replication being in effect.

Thank you oh mighty one. I find myself thinking this is one manual I'm going to have to read when it finally hits the bookshelves.

Roy Lambert
Thu, Feb 8 2007 1:18 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Thank you oh mighty one. I find myself thinking this is one manual I'm
going to have to read when it finally hits the bookshelves. >>

That is always a good idea. Wink

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, Feb 10 2007 2:43 AMPermanent Link

Muhammad Mamouri
>> It re-uses the space.  It doesn't re-use row and BLOB space only in the case
>> of replication being in effect.
Does ElevateDB support Replication?

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Roy,

<< I remember from a previous thread that ElevateDB wasn't going to reuse
deleted record space. Looking at the SQL manual I see OPTIMIZE made it
through so does this mean that space is reused? >>

It re-uses the space.  It doesn't re-use row and BLOB space only in the case
of replication being in effect.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sun, Feb 11 2007 10:08 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Muhammad,

<< Does ElevateDB support Replication? >>

It will eventually, but it doesn't in the initial release.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image