Partial data load on :include

rubyonrails-talk
1

Hello everyone,

I am working on a support tool. I have two models, one called Service and another called Issues. A service may have many issues. I then output tables showing what services have what issues. When creating the tables i only need partial data out of the Service and Issues tables. So in other words for each service i want to preload the issues, but only the data i need to use. Otherwise the include takes over 20 seconds to load. If i could specify which columns to preload, it would only load a tenth of the data. Will the rails framework force me to break up the issues table into two? Does anyone have a solution?

Thanks,

Norbert

2

Two ideas:

1) use find_by_sql and roll your own query that pulls just what you need for the report.

2) create a view in the database that selects a subset of columns from issues, and then define an AR model over that view that you can associate to services.

3

shredluc wrote:

tables. So in other words for each service i want to preload the issues, but only the data i need to use. Otherwise the include takes over 20 seconds to load. If i could specify which columns to preload, it would only load a tenth of the data. Will the rails framework force me to break up the issues table into two? Does anyone have a solution?

There are several solutions at http://dev.rubyonrails.org/ticket/7147

I use http://dev.rubyonrails.org/ticket/7147#comment:12 as a plugin. Warning: experimental, WFM.