You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Define output variable in stored procedure type blob (subtype text , size 80) and put a string data in it with few for-select-do loops with no insert, delete or update.
After executing procedure database file grows up from few MB to 80MB and each time is called, it become larger for around 80MB - it goes up to a few GB.
If you make sweep , no change on file size.
If you make a backup and restore , size is back again on few MB (like it was at beginning).
Just change variable type from blob to varchar (size 30000) and everything is working just fine - no file size changing - procedure even run 10 times faster.
The text was updated successfully, but these errors were encountered:
Submitted by: Pera Detlic (bambam)
Is related to CORE4109
Is related to CORE3953
Is related to CORE3952
Is duplicated by CORE4109
Votes: 1
Define output variable in stored procedure type blob (subtype text , size 80) and put a string data in it with few for-select-do loops with no insert, delete or update.
After executing procedure database file grows up from few MB to 80MB and each time is called, it become larger for around 80MB - it goes up to a few GB.
If you make sweep , no change on file size.
If you make a backup and restore , size is back again on few MB (like it was at beginning).
Just change variable type from blob to varchar (size 30000) and everything is working just fine - no file size changing - procedure even run 10 times faster.
The text was updated successfully, but these errors were encountered: