The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

Hello experts,

I've noticed that after an execution of an ALTER DATABASE SCHEMA FROM FILE command, the .udb size increases, even if no DML execution is done between the database's schema upgrades.

So I had known about this issue, I've executed a set of alter-database-schema commands many times, like this:

Version 0 -> upgrade schema -> Version 1 -> upgrade schema -> Version 2 -> upgrade schema -> Version 0

After the execution of 20 steps (no DML was done), the database size hasn't stabilized as I expected.

Why the database continues grows, even if no data was modified or inserted?

asked 31 Jan '12, 11:50

Alex's gravatar image

Alex
895143645
accept rate: 25%

closed 26 Oct '12, 11:33

Yes, the size should stabilize.

How large is the database initially? Does it contain data? How much is the increase on each iteration?

(31 Jan '12, 17:47) Tim McClements
1

The database's initial size is 6.029.312 bytes and we've made the following operations:
1. Increase the size of a varchar column and of a numeric column
2. Create a new column
3. Create a new column, and after, add a foreign key reference
4. Remove a column different from the inserted before

Each one of these operations consists in a schema upgrade and after the step 4, the database's schema is upgraded to the initial one.

The database size's behavior for an Android client was:

| 1ª Execution | 2ª Execution | 3ª Execution | 20ª Execução |
| 6.029.312    | 6.094.848    | 6.160.384    | 6.422.528    |
| 6.094.848    | 6.094.848    | 6.160.384    | 6.422.528    |
| 6.094.848    | 6.094.848    | 6.160.384    | 6.422.528    |
| 6.094.848    | 6.160.384    | 6.160.384    | 6.422.528    |
| 6.094.848    | 6.160.384    | 6.160.384    | 6.422.528    |

I'm looking into a simple repro for this issue, but I couldn't do it yet.

(01 Feb '12, 12:13) Alex

The question has been closed for the following reason "I couldn't reproduce this problem anymore." by Alex 26 Oct '12, 11:33

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×130
×22
×10
×10

question asked: 31 Jan '12, 11:50

question was seen: 759 times

last updated: 26 Oct '12, 11:33