Re: Table Schema and Modelling

Posted in 1996

Guy Bradet — Fri, 14 Jun 1996 08:25:55 -0700 — source: Informix-list mailing list archive (1991-1998)

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@cs.umass.edu How can each record be 120 bytes long and have 200+ fields??? Do store bits??? Guy