Thanks maren for your suggestion
Rails will deal with multiple databases. But why do you need a separate
DB for your archives? That seems pointless.
I need to reduce the huge load in the same db and i want the archives in
a seperate DB so that i can take regular backups seperately the live
content and archived content.
You should just be able to
put the archive table in the same DB. That's if you even *need* an
archive table -- you may not.
I have a controller logs, a models student_logs and methods like list
and archive.
When i call list page, the page should fetch lists of logs from
student_logs table, i have option to select all those logs now i need to
move these selected logs into another database. I have used the method
archive to do this under logs controller.
I have used active_delegate plugin, but my list page itself fetches
record from the archive database and not from original database. I need
to list logs from original database and need to move the selected logs
to archive database.
In model i have used ,
delegates_connection_to :archive_log, :on => [:archive]
and in database.yml file i have,
development:
adapter: mysql
host: localhost
database: people_development
archive_log:
adapter: mysql
host: localhost
database: archive_development
So the using the above i was not able to the same, Could anyone please
suggest on the above scenario. Is it possible to do using
active_delegate or is there any other plugin which satisfies my
requirement.
Thanks in advance
Regards,
Jose martin
