View Issue Details

IDProjectCategoryView StatusLast Update
0003381OXID eShop (all versions)4.05. Performancepublic2012-12-10 13:29
Reportertjungcl 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product VersionPast development 
Target VersionFixed in Version4.5.8 revision 42471 
Summary0003381: new seo loadFromCache functionality currently wastes 99% hits
Descriptionin rev 40049 there is a new promising caching mechanism for seo-table requests.

However, the cachekey used for the filecache is the md5 of the viewid although the cachekeys of each entries are the md5s of the exact sql statement. Therefore you store identical sql-statement caches in filecaches that all have their own filename and so cant be shared.

=> istead of using viewid + "seo" as filename, use a common filename (only "seo" for example). The cache will still work correct, because it simply stores sql-statement-results, which do not depend on other factors that may influence the viewid.

that way you get about 99% more cache hits :)
TagsPerformance
ThemeBoth
BrowserAll
PHP Versionany
Database Versionany

Relationships

related to 0003631 resolvedLinas Kukulskis existing seo-cache regularly overwritten with empty data 

Activities

Linas Kukulskis

2012-02-14 16:01

reporter   ~0005734

we discussed this. to cache all links in one file can course some problems of file size, but there point to cache links by type something like that: article links per view; cms (content) links store in one file; category links also in another file.

arvydas_vapsva

2012-02-15 14:03

reporter   ~0005741

so now SEO cache is split and cached by type ('static', 'oxcategory', 'oxvendor', 'oxcontent', 'dynamic', 'oxmanufacturer'), except that 'oxarticle' type data is saved for each view - its not a good idea to cache product info in one file.