How can I optimize the database for pushing messages using SSE?

The old program adds a new message reminder function. Currently, SSE can be used to push messages. In the backend PHP, a query statement is directly executed to check whether there are new messages, and if yes, the query statement is output. A relatively small site. The main concern is whether the server will be under too much pressure? How can we improve it? The old program adds a new message reminder function. Currently, SSE can be used to push messages.
In the backend PHP, a query statement is directly executed to check whether there are new messages, and if yes, the query statement is output.

A relatively small site. The main concern is whether the server will be under too much pressure? How can we improve it?

Reply content:

The old program adds a new message reminder function. Currently, SSE can be used to push messages.
In the backend PHP, a query statement is directly executed to check whether there are new messages, and if yes, the query statement is output.

A relatively small site. The main concern is whether the server will be under too much pressure? How can we improve it?

If the access volume is small, you can query the database. if the access volume is large, you can consider redis and so on.