Hi Zaxo,

I'm using MySQL so stored procedures and triggers are not yet supported unfortunately.

I am deleting records when they are processed, so the database table is nearly always empty.

Maybe another intermediate database table could help? I was thinking of a table where the main process (which accepts the clients) stores the currently active client processes including their process id. So if the database process finds a message, it checks the process table to see if the client to which the message should be delivered is currently logged in. All it has to do after that is signal the process that there are messages waiting.

Maybe this is a good approach?

Regards,
Marcel