On Fri, Jan 9, 2009 at 10:40 AM, Scott <[email protected]> wrote: > And that would do the trick, but my concern is that the database table > includes a number of columns that contain large amounts of text and > binary data. I am worried about performance if every time I increment > ViewCount I am pulling back the values in these potentially large > columns. Is there a way to tell ActiveRecord to not pull back ALL > columns when I do a Find, or is there some other approach I should be > taking to increment a counter field?
Warning: You might be optimizing prematurely here - have you actually found there is a problem and measured that this is what is causing it? However - if you really need/want to do this - then you can add a method to one of your classes (repositories or entities or whatever) and use a native SQL query. http://castleproject.org/activerecord/documentation/trunk/usersguide/nativesql.html j. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Development List" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-devel?hl=en -~----------~----~----~----~------~----~------~--~---
