View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004543 | OXID eShop (all versions) | 4.05. Performance | public | 2012-09-21 14:37 | 2012-12-10 13:29 |
| Reporter | tomas_liubinas | Assigned To | |||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Fixed in Version | 4.5.12 revision 52682 | ||||
| Summary | 0004543: oxUser::exists() sql does not use indexes | ||||
| Description | In 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. | ||||
| Tags | Performance | ||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
