Selecting RID from indexes is very slow

[AaronSchulz]

select key from index:ProperyIdIdx limit 1000

Takes .006 seconds

select key,rid from index:ProperyIdIdx limit 1000

Takes 7.331 seconds

select rid from index:ProperyIdIdx limit 1000

Takes 7.249 seconds

select from index:ProperyIdIdx limit 1000

Takes 7.191 seconds

The index has about ~1300 records.

[AaronSchulz]

This might be limited to the console, at least it seems faster using the HTTP SQL API.

[lvca]

Right, try with explain as prefix.

[AaronSchulz]

orientdb {db=WikiData}> explain select from index:ProperyIdIdx limit 1000

Profiled command '{user:#5:0,elapsed:3.559869,resultType:collection,resultSize:1000}' in 0.004000 sec(s):
{"@type":"d","@Version":0,"user":"#5:0","elapsed":3.559869,"resultType":"collection","resultSize":1000,"@fieldTypes":"elapsed=f"}
orientdb {db=WikiData}> explain select id from index:ProperyIdIdx limit 1000

Profiled command '{optimizationElapsed:0,user:#5:0,elapsed:4.19173,resultType:collection,resultSize:1000}' in 0.005000 sec(s):
{"@type":"d","@Version":0,"optimizationElapsed":0,"user":"#5:0","elapsed":4.19173,"resultType":"collection","resultSize":1000,"@fieldTypes":"optimizationElapsed=l,elapsed=f"}

Schema is at https://github.com/AaronSchulz/WikiDataQueryOrient/blob/master/sql/schema.sql .

[lvca]

So times are comparable, right? I'm closing it.

[AaronSchulz]

"explain" is fast, but without explain you can see the difference (see the initial times). It might be something in the console code that formats and displays the results.