Allow batch import of packages locale XML-files
Description
The translator is currently causing a lot of overhead while importing localization variables.
This includes, checking if the variable exists multiple times, inserting it and then executing an UPDATE query to process one localization variable.
As our localization files grow and we are issueing to many SQL-queries, we are adding even more overhead.
We want to implement a new feature to add all variables from one locale.xml file
as batch in a single SQL-Query.
By reducing the overhead we will increase the performance of our setup by a large amount.
Reasons
- Timeouts during setup process on slow machines
- Reducing overhead
- Performance
Steps to implement
- Add new method \QUI\Translator::batchImport()
- Read content of
locale.xml
- Build
INSERT IGNORE
Query for all locale variables.
Related issues
- quiqqer/qsetup#105 (Setup timeouts)