Just testing CockroachDB labs. Product looks amazing but I’m probably doing something way off because the numbers I’m getting look a bit disappointing. I’m testing locally on a Windows10 machine.
MySQL: 0.002 s
I know that databases are competing in a different universe but wasn’t expecting such a drop. The table is pretty simple:
CREATE TABLE IF NOT EXISTS `data_bucket` ( `time` decimal(17,3) NOT NULL DEFAULT '0.000', `provider` enum('A', 'B', 'C') NOT NULL, `instrument` varchar(24) NOT NULL, `bucket` enum('1S','1M','1H','1D') NOT NULL, `open` double unsigned NOT NULL, `high` double unsigned NOT NULL, `low` double unsigned NOT NULL, `close` double unsigned NOT NULL, PRIMARY KEY (`time`,`provider`,`instrument`,`bucket`), KEY `instrument_bucket` (`instrument`,`bucket`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 /*!50100 PARTITION BY KEY (instrument) PARTITIONS 10 */;
I’ve populated both instances with 120 million rows.
Actually kudos on the excellent IMPORT command.
The query I’ve used for above numbers looks like this:
select * from data_bucket where 1 = 1 and provider = 'A' and instrument = 'ES_1' and time >= 20061127000000.000 and time <= 20081129000000.000 and bucket = '1D' limit 2000
Any idea if I’m doing something wrong or, if with this kind of data/query such is to be expected?