0
 Followers
2
 Likes

SLOW SQL in General

Backend
New

To easily analyze slowsql's it would be convenient that,

in case I filter on SLOWSQL (or SLOWEXTENSION) and click on Export

that the export contains 2 extra columns: 

Milliseconds (Integer), containing the value which now is withing the 'message' column

ShortMessage: which contains the queryname. 

e.g.

The message is 

OMLProcessor.ActivationGetServerMode  took 234 ms


Milliseconds column should contain 234

ShortMessage should contain OMLProcessor.ActivationGetServerMode

Created on 31 Jan
Comments (2)

Changed the category to Backend


Yeah, drives me nuts, but the milliseconds is inside the message text, I used to have a SQL script that would parse and filter that out to give me the information I needed, but as you can imagine it was VERY slow, ironically enough. :(


J.Ja

views
153
Followers
0