Re: Table Schema and Modelling

Peifong Ren wrote:
>
> We need to store 300 millions of records every day.
> Each record is 120 byte with 200+ fields.
> Each field can be used as a key to do search.
> There are about 6-10 fields will be used more than the others.
>
> Any suggestions on how to create database tables for this data?
> Also, can anyone suggest some way to model the query's performance?
>
> Any help will be greatly appreciated!
>
> Thanks,
> -Pei
>
> pren_at_cs.umass.edu

How can each record be 120 bytes long and have 200+ fields??? Do store bits???

Guy Received on Fri Jun 14 1996 - 00:00:00 CEST