Future Request Menu and Database

Discussion regarding Joomla! 3.x 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.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
kitan
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Aug 10, 2017 1:16 pm

Future Request Menu and Database

Post by kitan » Fri Aug 11, 2017 2:36 pm

Would it not make sense for each menu to create its own table in the database?

Why?

Suppose you have 100 menus. For each language a menu ...

And in each menu you have 200 menu items. Then 20,000 menus are created in the database "_menu". This table is almost as large as the rest of the database.

In addition, there are extreme problems with the order "lft" - "rgt". If you change the order in the backend, it can happen that everything in the database table "_menu" is mixed. Then the only way to change the order, is in the database by hand.

If each menu had its own table, then the table would not be so large and there would be no problems with the order and the performance would be better.

Menu-1 DB: _menu1
Menu-2 DB: _menu2

And so on ...

Could this be considered in future versions of Joomla? Thank you ;)

User avatar
ranwilli
Joomla! Master
Joomla! Master
Posts: 19203
Joined: Sun Feb 19, 2006 6:47 pm
Location: Toledo, OH
Contact:

Re: Future Request Menu and Database

Post by ranwilli » Sun Aug 13, 2017 6:19 pm

Have you tried the "rebuild" button in the toolbar?
Don't HACK the Joomla! core, Instead "Extend" and/or "Override."
Stay ON the update path.
https://harpervance.com

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30940
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Future Request Menu and Database

Post by Per Yngve Berg » Sun Aug 13, 2017 7:36 pm

The downside is that the database structure is no longer static, but a new table have to be created with each menu.


Locked

Return to “Performance - Joomla! 3.x”