search

HankG / slimtune

Automatically exported from code.google.com/p/slimtune
MIT License
0 stars 0 forks source link

Function Details Visualizer #40

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Currently the search query used is

SELECT Id, Name 
 FROM Functions F 
 JOIN ( 
         SELECT CallerId, SUM(HitCount) ""HitCount"" 
         FROM Callers 
         WHERE CalleeId = 0 
         GROUP BY CallerId 
 ) C 
 ON F.Id = C.CallerId 
 WHERE Name LIKE '%{0}%' 
 ORDER BY Name 

What is the purpose of joining on Callers table? It seems it just removes 
all functions that never appear as a leaf. Is that intended?

Original issue reported on code.google.com by kavanpro...@gmail.com on 7 Mar 2010 at 2:01

GoogleCodeExporter commented 9 years ago 
I think this might be an adapted version of a different query that was 
eventually
pared down. (Aka "cruft".) There doesn't seem to be any reason to join the 
Callers
table here that I can see.

With any luck, 0.3.x will be ORM based instead of having to deal with SQL all 
the
damned time.

Original comment by promit....@gmail.com on 7 Mar 2010 at 2:22

GoogleCodeExporter commented 9 years ago 
This entire visualizer has now been rewritten on NHibernate.

Original comment by promit....@gmail.com on 16 Jul 2010 at 2:08