View Issue Details

IDProjectCategoryView StatusLast Update
0007000VCOMPONENT-VKERNELSQL Optimizerpublic2015-01-20 20:51
ReporterRuslan ZasukhinAssigned ToRuslan Zasukhin 
PrioritynormalSeveritymajorReproducibilityhave not tried
Status resolvedResolutionfixed 
Product Version5.7 
Target Version5.7.1Fixed in Version5.7.1 
Summary0007000: Optimize query as: UPDATE tblUSR SET CNT=(SELECT CNT FROM tblCNT WHERE tblCNT.UID=tblUSR.UID)
Descriptionlooks to be slow
TagsNo tags attached.


Ruslan Zasukhin

Ruslan Zasukhin

2015-01-20 20:51

administrator   ~0008036

Now this query users Indexed search in SELECT's WHERE.
Speed up of course is significant. 20-200 times was reported by testers

Issue History

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