Announcement

Announcement Module
Collapse
No announcement yet.

Large table

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Large table

    Hi,

    I have a script that creates between 60 and 2000 records a minute in a table with only 4 columns, over time this table will get very large....

    Is there any way I can build the database for this to run fast even with large ammounts of data?

    Richrad

  • #2
    Partitioning and indexes. What's the read load expected to be vs. the write load?

    Comment


    • #3
      I can imagine the read to be alot more...

      As there will be only one script that will write a load of data once every minute... but multiple clients will generate graphs and stats from that data throughout the day...

      Comment

      Working...
      X