> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
[snip]
> I have them as complete e-mails in Eudora (.mbx format).
If you can get them to me (how big, compressed?), I can load up the entire
archive in MySQL very quickly.
> > FYI, my old database had 10 million records, of which Brin-L was just a
> > little bit. The new one now has 6 million. No real performance issues
> > yet, though some things have been difficult to optimize. Efficiently
> > threading, calculating each person's interval between posts and that
> > sort of thing have been the more challenging ones.
>
> For clarity: was that a MS Access database or something else?
That was in MySQL, version 3.x. I'm now using version 4.1, which is
technically an alpha release, but it's very stable.
> > I'm using MySQL -- there's really no need for Oracle. You can even use
> > Access as a front end to MySQL. I've done that, and the same with
> > Excel. They're handy for trying out queries and examining the results
> > list carefully.
>
> I have zero experience with MySQL. How difficult is it to learn?
If you're not administering it, there's no difference from Access, since
they both are SQL databases. SQL is very easy to learn, but it can become
quite challenging. And figuring how to do queries efficiently can be
interesting, too. As I said, you can even use Access or Excel (or any
ODBC-friendly application) as a front end.
Installing MySQL can be a bit difficult, especially with regard to setting
permissions. And that depends on the platform, too. Tweaking it requires
great peace of mind... ;-)
I'm going to see what I can do with the machine that I've set aside for
you... NOW. Before moving takes all my time.
Nick
