The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Optimizing a Query to Blog
Hi all -
On the homepage of my website (non-VB) I created links to the latest 2 blog entries. The query which finds the latest post does not seem to have a problem, but the query that grabs the second to last post seems to be sluggish. This one seems OK... Code:
SELECT * FROM vb_blog where state = 'visible' and blogid in (select max(blogid) from vb_blog where state = 'visible'); This one seems to slow things down... Code:
SELECT * FROM vb_blog where state = 'visible' and blogid in (select max(blogid) -1 from vb_blog where state = 'visible'); Any suggestions to speed this up? Thanks! |
#2
|
||||
|
||||
Why not a query to select both?
[sql]select * from vb_blog where state = 'visible' order by blogid desc limit 2;[/sql] |
#3
|
|||
|
|||
Thanks! Let me give that a shot.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|