Here I have such a request:

$conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT uMail FROM Users"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "".$row["uMail"]."<br>"; } } else { echo "0 results"; } $conn->close();

It is necessary to unload several tens of thousands of emails from the database. But I was told that during such a request, the base will hang and the project users may start having problems while executing their requests, something might get lost, not work, not be credited.

The question is whether it is possible to put a delay in this request somehow when uploading data. Or maybe there is some other solution?

  • do you need several tens of thousands of addresses at once to show on the page? what for? - teran
  • Several tens of thousands are ridiculous loads for mysql. well, or you have a very "good" hosting =) - Vladimir Klykov
  • Petty load, the request does not take even half a second. But the render of all these emails - can cause a hang (on the client's side, whose mind has decided to print this fiend on hell on one page) - dev_null

0