Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    DB Design and optimization

    I have an application that needs to handle huge amounts of data. I get roughly 100,000 records per hour. I need to store this information for several months. I would want to use MySQL as my DB.
    I have devised a set of archiving tables (EveryHour, EveryDay, EveryWeek and EveryMonth). I populate these tables from the previous tables after crunching. I am considering using multiple tables within the same level (as in EveryDay1, EveryDay2 etc). I would use a MetaData table which would have information about about how data is spread over these multiple tables based on start index and end index.
    Somehow I feel there must be a more optimal way of doing this with other DB design.

    Thanks is advance

  2. #2
    Join Date
    Sep 2002
    I don't suppose mySQL offers table partitioning? For example, Oracle lets you have a single table that is partitioned by some criteria, which enables easier data management (old partitions can be taken off-line for example).

  3. #3
    Join Date
    Dec 2003
    Tokyo Japan
    i also know that SQL Server also supports multiple partitions...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts