Ok I jsut converted Rygels version to this and alot of our users have loads of entrys.
The problem is if I click someone with over 500 entrys it takes about 2 minutes for the page to load. Something is obviously not right anyone got any ideas I've quoted the querie that seems to be causing the problem
User with 500 entrys...
105.45921612 seconds (0.26% PHP - 99.74% MySQL) with 17 queries
Quote:
Query:
SELECT journal_entries.entry_id, journal_entries.entrytitle,
journal_entries.entrytext, journal_entries.mood, journal_entries.allowbuddies,journal_entries.entry date,
journal_entries.entry_totalvotes, journal_moods.mood_name, journal_entries.ipaddress,journal_moods.mood_image , journal_entries.entry_totalrating,
journal_entries.private, journal_entries.whocanview,
COUNT(journal_comments.comment_text) AS comments
FROM journal_entries AS journal_entries
LEFT JOIN journal_comments AS journal_comments ON (journal_entries.entry_id=journal_comments.entry_i d)
LEFT JOIN journal_moods AS journal_moods ON (journal_moods.mood_id=journal_entries.mood)
WHERE journal_entries.journal_id='62'
AND entry_active='1'
GROUP BY journal_entries.entry_id
ORDER BY entrydate ASC
LIMIT 0,10
Time before: 0.66441702842712
Time after: 93.359127044678
Time taken: 92.694710016251
table type possible_keys key key_len ref rows Extra
journal_entries ALL 16789 Using where; Using temporary; Using filesort
journal_comments ALL 13251
journal_moods eq_ref PRIMARY PRIMARY 4 journal_entries.mood 1
Ok I jsut converted Rygels version to this and alot of our users have loads of entrys.
The problem is if I click someone with over 500 entrys it takes about 2 minutes for the page to load. Something is obviously not right anyone got any ideas I've quoted the querie that seems to be causing the problem
User with 500 entrys...
105.45921612 seconds (0.26% PHP - 99.74% MySQL) with 17 queries
Working from memory as I don't have access atm, I don't think there are any indexes on any of the journal tables - I would guess from this that some are required.
I added an Index to journal_entries for journal_id
and
Two indexes to journal_comments one for journal_id and one for entry_id.
Same user
Page generated in 0.37919092 seconds (69.15% PHP - 30.85% MySQL) with 17 queries
Quote:
Query:
SELECT journal_entries.entry_id, journal_entries.entrytitle,
journal_entries.entrytext, journal_entries.mood, journal_entries.allowbuddies,journal_entries.entry date,
journal_entries.entry_totalvotes, journal_moods.mood_name, journal_entries.ipaddress,journal_moods.mood_image , journal_entries.entry_totalrating,
journal_entries.private, journal_entries.whocanview,
COUNT(journal_comments.comment_text) AS comments
FROM journal_entries AS journal_entries
LEFT JOIN journal_comments AS journal_comments ON (journal_entries.entry_id=journal_comments.entry_i d)
LEFT JOIN journal_moods AS journal_moods ON (journal_moods.mood_id=journal_entries.mood)
WHERE journal_entries.journal_id='62'
AND entry_active='1'
GROUP BY journal_entries.entry_id
ORDER BY entrydate DESC
LIMIT 0,10
Time before: 0.11116099357605
Time after: 0.16626906394958
Time taken: 0.055108070373535
table type possible_keys key key_len ref rows Extra
journal_entries ref journal_id journal_id 4 const 417 Using where; Using temporary; Using filesort
journal_comments ref entry_id entry_id 4 journal_entries.entry_id 3
journal_moods eq_ref PRIMARY PRIMARY 4 journal_entries.mood 1
Ok I just like others have missing info in the usergroup area in the adminCP. I even came here to the link where it said to replace the code in the FTP admin/usergroup.php and im still having the same problem. Even after I chaged what was said in the link, nothing was fixed. I am currently runnin VB 3.0.7, if anybody has any other ideas on how I can fix problme id really appreciate it.
Ok I just like others have missing info in the usergroup area in the adminCP. I even came here to the link where it said to replace the code in the FTP admin/usergroup.php and im still having the same problem. Even after I chaged what was said in the link, nothing was fixed. I am currently runnin VB 3.0.7, if anybody has any other ideas on how I can fix problme id really appreciate it.
Hey, I have a question. I have just installed it and it seems like it works, though I can't do anything with the journal. When I got to the link it says that my account doesn't have permission even though I am the admin. Any thoughts. Also, I have three templates in stalled on my forum. How could i edit and move the templates without having to do it manually.
vB Journal for vBulletin 3.0.3(v1.0.1) Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
04-19-2005, 07:05 PM
