Friday, 24 October 2008
I love it when a plan comes together!
Friday, 24 October 2008 17:28After some fiddling around at work, I think I managed to work around some performance problems we had.
I had suspected that a database view we had was the culprit, but wasn't sure why it would be particularly slow, nor how to improve the speed.
But when I "dissolved" the view into separate tables inside the universe and let BO do the joining, things magically speeded up about 100 times.
Disadvantage: the view did some joining which I now have to do manually in BO -- specifically, in each report (not just once per universe).
But I think that's a fairly small price to pay for a great performance increase each time the report is run.
Now I just hope that this change didn't break anything else important (there's still a view involved, but one with only two tables, and one the tables was already present and I'm not sure how to link the view to the left half of the universe which uses one of those tables).
I had suspected that a database view we had was the culprit, but wasn't sure why it would be particularly slow, nor how to improve the speed.
But when I "dissolved" the view into separate tables inside the universe and let BO do the joining, things magically speeded up about 100 times.
Disadvantage: the view did some joining which I now have to do manually in BO -- specifically, in each report (not just once per universe).
But I think that's a fairly small price to pay for a great performance increase each time the report is run.
Now I just hope that this change didn't break anything else important (there's still a view involved, but one with only two tables, and one the tables was already present and I'm not sure how to link the view to the left half of the universe which uses one of those tables).
All that blackens is not goth
Friday, 24 October 2008 19:05The other day when I went to Domäne, I saw a girl (well, young woman) on a bus who looked... unconventionally beautiful, perhaps. At any rate, I thought she looked beautiful. Also a bit gothy.
I saw her again this evening, and wondered whether she had a LiveJournal or a MySpace; she seemed like the sort of person that form part of such sites' clientele.