ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexei Scherbakov <alexey.scherbak...@gmail.com>
Subject Re: Unexpected performance issue with SQL query followed by error
Date Tue, 31 May 2016 08:54:22 GMT
>From your plan I see you have different data sets in Oracle and Ignite.
activiy scan in Oracle results in 117k scans, in Ignite 120k
activityuseraccountrole in Oracle results in 144k, in Ignite 1147k
etc

Please run performance test on the exactly same dataset.

2016-05-31 9:27 GMT+03:00 jan.swaelens <jan.swaelens@sofico.be>:

> Hi,
>
> Please fine the explain plan attached.
>
> explainplan.png
> <http://apache-ignite-users.70518.x6.nabble.com/file/n5338/explainplan.png
> >
>
> br
> jan
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5338.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 

Best regards,
Alexei Scherbakov

Mime
View raw message