ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From woo charles <ignite.charl...@gmail.com>
Subject Slow on 1st time query "SQL Join"
Date Mon, 10 Apr 2017 05:13:18 GMT
Hi,

I set up 3 Server nodes(8 cpu, 1gb ram) in the same server.
2 table each 10000 rows are entered.

When I perform a *SQL Join* query on two table and run it 100 times, I
found that the first query is much slower than other(i.e. First query used
13s & other used around 0.02s).

Why will it happen?
Can I reduce the running time on 1st query?

Mime
View raw message