Hi Keith,
interesting results. I never tried Pier with so many pages ;-)
6200 pages in 78Mb
Remove page 215 seconds.
18600 pages in 130 Mb
Remove page 500seconds!
I know why removing a page takes so much longer than adding a page:
When Pier removes a page, it has to go trough the whole system to
check if there are any references that should be nil-ed. Obviously
this might take a while to walk trough the whole model. In fact it
could be easily cached/optimized, if necessary. For such a huge model
you probably would like to have some indexes anyway, such as a full
text index.
Cheers,
Lukas
--
Lukas Renggli
http://www.lukas-renggli.ch