This discussion is archived
8 Replies Latest reply: Jan 7, 2013 6:45 AM by sb92075 RSS

Accessing DB tables records which are huge

800839 Newbie
Currently Being Moderated
Hi,


I have DB tables which stores millions of records as supposed to 1000 of records , hence accessing and retrieving these records
is a problem. We have also split the tables into various association tables to reduce the number of columns in a single table.
But still with these association tables also we need to use JOIN with the parent tables to retrieve the data. Since the tables
contains huge amount of records retrieving is a problem, we also have proper 3NF normalization used for logical grouping of data, as well
as we have the respective index created for the table columns. But still the problem persists, accessing and retrieving those
huge data set is a problem. Please let me know how we can design it better when we have huge record set stored in the tables
as well as millions of users accessing those records and same time?


Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points