RE: The number of data pages is increasing extraordinarily

Gembus, John wrote:

> my database becomes bigger and bigger. 
> Size  55.758 pages
> 
> select * from tablestatistic   and
> select * from indexstatistc 
> 
> shows for user Database-User and normal-user 5216 used pages.
> 
> I don't know where to find 50.542 pages. My Applikation needs nearly
> constant  5100 pages.
> There is no other program which works with sapdb.
> 
> After installation and loading everything is ok. Then the 
> number of used
> pages becomes more and more. 
> 
> Any Ideas
> 
> I user sapdb 7.4.3.10 an windows 2000 / Windows XP

Pleas check with "select * from serverdbstatistics" 
what kind of space is used temporary or permanent.

If it's temporary space unclosed result sets could be the reason.
MAX DB doesn't close result sets implicit when you reached 
the end with your fetch commands.

Kind regards,
Holger
SAP Labs Berlin

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx