View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000971 | OXID eShop (all versions) | 4.07. Source code, Test | public | 2009-06-04 17:32 | 2012-12-10 13:45 |
| Reporter | marco_steinhaeuser | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | random |
| Status | closed | Resolution | won't fix | ||
| Product Version | 4.1.2 revision 18998 | ||||
| Summary | 0000971: accessing INFORMATION_SCHEMA.tables may cause performance problems in admin area | ||||
| Description | In this thread http://www.oxid-esales.com/forum/showthread.php?t=1302 Light-Beam suffers from massive performance problems in the moment he tries to enter the admin area. Together with his hosting provider he found out that /core/oxsystemrequirements.php (select on ln. 479) grabs information from the information_schema table. The provider says, this is not forbidden but can cause massive performance problems (IMO depending on the system configuration). Don't know if this is a clear bug but worth having a look at. Maybe we could find a smart resolution. If not possible to resolve - it is a documentation bug and shall be mentioned in the system requirements. | ||||
| Tags | No tags attached. | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | 5.2.6 | ||||
| Database Version | 5.0.33 | ||||
|
|
Resolved by the hoster replacing $aRez = oxDb::getDb()->getAll($sSelect); by $aRez = array(); |
|
|
information from information_schema table is used to check, if collations in db tables are correct (one of the requirements for system compatability check). the way marco_steinhaeuser fixed it, simply skips this collation check. |
|
|
It's a MySQL bug. See here. http://bugs.mysql.com/bug.php?id=19588 |
