View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005409 | OXID eShop (all versions) | 4.05. Performance | public | 2013-09-12 20:56 | 2013-10-21 10:04 |
| Reporter | leofonic | Assigned To | |||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.8.0_5.1.0_beta1 | ||||
| Target Version | 4.8.0_5.1.0_RC1 | Fixed in Version | 4.8.0_5.1.0_RC1 | ||
| Summary | 0005409: Performance Issues due to unneccesary SEO logging | ||||
| Description | SEO 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 | ||||
| Tags | Performance, SEO | ||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
