•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 426,469 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,214 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 568 | Replies: 0
 |
•
•
Join Date: Aug 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Wordpress, Joins and Indexes Greetings. My first post.
I'm running a fairly popular wordpress blog (about a million page views a month).
I have a plugin called "recent comments" which lists the last 20 or so comments in the sidebar of the site. However, the queries it makes are very disk and CPU intensive. It's Joining two very large tables together (left join). It takes the post title, author and an excerpt of the comment and melds them together.
These joins cannot be cached in memory because they contain TEXT columns. I was wondering if anyone knew if I could create some kind of index to help speed up these queries. They're killing my site really, and I do not want to remove this functionality from the site.
I was considering re-structuring the way "recent comments" and "recently commented" items are displayed (i.e., separately, instead of via a Joined query and temp table.. but I'm at a loss here.
Any suggestions?
I'm running a fairly popular wordpress blog (about a million page views a month).
I have a plugin called "recent comments" which lists the last 20 or so comments in the sidebar of the site. However, the queries it makes are very disk and CPU intensive. It's Joining two very large tables together (left join). It takes the post title, author and an excerpt of the comment and melds them together.
These joins cannot be cached in memory because they contain TEXT columns. I was wondering if anyone knew if I could create some kind of index to help speed up these queries. They're killing my site really, and I do not want to remove this functionality from the site.
I was considering re-structuring the way "recent comments" and "recently commented" items are displayed (i.e., separately, instead of via a Joined query and temp table.. but I'm at a loss here.
Any suggestions?
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Joins (MySQL)
- nested joins, from mdb. Possible? (Visual Basic 4 / 5 / 6)
- need help optimizing (MS SQL)
- Problem with Rewriting Subqueries as Joins (Database Design)
- Problem with Rewriting Subqueries as Joins (MS SQL)
- WordPress Calendar CSS, anchor problem (HTML and CSS)
- Indexes? (Database Design)
Other Threads in the MySQL Forum
- Previous Thread: INSERT INTO doing double duty
- Next Thread: Query on a large table too slow
