Project

General

Profile

Actions
Copy link

Bug #18048

closed

Generating extension import list takes very long

Added by Steffen Heinrich almost 17 years ago. Updated about 13 years ago.

Status:
Rejected
Priority:
Should have
Assignee:
-
Category:
Extension Manager
Target version:
-
Start date:
2008-01-24
Due date:
% Done:

0%

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

Description

Apache 1.3, MySQL 5.0.27, PHP 5.2.3, Windows XP

Importing from TER and searching the imported list is taking about 6 minutes.

At first I had to increase max_execution_time to 600 in the php.ini to get beyond the white page. (The .tgz archive was always properly downloaded very quickly, but the inserts into table cache_extensions took about 5 minutes.)

Next I found that every lookup into the cached information also consumed around 6 minutes and extensions were sometimes not found, although they were in the table.

Some profiling done on class.em_index.php reveiled, that 96% of that time was spent on the effort to identify installed extensions that are not found in the cached repository. Specifically, for each such extension in line 861 this call gets executed:
$this->xmlhandler->searchExtensionsXML($extKey, '', '', true);

And inside this function which seems to have been implemented to retrieve / filter the repository once and for all, several requests to the db are done.
I'm sure this can be implemented more cleverly. (And I also put in question that this information "is-in-repository: yes/no" is relevant to many people.)

Cheers, Steffen

(issue imported from #M7264)

Files

7264.diff (881 Bytes) 7264.diff Administrator Admin, 2009-08-04 10:30
Actions
Copy link

Also available in: Atom PDF