Hi, Gerard van Enk wrote: >>>> 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. >> Ah I see, I'll check if everything is properly indexed.
I checked and it looks like all tables are indexed... Even after running a postgresql 'vacuum' on all the tables, it is still quite slow at times... up to the point where it doesn't respond anymore and mmbase needs te be restarted. I'd probably be better off to upgrade this site to 1.5.1, but that's going to be a quite lot of work for sure... >> so in a few years time you'll get a huge amount of objects... it's >> nice to keep an archive of all old objects but the question is how >> long can it keep growing before you run into trouble? :) > I don't think you'll run into trouble very soon (the vpro and eo both > are having an MMBase-Cloud with a couple of million objects in it). ah that's quite a relief... :) thanks for your insights... Ricardo.
