[h2] Performance impact of repeated select on an empty table

Hi, I was wondering what sort of performance impact would I be seeing or even how to measure it. I have thread which is repeatedly every 2 sec hammering an event table with a select statement like "select * from myEventTable limit 10 offset 0". Mostly if the table is empty what is the

[h2] Re: Performance impact of repeated select on an empty table

On Wednesday, January 17, 2018 at 4:12:43 PM UTC+1, Ahsan Fayyaz wrote: > > Hi, > > I was wondering what sort of performance impact would I be seeing or even > how to measure it. > > I have thread which is repeatedly every 2 sec hammering an event table > with a select state