Hello,  
I measure time of time: number of rows is 15 000, using JDBC in both cases.
My case is such that ignite is cache of postgresql. Entire database is
loaded to cache (ignitevisorcmd shown 15 000 rows in cache scan).  
Ignite
SELECT COUNT(*): 53ms.
SELECT *:290 ms

Postgresql
SELECT COUNT(*): 3ms
SELECT *:89 ms.

Why ? I have no indexes in apache ignite. 



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Efficiency-worse-than-postgresql-Why-tp5040.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Reply via email to