From: David Rush Date: 2007-07-28T22:55:03+09:00 Subject: Re: Usage patterns and trusted libraries On Jul 27, 9:30 am, Pe�a, Botp wrote: > From: David Rush [mailto:kumoy...@gmail.com] > # The process takes over 12 hours to run using ActiveRecord to provide > # my DB access. For 5500 records. > > at 7 sec per record, that is interestingly terrible :) > can you post sample code? Reducing the context to fit in a news article would be difficult. I suspect that the problematic data structure is a denormalized category tree - at 6 levels deep with and average breadth of 7, I suspect there was a lot of reloading going on while AR loaded more data than was needed in this particular application. Mind you, all the loads performed by AR would have been totally useful for the UI - so this is not so much a criticism as an engineering post- mortem. There are very few tools that do many things well :) david rush -- http://cyber-rush.org -- a very messy construction^Wweb site