mysql for mac not displaying results grid

MYSQL FOR MAC NOT DISPLAYING RESULTS GRID FULL
MYSQL FOR MAC NOT DISPLAYING RESULTS GRID CODE
MYSQL FOR MAC NOT DISPLAYING RESULTS GRID OFFLINE

* inspecting the primary key of the table, it can get this ID instantly usingġ0 - We want the most recent 10 comments, skip over first 10 IDs.Ĭ.id > - !! USING THE CUT-OFF ID TO LIMIT CROSS-PRODUCT !! * the INNER JOIN condition in the subsequent query. * Let's get the 11th-from-last comment ID that we can use to drastically limit

MYSQL FOR MAC NOT DISPLAYING RESULTS GRID FULL

This time, instead of the query scanning the blog_comment table first, it performs a full table scan of the blog_entry table in order limit the results to where the isActive=1 condition can be satisfied.

Here's a truncated version of the SQL query without the isActive check ( SELECT statement is truncated because it's not relevant to the conversation): Let's take a quick look at that incomplete query first so that we can see exactly where I messed up. But, when I first authored this query, I suspect that I had forgotten about the isActive check and left it out.

MYSQL FOR MAC NOT DISPLAYING RESULTS GRID OFFLINE

This boolean allows me to take blog posts offline without actually deleting them. While there is nothing of particular surprise in the blog_comment and member tables, the blog_entry table has an isActive boolean. This data is gathered across three tables: If you go to the homepage of this blog, you'll see a 'Recently Posted Comments' section that shows the 10 most recent comments along with the 'member' that posted the comment and the 'entry' on which the comment was posted. I love how clever the MySQL query optimizer is sometimes so, I thought this might be worth a closer look. But, as I began to tweak the SQL query, I realized what happened: an earlier version of the query was using indexes but then, I made a small change that completely altered MySQL's query execution. At first glance, I thought I must have forgotten to check the performance characters of the SQL query with EXPLAIN.

MYSQL FOR MAC NOT DISPLAYING RESULTS GRID CODE

Yesterday, while editing some ColdFusion code for this blog, I had a face-palm moment: I came across a query - the 'recent comments' query on the homepage - that was almost certainly performing a full table scan of comments.

Mysql for mac not displaying results grid