[Maxman1544]

Originally Posted by Maxman1544

With over 12,000 bets placed and 6,000 records in some of the other tables the vbookie queries are hanging my server. Taking 10 minutes to run, it is killing our cpu.

$result = $db->query_read("
SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_created, item.item_open_until, item.item_
FROM " . TABLE_PREFIX . "vbookie_items AS item
LEFT JOIN " . TABLE_PREFIX . "vbookie_groups AS grp ON grp.group_id = item.group_id
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON thread.vbookie_item_id = item.item_id
WHERE item.item_status='".$db->escape_string($type)."'
ORDER BY $orderby item.item_id DESC
LIMIT $limit, $perpage

and this one

// Most bet-on Events
$result = $db->query_read("
SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_created, item.item_open_until, item.item_
LEFT JOIN " . TABLE_PREFIX . "vbookie_groups AS grp ON grp.group_id = item.group_id
ORDER BY item.item_n_bets_placed DESC
LIMIT 5

I wonder if I prune the data if it would help. Any thoughts?

http://www.vbulletin.com/forum/showp...3&postcount=85

Seems like the same issue I am having, interesting.