Rails Progress

All my models are implemented in Rails and I wanted to give a quick update on how things are going.
  • For now, I'm been using the rails views and controllers to test my code (automated tests coming soon). This has worked out great for me. Since my application only allows users to view and filter database records, I don't have a lot of validation checks, but I wanted to get a feel for the performance of pages need to display a lot of data from various tables. One page I tested performs 35 queries (including all the counts and show field commands) and takes about 5 seconds using the Webrick server (from NetBeans so I believe JRuby is being used). The development log lists the time spent in the database as less than 1 second. I'm sure performance could be better, but this is a big improvement over what we had before and the database I'm using contains more records.
  • I'm still noticing that when you ":include" more than one model in a "find" command, more than 1 query is performed. The authors don't mention this in Agile Web Development with Rails so I'm wondering if I have something wrong or if this is a performance enhancement??? Here is a snippet...
         @mp_events = Model.find :all,
        :include => [{:model_data1 => 
                    [:nested_data1, :nested_data2]}, 
                    :model_data2],
        :conditions => query
    Something cool about this statement, "nested_data1" and "nested_data2" eager load data connected to Model through "model_data1". This works great! I found the information about nested includes here. This author claims a single query as well. I'm wondering if my extra "conditions" clause triggers Ruby to produce the extra query.
  • One bummer about ":include" is that it does not seem to work with the nested ":select" option. I wanted to total a few of the columns where data was grouped and couldn't get it to work. I resorted to "find_by_sql".

We're now talking about exposing access to these models through a web service. I also need to test more queries with more complex criteria. I'll continue to post interesting tidbits as I encounter them.

Comments

Post a Comment

Popular posts from this blog

I Believe...

A recent reorg at my company left me with a new manager - and a different approach to software development than my team had been previously following.  Our new approach is one that I don’t necessarily agree with, but it led me to think about - and reevaluate -  those tenets of software development that I think are important and that I believe lead to increased quality and productivity. This post will consist of fairly high level discussions about how to organize code, teams, and projects - but contain very little actual code. Many of these ideas will not be my own.  They are mostly ideas I’ve learned from others and their willingness to share their experiences with me.  They are, however, ideas that I’ve practiced and hardened as I’ve worked to build my own ideal environment for delivering value through software . Many of these ideas I now take for granted as commonplace (even though they aren’t).  I felt a need to document them anyway - so people can unde...
Read more

More stuff to get excited about

Chrome OS I'm excited about Google's announcement to release what sounds like an ultra lightweight OS to basically surf the Internet. I'm hoping this device will allow me (and others) to breathe new life into old, underpowered laptops, allowing them to essentially work as netbooks. This could also open up new and inexpensive opportunities for schools to recycle or prolong the life of expensive computing equipment and expand horizons of their students. I've been watching the One Laptop per Child (OLPC) movement for some time and I see this as another avenue toward their goal. I don't share the optimism that this OS will somehow replace Windows. Sometimes you need extra horsepower and functionality. I edit a lot of photos and create some simple video, but the web tools I've tried to do either task can't hold a candle to the four-year-old version of Photoshop Elements I own. I'm not sure CPU intensive apps like this will port very well to the web....
Read more

A few quick notes

It's been a quiet few months. I haven't worked on too many things I've felt like writing about. That's not to say I haven't been busy. One thing I've been reading more about building great teams and delivering more to our customers. I'm just starting to read Creating Magic: 10 Common Sense Leadership Strategies from a Life at Disney . Obvious from the title, this book outlines the approach Disney teaches all of it's Cast Members (employees) on how to be great leaders and provide their visitors with great experiences. I've been wanting to read this for some time and I'll be sure to write more as I work my way through it. Some related blog posts I've enjoyed recently are: The Duct Tape Programmer from Joel on Software where he reviews a chapter of the book Coders at Work . The post basically talks about doing the simplest thing possible to get something out the door and into people's hands. Amen to that! I've also been enjoyi...
Read more