Indexing and migrations

Hi there
Is it necessary to make sure that indexes are rebuilt when the db is
migrated - columns added or removed? If so, can anyone tell me the best
way of automating this?
Chris

Chris C. schrieb:

Is it necessary to make sure that indexes are rebuilt when the db is
migrated - columns added or removed? If so, can anyone tell me the best
way of automating this?

Hey Chris,

http://ferret.davebalmain.com/trac/wiki/FAQ%3AIndexing#WhathappensifIaddnewFieldstotheIndexlateron

so you shouldn’t worry about adding fields later on … no need to
rebuild.

Ben

On 10/5/06, Chris C. [email protected] wrote:

Hi there
Is it necessary to make sure that indexes are rebuilt when the db is
migrated - columns added or removed?

Well, it will only really matter when you put data into those columns.

If so, can anyone tell me the best way of automating this?

There’s a rake task in acts_as_ferret for reindexing entire tables.

-ryan

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs