Member Avatar for technobum
technobum 0 Newbie Poster

Hello all,

I will be creating a mySQL database to store telemetry that will be grabbed from an instrument at a rate of once per second.

Are there design considerations that I should take into account in order to achieve this insertion rate? The database will eventually grow to about 200 GB in size. Will speed become factor as it grows or can the average computer handle this type of data processing rate? Is it common practice to have a temporary db for short term storage and another one for long term storage?

  • 1 Contributor
  • 0 Replies
  • 47 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.