Register Log In

UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support simple sql query causing 100% cpu usage for minutes

Print Thread

Hop To

Re: simple sql query causing 100% cpu usage for minutes bakerzdosen #217299 09/25/2008 3:12 AM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA	Are you still seeing this query as the slowdown cause? select COUNT(t1.POST_ID) as posts, sum(t1.POST_IS_TOPIC) as topics from ubbt_POSTS as t1 That is only run when the options to show total unread topics/posts is turned on.

Entire Thread
Subject	Posted By	Posted
simple sql query causing 100% cpu usage for minutes	bakerzdosen	09/24/2008 7:26 PM
Re: simple sql query causing 100% cpu usage for minutes	Rick	09/24/2008 8:10 PM
Re: simple sql query causing 100% cpu usage for minutes	bakerzdosen	09/24/2008 9:30 PM
Re: simple sql query causing 100% cpu usage for minutes	bakerzdosen	09/24/2008 10:22 PM
Re: simple sql query causing 100% cpu usage for minutes	Rick	09/25/2008 7:12 AM
Re: simple sql query causing 100% cpu usage for minutes	Rick	09/25/2008 7:13 AM
Re: simple sql query causing 100% cpu usage for minutes	bakerzdosen	09/25/2008 6:42 PM
Re: simple sql query causing 100% cpu usage for minutes	Gizmo	09/25/2008 11:56 PM
Re: simple sql query causing 100% cpu usage for minutes	Rick	09/26/2008 4:25 PM
Re: simple sql query causing 100% cpu usage for minutes	bakerzdosen	09/30/2008 6:26 AM
Re: simple sql query causing 100% cpu usage for minutes	bakerzdosen	10/01/2008 4:37 AM
Re: simple sql query causing 100% cpu usage for minutes	GregH	10/03/2008 8:23 AM
Re: simple sql query causing 100% cpu usage for minutes	hatter	10/08/2008 4:50 AM
Re: simple sql query causing 100% cpu usage for minutes	Rick	10/08/2008 5:10 AM
Re: simple sql query causing 100% cpu usage for minutes	ntdoc	10/08/2008 10:55 PM

Link Copied to Clipboard

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM

Bots
by Outdoorking - 04/13/2024 5:08 PM

Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM

Who's Online Now

2 members (Geoff, Ruben), 1,011 guests, and 179 robots.

Key: Admin, Global Mod, Mod

Random Gallery Image

Latest Gallery Images

Los Angeles

Los Angeles
by isaac, August 6

3D Creations

3D Creations
by JAISP, December 30

Artistic structures

Artistic structures
by isaac, August 29

Stones

Stones
by isaac, August 19

Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)