Here is the test with equivalent dataset and PostgreSQL 9.4 which supports embedded JSON documents.
OrientDB query: *select mea from MeasurementValue where date = '2014-07-19' unwind mea limit 1000* which takes *12.4 seconds* is equivalent to PostgreSQL query: *select jsonb_array_elements(mea) as mj from measurementvalue where date = '2014-07-19' limit 1000* which takes *44 ms *as you can see in screenshot below. This is 280 times faster! <https://lh3.googleusercontent.com/-c71gjEw_OW0/VcJ3eN_HhmI/AAAAAAAAIAo/aRRD8tfVMMw/s1600/Postgre1.PNG> If I remove limit and also make projection of JSON elements it takes only 920 ms to return over 130.000 rows (second screenshot). Like in MS SQL I haven't created index for date column. <https://lh3.googleusercontent.com/-83FMi3faBxw/VcJ47fes2HI/AAAAAAAAIA0/LoBHjGyHrfQ/s1600/Postgre2.PNG> Regards, Ivan. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
