Mailing List Archive

database storage of server logs
In case anyone is interested in the continuing saga...

I had originally attempted to load 15,000 requests from my
somewhat altered common log format into Postgres95 and found
that loading this data (without doing name lookups) took
1 hour.

Considering that to be somewhat rediculous... I grabbed a
copy of David Hughes' mSQL-1.0.7 and gave the same thing a
try. Kudos to David... It only took 12 minutes.

rm -r postgres95
Re: database storage of server logs [ In reply to ]
On Sat, 29 Jul 1995, Randy Terbush wrote:

> Considering that to be somewhat rediculous... I grabbed a
> copy of David Hughes' mSQL-1.0.7 and gave the same thing a
> try. Kudos to David... It only took 12 minutes.

Thanks Randy. mSQL-2 should be ready for public consumption in a couple
of months (including much faster data handling code) and then we'll see some
fur fly :)


> rm -r postgres95

That's the conclusion I came to with the old Postgres too.


Bambi
...