Project

General

Profile

Actions
Copy link

Task #43412

closed

Tune SQL-queries on extension-list update

Added by Stefan Neufeind almost 12 years ago. Updated almost 10 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Extension Manager
Target version:
-
Start date:
2012-11-28
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
6.0
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

It seems that fetching the extension-list is actually quite fast. But depending on the database the actual inserting and updating-queries may take "ages". All queries happen as single SQL-queries and I assume thus trash the DB with rebuilding indexes etc. over and over again.

Actions
Copy link
 #1

Updated by Oliver Hader over 11 years ago

  • Target version set to 2222
Actions
Copy link
 #2

Updated by Oliver Hader over 11 years ago

  • Project changed from 2269 to TYPO3 Core
Actions
Copy link
 #3

Updated by Oliver Hader over 11 years ago

  • Category set to Extension Manager
Actions
Copy link
 #4

Updated by Oliver Hader over 11 years ago

  • Target version deleted (2222)
Actions
Copy link
 #5

Updated by Benni Mack almost 10 years ago

  • Status changed from New to Closed

I already did that and speeded up the importing of all extensions by a factor of 6. This got into 6.2, I hope it is sufficient (importing 10.000 records in 6 seconds). If not, let me know, I will then reopen the ticket.

Actions
Copy link

Also available in: Atom PDF