[Ruby] Dumb ActiveRecord question

[Alex Vollmer]

We're using postgres. We had our DBA look at the SQL AR generated and he
found that changing the order of the JOINs made the query perform much
better. Curiously I don't see the difference on my dev Postgres install.
The  production system has a heck of a lot more data than my dev box. I'm no
Postgres expert, but I suspect that data size is influencing the query
optimizer. Clearly this warrants some more investigation.

Eric, thanks for the reference to CachedModel. I'll take a look at that to
see if it can help us.

Thanks for everyone's input.

Cheers,

Alex V.

On 1/5/07, Chris <chris at ochsnet.com> wrote:
>
>
> What database is this?
>
> Chris
>
> ________________________________________


-- 
"I think there are only three things America will be known for 2,000 years
from now when they study this civilization: the Constitution, jazz music,
and baseball."
--Gerald Early