SQL fails

Post Reply

SQL fails

ZiNgA BuRgA Offline

Fag

Posts: 3,357
Joined: Jan 2008

Post: #6

RE: SQL fails

The MyBB solution is to cache the count in the threads table.
But maybe I'm wrong, check MySQL's explain function to see how it's running the query (note that small result sets may be inaccurate).

My Blog

08-23-2012 08:32 AM

Post Reply

« Next Oldest | Next Newest »

Messages In This Thread

SQL fails - Sama34 - 08-22-2012, 09:13 AM

RE: SQL fails - ZiNgA BuRgA - 08-22-2012, 10:36 AM

RE: SQL fails - Sama34 - 08-22-2012, 12:59 PM

RE: SQL fails - ZiNgA BuRgA - 08-22-2012, 02:13 PM

RE: SQL fails - Sama34 - 08-22-2012, 06:22 PM

RE: SQL fails - ZiNgA BuRgA - 08-23-2012 08:32 AM

RE: SQL fails - Sama34 - 08-25-2012, 04:24 AM

RE: SQL fails - ZiNgA BuRgA - 08-25-2012, 11:30 AM

RE: SQL fails - Sama34 - 08-25-2012, 04:52 PM

Threaded Mode \| Linear Mode Standard Tools
Forum Jump: View a Printable Version Send this Thread to a Friend Subscribe to this thread