Table Schema and Modelling
From: Peifong Ren <pren_at_cs.umass.edu>
Date: 1996/06/14
Message-ID: <4pqbeo$405_at_kernighan.cs.umass.edu>#1/1
Date: 1996/06/14
Message-ID: <4pqbeo$405_at_kernighan.cs.umass.edu>#1/1
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 Received on Fri Jun 14 1996 - 00:00:00 CEST