That even sounds good enough. Generally, my domains contain between 2 and
30 pop accounts each. A few exceptions, but in general, CDB would have
faster lookups, would be independent of MySQL, and easily moveable it seems.
I think I will make that change... It sounds promising. I am currently
running the MySQL module, and I want to move to CDB to speed it up. Also it
would avoid the waiting for connections.
Sounds like a good plan to me- is the upgrade easy? Just run vconvert and
recompile vpopmail? (then qmailadmin/sqwebmail)
--
Mike
----- Original Message -----
From: "Bill Shupp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Mike Rogers" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 1:33 PM
Subject: Re: MySQL -vs- CDB [Conversion]
> 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
>
>
