Re: High-Speed/Volume Database

2002-05-06 Thread mos
At 12:56 PM 5/6/2002, you wrote: >We are designing an application that needs to use >a relational database to hold quite a large amount >of data. > >In particular there is one table that has about 33 >fields, 18 indexes, and 120 bytes per record. >Additionally, we are going to need to add about 2

Re: High-Speed/Volume Database

2002-05-06 Thread Gabriel
Over here, we're doing an average of 95 queries per second (that's about 8 mill daily), on a Pentium III @ 900MHz with 768MB of ram. We're working with smaller data sets, than 30 million records, tho. I imagine that you could do well with a high end intel system, or a medium-end Sun box. A d