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.
