[closed] Ultralite database size increases after multiples ALTER DATABASE SCHEMA FROM FILE executions

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
1.1k●27●47●56
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

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

flat view

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

learn more about Markdown

Question tags:

ultralite ×162
schema ×25
database-size ×15
alter ×10

question asked: 31 Jan '12, 11:50

question was seen: 2,192 times

last updated: 26 Oct '12, 11:33

SAP SQL Anywhere

[closed] Ultralite database size increases after multiples ALTER DATABASE SCHEMA FROM FILE executions

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

Related questions