PostgreSQL backend: a waste of time?

[Ken Murchison]

> Alessandro Oliveira wrote:
> 
> I think that all the code that is dependent on a particular database
> should be completely isolated, making it simpler to port to new

All of the db stuff _is_ isolated in the cyrusdb layer.  That's why it
is so easy to switch between flat/skiplist/berkeley.



> databases, for instance: Nicola likes postgres, you like mysql, and I
> love oracle (besides it is very expensive), somebody else would like
> an interbase or a sapdb backend.
> 
> Noll Janos wrote:
> 
> > Hy!
> >
> >  I think that's a very good idea, but we found that MySQL is much
> > faster
> > than Postgres, when there are no complex queries (this is the case
> > here),
> > so it might be a better idea to use MySQL.
> >
> >
> > On 25-Nov-2002 Nicola Ranaldo wrote:
> >
> >
> >> Due to our historical problems using BerkeleyDB4 over True64Unix
> >> I'm
> >> coding a PostgreSQL backend.
> >> It's in alpha stage and seems to work fine over an our production
> >> server
> >> with about 7500 mailboxes.
> >> Cyrus.log is DBERROR free, and users do not report any problem.
> >> Access to mboxlist is about 5 time faster then with BerkeleyDB4.
> >> If the cyrus community is interested in this little piece of code
> >> (i
> >> don't
> >> know due to presence of skiplist backend) we can start a thread
> >> now!
> >>
> >>
> >
> > | Noll Janos <johnzero at johnzero.hu> | http://www.johnzero.hu |
> > | "Expect the unexpected!"    |   ICQ# 4547866   |  Be free! |
> >
> >
> >
> 
> --
> Best Regards,
> 
> Alessandro Oliveira
> Nuno Ferreira Cargas Internacionais Ltda.
> Phone: +55-11-3241-2000
> Fax  : +55-11-3242-9891
> -------------------------------------------------------------------
> 
> It's trivial to make fun of Microsoft products, but it takes a real
> man to make them work, and a god to make them do anything useful.

-- 
Kenneth Murchison     Oceana Matrix Ltd.
Software Engineer     21 Princeton Place
716-662-8973 x26      Orchard Park, NY 14127
--PGP Public Key--    http://www.oceana.com/~ken/ksm.pgp