Articles loading very slowly in 1.6, sql query issue?

Discussion regarding Joomla! 2.5 Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
ccgr
Joomla! Intern
Joomla! Intern
Posts: 71
Joined: Thu May 15, 2008 2:58 pm

Articles loading very slowly in 1.6, sql query issue?

Post by ccgr » Wed Mar 09, 2011 10:38 pm

My main site www.ccgr.org is running 1.5.22 flawlessly we have thousands of articles and it's pretty quick.

Here's a freshly migrated site http://talk.ccgr.org/jupgrade/

When you go to reviews and then drill down to a category, pulling up a list of articles takes 45 seconds or longer.

Why is that? I doubt it's a server/mysql issue since I run 1.5.22 with no problems.

Is there a quick fix? I'll try installing a fresh 1.6.1 and try importing my articles manually but something is definitely wrong here.

I guess a way to quick fix it, is there a way to limit the results to 20,50,100 per page or something?

 
ccgr
Joomla! Intern
Joomla! Intern
Posts: 71
Joined: Thu May 15, 2008 2:58 pm

Re: Articles loading very slowly in 1.6, sql query issue?

Post by ccgr » Sun Mar 20, 2011 12:14 am

I figured outhow to fix the aritcle display limit but he ultimate problem was when I used the matware migration tool. When I tool the results from that migration and exported and imported the content via mysql on a fresh install the site work much better. We're now running the site on Joomla 1.6.1 www.ccgr.org

athi1234
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Thu Apr 07, 2011 7:01 am

Re: Articles loading very slowly in 1.6, sql query issue?

Post by athi1234 » Thu Apr 07, 2011 9:08 am

Hi,

how did you export und import the content via mysql, which tables did you transfer?

athi

ccgr
Joomla! Intern
Joomla! Intern
Posts: 71
Joined: Thu May 15, 2008 2:58 pm

Re: Articles loading very slowly in 1.6, sql query issue?

Post by ccgr » Thu Apr 07, 2011 12:46 pm

I used phpmyadmin to access the sql tables and I brought over the j16_content j16_catagories j16_weblinks j16_banners

athi1234
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Thu Apr 07, 2011 7:01 am

Re: Articles loading very slowly in 1.6, sql query issue?

Post by athi1234 » Thu Apr 07, 2011 12:53 pm

what about j16_assets, does joomla still work without the proper assets-table?

ccgr
Joomla! Intern
Joomla! Intern
Posts: 71
Joined: Thu May 15, 2008 2:58 pm

Re: Articles loading very slowly in 1.6, sql query issue?

Post by ccgr » Thu Apr 07, 2011 1:02 pm

I don't think I brought that one over

 

Locked

Return to “Performance - Joomla! 2.5”