Bug #18368
closedMany Relations will cause performance problems
0%
Description
I'm using IRRE in some applications and there is an issue with the be-performance if there are too many datasets.
In my application I have 2800 Datasets which have m:n-relations to the page-tree (2300 datasets). The relation-table has 35000 entrys.
If I want to edit the page-properties i have to wait nearly 150 seconds until the dataset is loaded.
If I delete the entrys of the relation-table it takes 3 seconds to open the page-properties.
The funny thing is, that loading page-properties which have no relation to any dataset will also take 150seconds to load.
(issue imported from #M7752)
Updated by Oliver Hader over 16 years ago
I can confirm this. IRRE is currently loading everything.
Better would be to load only visible data - that implies that "appearance/collapseAll" has to be used when only visibles are fetched from storage.
Updated by Oliver Hader over 16 years ago
Could you please post the TCA setting of the IRRE field on the pages table?
Updated by Paints over 16 years ago
Here are my settings done in the ext_tables.php:
$tempColumns = Array (
'user_mgproducts_material' => Array (
'exclude' => 1,
'label' => 'LLL:EXT:user_mgproducts/locallang_db.xml:user_mgproducts_material_rel.product_id',
'config' => Array (
'type' => 'inline',
'foreign_table' => 'user_mgproducts_appearence_rel',
'foreign_field' => 'page_id',
'foreign_sortby' => 'pagesort',
'foreign_label' => 'product_id',
'foreign_unique' => 'product_id',
'maxitems' => 5000,
'appearance' => Array ('useSortable' => 1,),
)
),
);
t3lib_div::loadTCA('pages');
t3lib_extMgm::addTCAcolumns('pages',$tempColumns,1);
t3lib_extMgm::addToAllTCAtypes('pages','user_mgproducts_material;;;;1-1-1');
Updated by Alexander Opitz over 11 years ago
- Status changed from Accepted to Needs Feedback
- Target version deleted (
0)
The issue is very old, does this issue exists in newer versions of TYPO3 CMS (4.5 or 6.1)?
Updated by Alexander Opitz about 11 years ago
- Status changed from Needs Feedback to Closed
- Is Regression set to No
No feedback for over 90 days.