> > 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. from dbmail.h: /* size of the messageblk's */ #define READ_BLOCK_SIZE (512ul*1024ul) /* be carefull, MYSQL has a limit */
