Re: RE: My thoughts on this issue

Timothy J. Wood (bungi nospam at omnigroup.com)
Wed, 10 Mar 1999 21:07:12 -0800

>Does this include all of their mirrors? If not, that query number
probably
>skyrockets a bit.

Their page said that is included stats from all of their sites.

Note that they just updated their pages today and this information
is gone. Actually, a whole bunch of traffic related information is
gone now: the top 100 hits don't list how many hits they've received,
they don't list the top clients or anything really traffic related.

>Oracle8 on Linux is free (no source though), isn't it? MySQL and others
>(Post) could also be used (free the source!). Not sure what the
performance
>ratio between MySQL and Oracle/Sybase is.

I think you can now get Oracle, Sybase and Informix for free on
Linux now. I really don't know anything about MySQL so I couldn't
make a guarantee as to its performance vs a major database vendor. I
think the obvious guess is that MySQL is going to be slower, unless
the vendors didn't do a fully functional port to Linux.

But as I mentioned before, any database that can handle about 4
queries per second should be able to handle the peak load that cddb
was reporting on their web page before today. I would guess that
MySQL could handle that load for the fairly modest data set we are
talking about (a few 100k rows is really nothing).

The nicest thing to do would be to provide a front end API that
basically contains 'insert a new record', 'update an old record', and
'query for a record' and then allow for multiple backend
implementations of that interface. This would allow for storing in a
RDBMS, providing a local proxy, so on and so forth.

-tim