Hello Holger, the used pages are only permanent data pages. After a restart only 13pages temorary are used.
You talked about that sapdb needs a close when i reached the end of a fetch command. Is it possible that the temporary space becomes parmanent ? I hope not. John > -----Urspr�ngliche Nachricht----- > Von: Becker, Holger [SMTP:[EMAIL PROTECTED] > Gesendet am: Donnerstag, 27. November 2003 18:47 > An: 'Gembus, John'; '[EMAIL PROTECTED]' > Betreff: 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
