Hi Manuel, Ignite is a grid solution, it is supposed to be scaled horizontally, so MySQL can be more efficient in some cases, but it can not scaled well. So ignite will win when you can not fit data on one machine and need to scale. So, load more data, use more machines and at some point Apache Ignite will show better performance.
Thanks, Mike. On Thu, Aug 27, 2020, 4:51 AM manueltg89 <manuel.trinidad.gar...@hotmail.com> wrote: > Hi!, > > I have a table with 4 millions of registers, with only 1 node in Apache > Ignite. I make a simple query to get all registers: > > select * from items; > > I make the query in Apache Ignite and this takes 83 seconds and same query > in MySQL takes 33 seconds. > > Is it normal? > > Thanks in advance. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
