I'm running a simple query to show forum posts. I've expanded my basic query to show a count of all the replies for each forum post:
TOP 50 f.postDate AS datePosted,
f.postTitle AS title,
(SELECT COUNT(*) FROM tbl_forums WHERE postParentID = f.ID) as replies
tbl_Forums f INNER JOIN
tbl_Users u ON f.userID = u.userID
This seems rather inefficient from a resource perspective because it reads as though the count takes place for every row. Maybe I'm wrong, but is there a better way to construct this query??
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…