View Issue Details

IDProjectCategoryView StatusLast Update
0004543OXID eShop (all versions)4.05. Performancepublic2012-12-10 13:29
Reportertomas_liubinas 
PriorityhighSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version 
Target VersionFixed in Version4.5.12 revision 52682 
Summary0004543: oxUser::exists() sql does not use indexes
DescriptionIn oxUser::exists() SQL does not uses indexes.

SELECT oxid FROM oxuser WHERE ( oxusername = '[email protected]' or oxid = 'oxuserid' ) AND oxshopid = "1";


One of the suggestions would be replacing OR logics with union.
TagsPerformance
ThemeBoth
BrowserAll
PHP Versionany
MySQL Versionany

Activities

There are no notes attached to this issue.