View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0007000 | VCOMPONENT-VKERNEL | SQL Optimizer | public | 2015-01-20 20:49 | 2015-01-20 20:51 |
Reporter | Ruslan Zasukhin | Assigned To | Ruslan Zasukhin | ||
Priority | normal | Severity | major | Reproducibility | have not tried |
Status | resolved | Resolution | fixed | ||
Product Version | 5.7 | ||||
Target Version | 5.7.1 | Fixed in Version | 5.7.1 | ||
Summary | 0007000: Optimize query as: UPDATE tblUSR SET CNT=(SELECT CNT FROM tblCNT WHERE tblCNT.UID=tblUSR.UID) | ||||
Description | looks to be slow | ||||
Tags | No tags attached. | ||||
Now this query users Indexed search in SELECT's WHERE. Speed up of course is significant. 20-200 times was reported by testers |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2015-01-20 20:49 | Ruslan Zasukhin | New Issue | |
2015-01-20 20:49 | Ruslan Zasukhin | Status | new => assigned |
2015-01-20 20:49 | Ruslan Zasukhin | Assigned To | => Ruslan Zasukhin |
2015-01-20 20:51 | Ruslan Zasukhin | Note Added: 0008036 | |
2015-01-20 20:51 | Ruslan Zasukhin | Status | assigned => resolved |
2015-01-20 20:51 | Ruslan Zasukhin | Fixed in Version | => 5.7.1 |
2015-01-20 20:51 | Ruslan Zasukhin | Resolution | open => fixed |