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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.