Women in Technology

Showing messages 1 through 2 of 2.

• As a programmer, I like it
  2005-04-19 09:17:43  chromatic | [View]
  
  
  The other session I attended, about performance and tuning, made the point that benchmarking is tricky. Sure, there's less network traffic, which is nice, but there are things to consider like holding read locks for longer (or is it longer?) and the amount of space taken up by the temporary table. (If it grows too large, it needs to write to the disk.)
  
  Still, I look forward to trying it.
• Yeah, it's a nice hack
  2005-04-19 10:07:26  John W. Adams | [View]
  
  
  Typically, when I've had to do this, I was working with the data dictionary, which means just one pull from the database. Then I've used Class::Struct to build a simple tree. That puts the simple processing on the desktop or the app server, not on the database. (Maybe it's just that I've typically worked with systems that were pretty well redlined, but I always want to take work off the RDBMS.)
  

  
  If you're doing something else, the question of multiple pulls becomes more important.
  

  
  I guess that's just a long-winded way of saying I want to try it, too.