| Subject | File size enlarge each time procedure is called |
|---|---|
| Author | B |
| Post date | 2012-10-09T01:03:45Z |
Hi,
I have a database with around 7MB in file size.
Inside there is a few procedures and one is giving me a headache.
Inside of an procedure is a output variable type blob, where a few for-select-do loops are putting some data.
There is no insert, update or delete in that procedure, just a few for-select-do loops.
All data are filled in one output variable (type blob) witch usually return around 20KB of data inside of an blob.
What is the problem ?
When I call this procedure database enlarge itself for around 80MB per call, again, again and again..... I tried to call this procedure a few times and database became an 1,4GB, even more.
If I use s sweep , nothing happens.
When I backup it and restore it returns to original size of 7MB.
Any clue ?
P.S. I tried with Firebird 2.5.1.26351 64bit on WIndows 7 and latest daily build but results are the same.
I have a database with around 7MB in file size.
Inside there is a few procedures and one is giving me a headache.
Inside of an procedure is a output variable type blob, where a few for-select-do loops are putting some data.
There is no insert, update or delete in that procedure, just a few for-select-do loops.
All data are filled in one output variable (type blob) witch usually return around 20KB of data inside of an blob.
What is the problem ?
When I call this procedure database enlarge itself for around 80MB per call, again, again and again..... I tried to call this procedure a few times and database became an 1,4GB, even more.
If I use s sweep , nothing happens.
When I backup it and restore it returns to original size of 7MB.
Any clue ?
P.S. I tried with Firebird 2.5.1.26351 64bit on WIndows 7 and latest daily build but results are the same.