The bottom panel of the NProf-Style visualizer is very slow

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Open a profile
2. Open the NProf-Style visualizer
3. Unfold tree nodes

What is the expected output? What do you see instead?
Most nodes take about 3 seconds to unfold and freeze the whole app during 
that time.

What version of the product are you using? On what operating system?
0.2.0 backend, r168 UI

Please provide any additional information below.
Either optimize the code/query or make it run on a background thread and 
show some UI cue of what's going on.

Original issue reported on code.google.com by tristanl...@gmail.com on 21 Feb 2010 at 1:22

[GoogleCodeExporter]

Note: the slowness seems to be due to SQLite as I have no such problem when 
visualizing 
a v0.1.5 MSSQL profile.

Original comment by tristanl...@gmail.com on 21 Feb 2010 at 1:49

[GoogleCodeExporter]

I'm unable to repro, can you attach your data file?

Original comment by promit....@gmail.com on 21 Feb 2010 at 4:24

[GoogleCodeExporter]

I profiled SlimTune with itself as I was browsing the sqlite profile and the 
problem 
indeed comes from the speed of the SQLite query. I attached both the original 
profile 
which causes problem when visualized and a profile of the nprof visualizer. 
Note that I 
was deliberately unfolding a lot of nodes so the "meta-profile" shows exactly 
where the 
time is spent while doing that.

Original comment by tristanl...@gmail.com on 21 Feb 2010 at 2:00

Attachments:

• [Profile & metaprofile.zip](https://storage.googleapis.com/google-code-attachments/slimtune/issue-26/comment-3/Profile & metaprofile.zip)

[GoogleCodeExporter]

Yeah, I see now. SQLite isn't optimizing that query properly. Maybe I can 
rewrite it
to be more friendly to their query engine.

Original comment by promit....@gmail.com on 21 Feb 2010 at 6:29

• Changed state: Started

[GoogleCodeExporter]

Closed by r173.

Original comment by promit....@gmail.com on 22 Feb 2010 at 2:24

• Changed state: Fixed