Anonymous scopes hitting database

From what I can understand, I should be able to treat an anonymous
scope as an intermediary object with which to build queries on the
fly.

Following the procedure in Railscast episode 112 (http://
railscasts.com/episodes/112), I try the following (in script/console):

a = Production.scoped({})

Hitting return results in a call to the database and all (hundreds of
thousands) records returned.

Is this the expected behavior?

I was hoping to use this to add various scopes according to the search
parameters requested, but I can't afford to do full table scans on
each step.

What could I be doing wrong?

Thanks for any ideas,

John

From what I can understand, I should be able to treat an anonymous
scope as an intermediary object with which to build queries on the
fly.

Following the procedure in Railscast episode 112 (http://
railscasts.com/episodes/112), I try the following (in script/console):

a = Production.scoped({})

Hitting return results in a call to the database and all (hundreds of
thousands) records returned.

Is this the expected behavior?

I was hoping to use this to add various scopes according to the search
parameters requested, but I can't afford to do full table scans on
each step.

What could I be doing wrong?

The console is fooling you: it's trying to display a, and trying to
display it causes the scope to be loaded.
if you did a - Production.scoped({}); false
(so what the console displays is just false) then you should be ok

Fred

That's very good news. I'm just not up for a dive into the internals
today.

Thanks Frederick!