Fearless Fool wrote:
> Colin Law wrote:
>>> Amen. �But since mine is a table containing >700K 18-column records of
>>> unchanging data, I'm not giving up without a fight.
>> 
>> Why is that a reason for having it in a separate db?
>> 
>> Colin
> 
> Um, because I'm lazy?  :)

Too lazy to set up the easier solution?

> 
> One table in the external database contains 'highly decorated time 
> records' with 15 minute granularity.  Many of my other models depend on 
> this table, and my unit tests are greatly simplified since I know the 
> table is always available, precomputed and fully tested.
> 
> Since the test database is always rolled back between each test, 
> consider the alternative: I'd have to recompute a subset of the time 
> records before each test I run, and (a) that slows things down 

No   You shouldnt be using enough records in any one test to slow things 
down

> and (b) 
> it makes my head hurt trying to figure out which ones I'd need to 
> generate in advance of the test.

No.  As I've explained before, just generate the ones you need for each 
test.  Use  factories for this.  Simple.  If your head hurts, then 
you're testing at too large a granularity.  Stop overcomplicating!


> 
> (I can hear Marnen chuckling in the background right about now...)

Not chuckling so much as getting frustrated.

> 
> I am now thinking about keeping keeping it as a table in a separate 
> database, but "broadside loading" it into the _development or _test 
> database as a rake task using straight SQL commands when needed.  

Drop that idea now.

> That 
> might not be so painful.

On the contrary, it will be more painful.  Stop fighting Rails already!

> 
> - ff

Best,

-- 
Marnen Laibow-Koser
http://www.marnen.org
[email protected]

Sent from my iPhone
-- 
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.

Reply via email to