Monday, July 29, 2019

YouTube Channel

https://www.youtube.com/channel/UC-L1oTcH0ocMXShifCt4JQQ

I created a couple new videos that demonstrate the speed and flexibility of the Didget System's database functions. I loaded in the Chicago crime data available in CSV or Json format on the city's open data portal. Anyone can go download this decent-sized table (nearly 7 million rows and 22 columns).

I loaded this data into Didgets as well as Postgres and did some benchmarks.  On average, the Didget System could query the table in about 1/4 of the time it took Postgres. I ran dozens of queries and saw results anywhere from twice as fast to up to ten times as fast. I saw similar results using SQL Server and MySQL.