Could Cassandra be optimized to store time-series data? This is a question that has become a common topic for discussion. I recently came across a great read that compares Cassandra performance to another dedicated time-series database, TimescaleDB.
Often users would like to add data values manually, especially when their organization still has a few pieces of equipment that are not able to have readings logged automatically. Most may not realize this is a free service that is included with all Canary Historian installations.
"40 percent of the workforce at electric and gas utilities will be eligible for retirement in the next five years."
Recently, a system integrator asked us to provide data that would provide both speed and storage requirement comparisons between an out-of-the-box SQL database and Canary. They wanted to use this data to decide whether it would be best for customer's to deploy a Canary system, or deploy, tune, and maintain an SQL system.
The tenth edition of a weekly Question and Answer column with Gary Stern, President and Founder of Canary Labs. Have a question you would like me to answer? Email firstname.lastname@example.org
The ninth edition of a weekly Question and Answer column with Gary Stern, President and Founder of Canary Labs. Have a question you would like me to answer? Email email@example.com