Its so nice to have a profiler

Ian - not seen you around much (actually everyone seems to be quiet recently - hopefully buying Xmas presents or busily coding) - but wanted to thank you for the Profiler!

I've not had to use it before - but today I added 1000 records to my app and it dragged to a crawl - "Damn it must be that category filtering code I just
added" I thought. But I heard that little voice that said to use a profiler, so I went and got it out - took me a moment to figure out where to start but ended up with:

Profiler profiler: [ myModel recaclulateFilter; expandTree ] inSetNamed: 'Filtering'

And you know what - 95% in #expandTree

I had to laugh - it was classic, not my filtering at all, but just me trying to be helpful to expand the tree in my UI - so I changed it to select the first item (which will expand if necessary) and now its snappy again.

I did get a small walkback though - I think becuase I used the profiling method above, in the UI it wanted to dispaly a name for something and my block of code doesn't come from a method? I had to add a #ifNotNil check.

ProfilerSelectorListPresenter>>selectedMethod
^self selectionOrNil ifNotNil: [:value | value object]


At some point we should put together a zip file with all the best packages and an install script that loads them up to create a "Developer Image". I see such images around for squeak, and while we can't provide an image, a script and zip would amount to the same thing.

Tim


.

Relevant Pages

  • Re: Stored Procedures Data view webparts
    ... I just tried filtering on one of my DVWP's that uses a stored proc ... and diagnose with SQL profiler. ... have these problems with stored procedures and filtering the data. ... When i do attempt to i break the stored proc and just get the generic ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Quantify the impact of SQL profiler in SQL perfromane
    ... If you only trace stored procedures and batches, ... filtering, then impact will be low, maybe a few percent. ... Profiler has %10 negative impact while running on sql server ...
    (microsoft.public.sqlserver.programming)
  • Re: How to detect the sql statement that causes full table scans
    ... If Profiler does not output an index id, does this mean there is a table ... > Then you might want to add on a selection of Execution Plan, ... > Show Plan Statistics and/or Show Plan Text, perhaps with some filtering ... > Kind Regards, Howard ...
    (microsoft.public.sqlserver.server)
  • Re: How to detect the sql statement that causes full table scans
    ... > well, this is of course, what I tried to do, but profiler does not tell me ... > what sql-statement is the reason. ... Then you might want to add on a selection of Execution Plan, Show Plan All, ... filtering too. ...
    (microsoft.public.sqlserver.server)
Loading