Thank you for the reference to the API -- I had been using the one on the main site, activescaffold.com.
While looking at logs is something I am doing -- it still does not really answer the question of why an out-of-the-box configuration does not scale properly. I appreciate it may be a design decision for a use case other than my own, but it still mystifies me since there are only ever N (number of records viewed in list) of M (total number of records in dataset) records being viewed where N is constant even if M is not. I would expect view performance to be tied to N, not M as appears to be the case. On Feb 9, 2:06 am, "Sergio Cambra .:: entreCables - Symbol Servicios Informáticos S.L. ::." <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
