on 1/10/01 2:06 PM, Mike Rogers at [EMAIL PROTECTED] spake:
> I am currently running a MySQL vpopmail, as I have been for about a year and
> a half now. Lately, I have experienced above normal load on my MySQL
> server, and have considered using CDB instead, as that way my mail system
> does not fall to it's knees when someone does a large sort on my MySQL
> server.
> Will I notice any real disadvantage in converting to CDB from MySQL? Is
> it worth it? High-reliability is important, so I don't want to have to
> worry about flaws in the MySQL daemon. I realize I would have to recompile
> vpopmail/sqwebmail/qmailadmin, but it may be worth it. Also, is there a
> conversion utility that will convert from MySQL (small tables) to CDB?
Aside from some of the new features available with the MySQL module, the
real difference between cdb and MySQL is the speed of updates. If you have
more than about 7-10k accounts, cdb updates get really slow. And it gets
worse with more accounts. This isn't a problem with MySQL. On the other
hand, cdb lookups are slightly faster. So, if you don't have too many
accounts on each domain, you may want to stick with cdb format.
vconvert can convert either direction: cdb->mysql or mysql->cdb
Cheers,
Bill Shupp
