List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:December 21 2006 4:02pm
Subject:Re: What to do if a table is supposed to get > 3GB data per day?
View as plain text  
In the last episode (Dec 21), Asif Lodhi said:
> Would you like to express your opinion as to what design strategy to
> take if a table (used for read operations only) is supposed to get
> more than 3GB of data per day? With 1000 simultaneous users ?

With that data rate, you'll definitely have to use partitioning or
MERGE tables, and generate a table per day or something similar. 
Otherwise aging records out of the table would be impossible.  You
didn't mention the insert rate, size of the records inserted, or
expected queries, so it's difficult to suggest which storage engine to
use.  The archive engine will significntly reduce your 3gb data size,
for example, but doesn't support indexes.

-- 
	Dan Nelson
	dnelson@stripped
Thread
What to do if a table is supposed to get > 3GB data per day?Asif Lodhi21 Dec
  • Re: What to do if a table is supposed to get > 3GB data per day?Dan Nelson21 Dec
  • Re: What to do if a table is supposed to get > 3GB data per day?ViSolve DB Team27 Dec
    • Re: What to do if a table is supposed to get > 3GB data per day?Saqib Ali27 Dec