Using multiple databases

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

dare ruby wrote:

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

I don't see why. Tables are pretty much independent when it comes to
load.

and i want the archives in
a seperate DB so that i can take regular backups seperately the live
content and archived content.

I *think* you can do this with one DB, but I might well be wrong.

Best,