Project

General

Profile

Actions

Bug #18368

closed

Many Relations will cause performance problems

Added by Paints over 16 years ago. Updated about 11 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2008-03-04
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.1
PHP Version:
4.3
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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)


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Bug #17254: Multiple retrieval of all table rowsClosed2007-04-27

Actions
Related to TYPO3 Core - Feature #17247: Load Inline Elements On DemandClosedSusanne Moog2007-04-26

Actions
Actions #1

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.

Actions #2

Updated by Oliver Hader over 16 years ago

Could you please post the TCA setting of the IRRE field on the pages table?

Actions #3

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');

Actions #4

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)?

Actions #5

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.

Actions

Also available in: Atom PDF