[solved] Huge performanc problems using flexicontent

Hi,
I run a site with over 800 articles (growing daily) and now I want to switch from a wordpress component to flexicontent. For testing purposes I installed two versions of the site on a testing server. One version is a 1:1 copy of the entire site and the other one uses flexicontent. I do not use the joomla cache because I had lots of problems with it but till now the over-all-performance of the site was ok: about 4 seconds for the original site on the testing server for a category page with 10 articles without flexicontent.
The loading time for the same page using flexicontent is 21 seconds which is definetly too much.
Since the problem occured directly after installing flexicontent I assume the problem must be with flexicontent.
Any ideas?

OK, I think its not flexicontents' fault but its strange anyway:
First I deactivated everything that did not directly belong to Joomla - still slow. Then I deleted all 800 articles and reimported them with the "export content" component. After binding the articles in flexicontent everything was fine.
Does anyone have an idea why I had to delete and reimport all articles in order to get an acceptable performance?

... nothing .. import problme ...
sorry
can you edit your post to add [solved]
regards

micker wrote: ... nothing .. import problme ...
sorry
can you edit your post to add [solved]
regards

I edited and renamed it but this still is a problem for me so it's not really solved.
Using a copy of the original site and iporting the content to flexicontent using the standard procedure as described in the documentation did lead to poor performance. Also using 3rd party components to import 800 articles is a lot of work which I'd like to avoid not to mention the transfer of all the attached images and the comments that were not moved and will have to be inserted by hand now. I'm still trying to find a way to cleanly convert my "Wordpress for Joomla Site" into a "Flexicontent site".

I was having similar issues with performance it was related to using lots of subcategories. See the fix below which helped a lot. I am still working on more tweaking performance.

I also used some if statements in the flexi plugins so they wouldn't load unless being used.

We have 6 main categories which each have about 12 subcategories and about 3000 articles.

This fix is strictly related to displaying sub categories though.

code.google.com/p/flexicontent/i ... tail?id=93

great news
thanks for your work

Hi,
Please would you explain the problem more. Is it with the number of cat and subcats or is it a problem of importing?

Thanks

Hi fesghel i am assuming this is in response to the bug tracker post to investigate this.

The issue is when you have a lot of subcategories.

We had 10 subcategories and we have about 3000 articles. We were linking to the main category which then pulls in the subcat content.

The getdata function is inside of a for loop for a subcategory function inside the category view model and for that specific call it looks like it does nothing.

We had some big performance issues and when i looked at my joomla debugger to look at the queries i noticed 6 queries for each sub category 2 of these queries were very db heavy and were identical except for a limit that was added to one of them. Each of those queries took .3 seconds. so .6 second per sub category x 10 - 12 = way to long. Our page loads reflected this as well as typical page load for just those pages was around 10 seconds with file & flexi caching on! With caching off it was 20 - 30 seconds!

Now that i removed the getdata function call there is only 1 query per subcategory and it is not db intensive.

Our page loads time are around 1.5 seconds now with caching. With cahing 2.5 - 3 seconds.

Please keep me up to date on what you find i would be interested to hear it. I can provide you with a dev environment to see the issue in action if you want just pm me.

hello i send this to manu
regards

It seems the problem is with the nesting, right? I mean the problem will show up when we have something like this:
CatA:
-SubCatA
--Sub(SubCatA)
---Sub(Sub(SubCatA))
.
.
.
Am I right?
I have a category that each month one subcat will be added to it. Something like this:
CatA:
-subcat1
-subcat2
-subcat3
.
.
.
According to what you said, the query to get data from subcat1 should take time just like the corresponding query for subcat2 and the added time for the query(that should be doubled) won't make a serious trouble, though we'd better to heal it just now.

Thanks