El Monday 09 February 2009 08:05:00 Ward W. escribió: > I am using AS 2.2 > I am using MySQL 5 > I am using Passenger via Apache > > I have a table (70,000 entries and plans to double). It includes a > number of 1-to-Many and Many-to-Many associations; some of these that > I want to display on the list view. > > However, as the dataset has grown the list performance has degraded. > The moment the associations are removed from the list view performance > returns to acceptable levels. I would expect performance to remain > relatively constant even as the dataset grows since ultimately any one > list view is shown a constant number of records. > > What confuses me is this: why? > > When showing the list, only N records (in my case, 15) are ever needed > at any one time. Is AS trying to carry around those association over > all those records, even the ones not presently being shown in the > list? If so, what is the argument for this? Or have I misconfigured > something?
You can look at SQL query used in log/development.log You can disable eager loading for some associations: config.columns[:association].includes = [] http://wiki.github.com/activescaffold/active_scaffold/api-column > > > -- Sergio Cambra .:: entreCables S.L. ::. Nicolás Guillén 6, locales 2 y 3. 50.018 Zaragoza T) 902 021 404 F) 976 52 98 07 E) [email protected] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "ActiveScaffold : Ruby on Rails plugin" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/activescaffold?hl=en -~----------~----~----~----~------~----~------~--~---
