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