Marnen Laibow-Koser wrote: > Michael Pavling wrote: >> On 26 April 2010 02:08, Mike P. <li...@ruby-forum.com> wrote: >>> So, I'm trying to get the fuel before starting, not when I absolutely >>> need it. >> >> I think it seems to some that what you might be doing is filling the >> back seats of your car with jerry cans full of fuel when all you're >> doing is popping down the road to pick the kids up from school. > > Good analogy. And the weight of those jerricans will probably reduce > your fuel efficiency. > >> >> But you have put your finger on the issue yourself - the "too soon" is >> subjective; if it's not too soon *for you*, then it's perfectly >> okay.... > > No. It's not subjective. If the optimization is speculative, don't do > it! > > As to the issue of waiting till users are affected, you don't have to. > It is possible to keep an eye on performance stats, see a problem coming > before your users notice, and fix the problem. > >> but there's been a few posts here (and I agree with them) >> that what you describe as the application's purpose does not wave a >> flag for something that is in desperate need of DB sharding in the >> development phase... > > Right. And also the fact that DB sharding belongs in the DB and should > not be reinvented in the app layer. (More on this in another post.) > >> but only you can *know* based on your >> requirements and measurements, and hopefully you take the suggestions >> as constructive input rather than as criticism. > > And you *can't* know. The app doesn't exist yet, so you don't know what > your usage patterns will actually be. > > Best, > -- > Marnen Laibow-Koser > http://www.marnen.org > mar...@marnen.org
Thank you all, so very much, for your great, thoughtful posts and solid advice. You all have excellent points. I've decided to take your advice as wise council, and stick with the single-table model. :) Thanks again everybody! Mike -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
