Alpha Blue wrote: [...] > I mentioned in paragraph two that I will be setting up a test > environment for it.
OK; I missed that. > But, again, I'm not going to alter my production DB > at this time. The season is just a couple weeks away and it wouldn't > allow for enough time to implement, test, and then complete. Sure it would. This is not a big change from the point of view of your app. > I won't > risk any issues. > >> Why? > > I talked about table corruption previously. Matt simply said well you > can restore from backup. If I had 50,000 subscribers all expecting a > service and a table this large that would basically represent all of the > data provided in the service failed, there will be a critical outage. > Table corruption has a larger chance of occurring on larger tables. Um, what? Table corruption is simply not an issue in any DB environment I have ever worked with. And I'm not sure why you say it has a greater chance of occurring on larger tables. If it's simply that there's more data, well, that's true of many small tables too. Basically, if you can't trust your DB server not to corrupt your tables, then don't use that DB server. It's that simple. > > I like to ensure whatever I provide works 100%. My current situation is > a lot more improved (query times are really good right now) and with > caching, will only get better. > > What I'm doing right now is not wrong, it can just be more efficient > later on (as Matt pointed out). Perhaps. I haven't examined your queries in detail > > At this point in time, we can agree to disagree on this topic. But we shouldn't. That's a sign that more discussion is necessary, and should not simply be ignored. It's lazy, and not in the Larry Wall sense. With what you're doing, I doubt that you can afford that kind of laziness. > > Thanks. Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
