Re: has_and_belongs_to_many performance

[Benjamín Cárdenas Salamandra]

Hello Magnum, I have the same problem and my solution was replace the column on the relation with virtual columns mainly in the config.list property, you can put to_label of the model relation, Benjamín circa... it seems that even on the simple list (index action) even if i list only 20/40 units per page acivescaffold tries to load or calculate all the related features entities of all the 70000 units, even if not displayed; it remembers the behaviour of a virtual column with some calculations... please someone can help me with this problem ? Check the query being used.  Probably for some reason it's dragging back far more data than it needs.  Consider limiting the columns and relationships referenced so that AS doesn't try and bring back too much data Ed W --~--~---------~--~----~------------~-------~--~----~ 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 activescaffold@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---