View Issue Details

IDProjectCategoryView StatusLast Update
0005409OXID eShop (all versions)4.05. Performancepublic2013-10-21 10:04
Reporterleofonic 
PriorityurgentSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.8.0_5.1.0_beta1 
Target Version4.8.0_5.1.0_RC1Fixed in Version4.8.0_5.1.0_RC1 
Summary0005409: Performance Issues due to unneccesary SEO logging
DescriptionSEO logging is performed multiple times due to widgets, e.g. 13x the same query, because it is executed in init() of every single widget. This query can be very slow on some servers, e.g. Strato:

2 Datens├Ątze betroffen. (Die Abfrage dauerte 0.3196 Sekunden)
REPLACE oxseologs(oxstdurl,oxident,oxshopid,oxlang)
VALUES ('index.php?lang=0&cl=search&searchparam=test', '0aeaf4232802aa7d99490db57107f9a7', 'oxbaseshop', '0')

So 0.31 x 13 makes about 4 seconds only for useless seo logging. In config.inc it says:

     * should requests, coming via stdurl and not redirected to seo url be logged to seologs db table?
     * note: only active if in productive mode, as the eShop in non productive more will always log such urls

Why this? If there is a switch everyone can choose to use it or not to use it, why force it in non-productive mode? Suggestion is:
- turn off repeated calls to SEO logging from widgets
- turn off SEO logging in non-productive mode if blSeoLogging is false in config.inc
TagsPerformance, SEO
ThemeBoth
BrowserAll
PHP Versionany
MySQL Versionany

Activities

There are no notes attached to this issue.