One million records a day

[gooogle]

Hi,

We need to log the fields from a IIS log into some database where it
can be sorted by date and id of a record. There will be about a million
records per day or more than that may be. What would be the best
solution for this apart from MSSQL ?
Anybody done this before ?

Thanks.

[Tom van Stiphout]

On 3 Feb 2005 03:04:28 -0800, "gooogle" <am**@scriptmate.com> wrote:

Access can easily handle this. Every night a new logfile is created.
At that time your Access app can wake up and import the old logfile,
index it, generate the standard reports, and be ready for ad-hoc
reports before you drag yourself into work in the morning.

-Tom.

Hi,

We need to log the fields from a IIS log into some database where it
can be sorted by date and id of a record. There will be about a million
records per day or more than that may be. What would be the best
solution for this apart from MSSQL ?
Anybody done this before ?

Thanks.