On Fri, 2005-02-11 at 11:39, Wolfram A. Kraushaar wrote: > > > insert msg set id=xxx, body="first 512 bytes of msg goes here..."; > > > update msg set body=body+"another 512 bytes..." where id=xxx; > > > update msg set body=body+"yet another 512bytes" where id=xxx; > > > > Lets see.. our current max attachment size is (on our mailservers) > > 50MB, with 512bytes blocks this would lead to 102400 database queries. > > That would surely kill the database performance even under light load. > > Actually the max messageblksize is 512*KB*, not bytes - so a 50 Meg message > leads to 100 queries.
I think even 512KB is too small for big systems. It might be a sane default, but it should be possible to change it in the config file. -HK
