Hi, I didn't see my post here immediately , so I thought its lost. I started the discussion about this on stackoverflow below than. It has more information:
https://stackoverflow.com/questions/48302621/how-bad-is-repeated-select-on-an-empty-table-in-h2-database/48305109#48305109 Regards 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 statement like "select * from myEventTable limit 10 offset > 0". Mostly if the table is empty what is the performance impact. If there > are events I read and process them and delete them. So next time the table > might be empty again. > > What if I replaced this mechanism with this Trigger notification for > insert events. This can be found here > <https://stackoverflow.com/questions/19319093/h2-trigger-notifier-not-called-in-automatic-mixed-mode-auto-server-true-on-re> > > on stackoverflow by the author of H2 database. Would this approach be any > better. Would this be more mem/processing overhead or the previous > approach with the select statement every 2 secs. > > What could be recommended ? > > Regards > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
