Shrinking Ensemble/Cache Database
Alex Wildes
I am a SQL Server DBA and I know that there is a command to shrink a
database in SQL. However, with my research within this newsgroup as
well as other Web forums, I have not found a command to shrink a
datababase within Ensemble/Cache. Does anyone know if such a command
was created within Ensemble 2007 or are we left with the CREATE NEW
DATABASE/Export Old database data into NEW database routine? Thanks
Always
Alex
Benjamin Spead
http://docs.intersystems.com/cache20071/csp/docbook/DocBook.UI.Page.cls?KEY=ACHUI_Mgmt
WARNING: Caché optimizes the amount of data in the DB blocks. If you compact a DB and then insert a lot of data, you will see lowered performance due to an increase of block splits.
HTH,
Ben
Alex Wildes
and exporting globals from old database and import them into the new.
On Jan 7, 12:21 pm, "Benjamin Spead" <Benjamin.Sp...@intersystems.com>
wrote:
>
Chip Humphreys
a need to pull all the code/routines out and then load them in to another
DB. You could use ^GBLOCKCOPY. Although they spoeak of it as converting
legacy DBs it works wonderfully for copying the data.code from a current DB
in to a smaller one.
All you do is set up a new DB and then use ^GBLOCKCOPY to convert. The
fastest way is to prep the new DB to the size you expect you will need.
Assuming your current DB is 100GB and you anticipate that the actual space
you need is 30GB. Then you would create your DB as say 28 GB and leave the
max size as unlimited. Run ^GBLOCKCOPY and when it is done you can set a
max size if you so please. Of course you could just create the new DB to be
1MB, which is the default and let the process grow it as needed but I have
found that that does slow down the process a bit.
Hope this helps.
--
Chip