•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 426,464 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,255 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 1022 | Replies: 0
 |
•
•
Join Date: Jul 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 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?
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?
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- How insert image into mysql database and retrieve (PHP)
- insert values to mysql database (JSP)
- Blon insert in MySQL using ODBC in C# win Application (C#)
- php & mysql (MySQL)
- dynamically generated textboxes & radio buttons php, insert into db (PHP)
- insert image into mysql (Visual Basic 4 / 5 / 6)
Other Threads in the MySQL Forum
- Previous Thread: Recommend MySQL admin tool for me?
- Next Thread: Nested insert queries in a single query
