[Dbix-class] How does limit work?

[George Hartzell]

When I'm playing with queries to see if they do what I want, I
frequently just tack a 'limit 10'; onto the end so that I don't have
to wait for the full query to run.

I've seen the reference to SQL::Abstract::Limit and setting the limit
dialect.  I've also skimmed through Class/Storage/DBI.pm but it's not
clear where it comes into play there.

I've tried adding {limit => 10} to the ->search(), but it didn't seem
to just automagically work.

Is there a way to limit the query as I run it?

Thanks,

g.