Too many categories

[diasf]

Hello

When I started my project in J 2.5 I thought there would be no problem with the number of categories I'd need. Now I have over 7000 categories created and have several problems, mainly because of too much time to open any page.

Searching over net I found that when the DB has more then a few 000s categories there are performance issues and also memory issues.

The project is not complete yet, as there are over 34000 (yes, thirty-four thousand) total categories. Now it's only below 1/4 of the total categories. I presume the real problems are just starting.

The categories are group in 3 leves, 1st level with 300 categories, each one with 1-to-7 2nd level categories, and the remaining 33000 in the 3rd level.

Can anyone help me? Any solution for this?

Is there any limit for the number of articles? As you may guess the complete project running will have lots-of-000s articles.

Any help?

Thank you very much

Fernando

[brian]

The first problem that you will be running into is a php limit on your server called max_input_vars - this defaults to 1000. You will need to increase that.

As for the number of articles there is a finite limit of 4,294,967,295.

Finally on a site such as this you will need good hosting - basic shared hosting will just not be good enough

[diasf]

Thank you Brian

That good hosting costs money... I need to be sure before even trying.
Let's suppose I have a good hosting and change the max_input_vars to... what? 35000?
Then will I be able to get the 34000 categories with, say, 40000 articles? Would it work?

When I insert or update an article the category drop-down box has all 34000 categories. Of course it must be disabled as it's much difficult to use it.

This way will it work?

[brian]

The only thing I can say for certain is that your site is too big for simple shared hosting (nothing to do with joomla it would be the same with any software)

[diasf]

I'm trying to create a way to replace most of the categories by articles. That means I'll have almost 2500 categories and some 10.000s articles. I presume the problem is with to many categories, there's no problem with too may articles. Is that so?

Is J 3 better than J 2.5 on this subject?

[brian]

J3 is considerably faster and a great deal of time has been spent on optimising the sql queries

But nothing will replace a good host