Re: Table suggestions..

2001-02-08 Thread hooker
> I am writing an application that will poll up to 500 devices every 5 > minutes. For this application I need to keep at least 6 months of data. If > I were to use a single record for every update, I would have ~25 million > records. Obviously this is not an ideal solution. > > I am intereste

RE: Table suggestions..

2001-02-08 Thread Carsten H. Pedersen
> I am writing an application that will poll up to 500 devices every 5 > minutes. For this application I need to keep at least 6 months > of data. If > I were to use a single record for every update, I would have ~25 million > records. Obviously this is not an ideal solution. Why not? Given

Table suggestions..

2001-02-08 Thread Matt Glaves
I am writing an application that will poll up to 500 devices every 5 minutes. For this application I need to keep at least 6 months of data. If I were to use a single record for every update, I would have ~25 million records. Obviously this is not an ideal solution. I am interested in gettin