dbTalk Databases Forums  

How to save space in firebird ?

comp.databases comp.databases


Discuss How to save space in firebird ? in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
db
 
Posts: n/a

Default How to save space in firebird ? - 05-23-2008 , 08:17 AM







I delete some row from database, In sqlite, I can use 'vacuum' to save
space, In firebird, how to do this ?

--

Reply With Quote
  #2  
Old   
Ed Prochak
 
Posts: n/a

Default Re: How to save space in firebird ? - 05-28-2008 , 06:41 AM






On May 23, 9:17 am, db <d... (AT) gmail (DOT) com> wrote:
Quote:
I delete some row from database, In sqlite, I can use 'vacuum' to save
space, In firebird, how to do this ?

--
What do you mean by "save space"?
The DBMS will put that row on the free list, available for the next
insert. Read the manual , either the concepts manual (if they have
one) or the DBA manual. The design, concepts, and usage of SQLite and
FIREBIRD are very different.

HTH,
Ed


Reply With Quote
  #3  
Old   
Ed Prochak
 
Posts: n/a

Default Re: How to save space in firebird ? - 05-28-2008 , 06:41 AM



On May 23, 9:17 am, db <d... (AT) gmail (DOT) com> wrote:
Quote:
I delete some row from database, In sqlite, I can use 'vacuum' to save
space, In firebird, how to do this ?

--
What do you mean by "save space"?
The DBMS will put that row on the free list, available for the next
insert. Read the manual , either the concepts manual (if they have
one) or the DBA manual. The design, concepts, and usage of SQLite and
FIREBIRD are very different.

HTH,
Ed


Reply With Quote
  #4  
Old   
Ed Prochak
 
Posts: n/a

Default Re: How to save space in firebird ? - 05-28-2008 , 06:41 AM



On May 23, 9:17 am, db <d... (AT) gmail (DOT) com> wrote:
Quote:
I delete some row from database, In sqlite, I can use 'vacuum' to save
space, In firebird, how to do this ?

--
What do you mean by "save space"?
The DBMS will put that row on the free list, available for the next
insert. Read the manual , either the concepts manual (if they have
one) or the DBA manual. The design, concepts, and usage of SQLite and
FIREBIRD are very different.

HTH,
Ed


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.