Ricardo Kustner wrote: > > Hi, > > One of the mmbase installations we host has a custom builder which > functions as some sort of forum... while looking through the database I > was kinda shocked when I saw that the table used by this builder has > more than 10,000 objects... every object is a reaction to a posted > article. Could it be that this has a negative effect on the performance > of mmbase? I've noticed this mmbase installation is extremely slow for > an X amount of time after startup... > Since all these records are related to something, the install_insrel > table is quite huge too... >
If you don't have indexes on these tables things can be very slow. > A related question I have on this: if an object has an expire time set, > will it be deleted from the database if it expires or will it simply not > be displayed (in other words: do objects stick around for ever in the > database?) Expire time isn't an MMBase-thing, at least the basis install doesn't have this, so it must have something to do with your application. Maybe the webpages don't show objects after their expire time? Gerard
