CODEWITHSUNDEEP
orientdb
akizze01
akizze01

Reputation: 3

Orientdb Super Slow Query Performance

I have tried several things for far too long and I am struggling with the performance of Orientdb Community edition 3.0.0RC2. The current query takes anywhere between 60-100 seconds to run but I would think it should take milliseconds since it is only 27k records to scan with an index setup. The server (normal server config) is setup on my personal computer which has 8gb of memory and HDD.

Query to run: select count(*) from ClassA where InitialInvestment = 2000

Index (all have been "rebuilt"):

Class DataRecord (strangely, 0 records show in Schema view in Studio but the items in the embedded list show a class of "DataRecord" - will ask about this later). This class only has three DOUBLE fields and one Date field. Doubt this class is affecting the query given I am not trying to query it.

Any thoughts?

Upvotes: 0

Views: 286

Answers (1)

Lvca
Lvca

Reputation: 9060

  1. Don't use a Release Candidate when v3.0 GA is out by more than 1 month. Right now you can get the v3.0.2 GA is out.
  2. Could you please execute the explain? explain select... so you can check if any indexes were used. Please post the result by updating your question.
  3. It looks like your records are too fat by embedding 9-10 thousands of DataRecord objects. Much lighter creating the DataRecord objects outside the main record and link to them.

Upvotes: 0

Related Questions