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/[EMAIL PROTECTED]
