<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Verdana">Hi Pete, <br>
<br>
Do this in one simple swift query using the select statement along the
following lines <br>
<br>
<br>
insert into user_messages (user_id, message)<br>
select user_id, 'my message blah blah blah' <br>
from users; <br>
<br>
remembering of course to quote the message string<br>
<br>
This should be quick enough for you<br>
<br>
Dave<br>
<br>
<br>
</font></font>
<div class="moz-signature">
<table border="0" cellpadding="0" cellspacing="0" width="670">
<tbody>
<tr>
<td><a href="http://www.neteffekt.co.uk" target="_blank"><img
src="cid:part1.08090406.01040207@neteffekt.co.uk" border="0"
height="156" width="670"></a></td>
</tr>
<tr>
<td><a href="http://threeboxes.co.uk" target="_blank"><img
src="cid:part2.07080702.09020209@neteffekt.co.uk" border="0"
height="44" width="670"></a></td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
pete graham wrote:
<blockquote
cite="mid:39578dbe0903250813y783e732cne22c26d81e534428@mail.gmail.com"
type="cite">
<pre wrap="">Good afternoon developers,
I would like your advice. I have a website which has an internal
messaging system for users. The site admins have the ability to send
out a message to all users on the site.
The site has around 6,000 users currently and uses a MySQL Database.
The admin messages go into a admin_messages table. They then get
inserted into the messages table when a user logins into the site (the
separate messages table is required as we need to record is a user has
read messages).
We now want to send an email notification when the admin sends a
message. I'm concerned if I trigger 6,000 mysql inserts when an admin
sends a message it will flood the DB connection. Am I being paranoid
or could this kill the site/DB?
Here are the solutions I've been considering:
- set up a cron job to batch insert the data into the messages tables
- use some form of clever sub query to insert the multiple items
(could this also risk killing the db?)
- leave the message insert logic as it is and modify the batch email
sending to work from a join on admin_messages with the users table
I'm open to other suggestions, if anybody has them. I predict the user
base of the site could grow to around 20,000 users.
Thanks,
Pete
_______________________________________________
Phpwm mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Phpwm@mailman.lug.org.uk">Phpwm@mailman.lug.org.uk</a>
<a class="moz-txt-link-freetext" href="https://mailman.lug.org.uk/mailman/listinfo/phpwm">https://mailman.lug.org.uk/mailman/listinfo/phpwm</a>
</pre>
</blockquote>
</body>
</html>