Is minimizing the assets table in joomla 3 possible?

Question

Joomla

Joomla 3 has an assets table, in which an entry is written for each Joomla article. Actually, is it possible to get rid of this somehow? (We are talking about filling articles with a size of 1,000,000 pieces. Actually, so that the database does not grow much and get the maximum speed of work)

Maybe I'm just doing something wrong: maybe I don't need to use the "standard" articles component Joomla for such volumes of information and it is necessary to use another component?

Answer 1

You cannot get rid of this, because the assets table is used for ACL - access rights to elements (materials, contacts, etc.). Information of third-party components is also written there if they use ACLs.
Unfortunately, it is not possible to disable ACL in Joomla.
If you find a material component that works without an ACL, then most likely you will get a speed boost and the table will not grow.

Answer 2

Then the question is: how are the `lft` and `rgt` columns filled in? (On the basis of what these numbers are taken) Just when trying to import "1,000,000" records using Joomla functions, 50,000 records are imported per day. That's bullshit. How can I manually populate these columns?