Bug #41808 Query analyzer uses excessive CPU for some kinds of INSERT statements
Submitted: 31 Dec 2008 15:11
Reporter: Kay Roepke
Status: Verified
Category:Monitoring: Agent Severity:S2 (Serious)
Version:2.0.0.7097 OS:Any
Assigned to: Kay Roepke Target Version:
Tags: performance, quan
Triage: Needs Triage: D2 (Serious) / R4 (High) / E5 (Major)

[31 Dec 2008 15:11] Kay Roepke
Description:
Sending a large number of INSERT statements through Query Analyzer leads to high CPU
usage.

How to repeat:
Send a large number of INSERT statements that contain big VALUES() lists.
The same behavior should occur when doing SELECT with large IN() lists in the where
clause.

Suggested fix:
Optimize query normalization.