Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Data base file size growing

3 posts in General Discussion Last posting was on 2008-04-29 12:14:53.0Z
Denis LB Posted on 2008-04-28 09:07:31.0Z
Sender: 3315.481589b0.1804289383@sybase.com
From: Denis LB
Newsgroups: ianywhere.public.general
Subject: Data base file size growing
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <481593d3.33db.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Apr 2008 02:07:31 -0700
X-Trace: forums-1-dub 1209373651 10.22.241.41 (28 Apr 2008 02:07:31 -0700)
X-Original-Trace: 28 Apr 2008 02:07:31 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6834
Article PK: 5071

I have the following problem :

I create SQL Anywhere V10 bases, the data base file size is
less
than 100 MB. After a few weeks, the .db file is growing with
no reason up to 1 or 1.5 GB.
If I unload the data and create a new base, the size is
again less than 100 MB.

I never had this problem with earlier versions 7, 8 or 9.
Can somebody give me an explanation ?


David Fishburn Posted on 2008-04-28 13:19:56.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Data base file size growing
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <481593d3.33db.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns9A8E5EEECA600fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/2005.10.18
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 28 Apr 2008 06:19:56 -0700
X-Trace: forums-1-dub 1209388796 10.22.241.152 (28 Apr 2008 06:19:56 -0700)
X-Original-Trace: 28 Apr 2008 06:19:56 -0700, vip152.sybase.com
Lines: 39
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6835
Article PK: 5073

Denis LB wrote in news:481593d3.33db.1681692777@sybase.com
of ianywhere.public.general:

DL> I create SQL Anywhere V10 bases, the data base file size is
DL> less
DL> than 100 MB. After a few weeks, the .db file is growing with
DL> no reason up to 1 or 1.5 GB.
DL> If I unload the data and create a new base, the size is
DL> again less than 100 MB.
DL>
DL> I never had this problem with earlier versions 7, 8 or 9.
DL> Can somebody give me an explanation ?

Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng10 -v).

If you are using the 10.0.0 GA release, I know things were corrected.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList


Denis LB Posted on 2008-04-29 12:14:53.0Z
Sender: 5a17.48170f2c.1804289383@sybase.com
From: Denis LB
Newsgroups: ianywhere.public.general
Subject: Re: Data base file size growing
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4817113d.5a51.1681692777@sybase.com>
References: <Xns9A8E5EEECA600fishburnsybasecom@10.22.241.106>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Apr 2008 05:14:53 -0700
X-Trace: forums-1-dub 1209471293 10.22.241.41 (29 Apr 2008 05:14:53 -0700)
X-Original-Trace: 29 Apr 2008 05:14:53 -0700, 10.22.241.41
Lines: 49
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6838
Article PK: 5074

Thanks David,

I presently use build version 10.0.0.2465. I will try a more
recent one to check.

Denis.

> Denis LB wrote in news:481593d3.33db.1681692777@sybase.com
> of ianywhere.public.general:
>
> DL> I create SQL Anywhere V10 bases, the data base file
> size is DL> less
> DL> than 100 MB. After a few weeks, the .db file is
> growing with DL> no reason up to 1 or 1.5 GB.
> DL> If I unload the data and create a new base, the size
> is DL> again less than 100 MB.
> DL>
> DL> I never had this problem with earlier versions 7, 8 or
> 9. DL> Can somebody give me an explanation ?
>
> Please ALWAYS include version and MORE importantly BUILD
> number with EACH post (dbeng10 -v).
>
> If you are using the 10.0.0 GA release, I know things were
> corrected.
>
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD
> number with EACH post (dbeng10 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> Case-Express - to report bugs
> http://case-express.sybase.com
>
> CodeXchange - Free samples
>
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList
>