Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>"all queries on a large project to eager load all of the objects associations" - almost never. At least not without help inside the application.</p> <p>Were I in your shoes, I'd start looking at caching (which you didn't mention, so I have no idea if you are doing any). Fragment caching in particular as it would seem to fit your tab structure well.</p> <p>In one app I used a context sensitive sidebar to display a list of groups of items, each group containing links to related items (n items in any of 18 groups), each item showing the name of the related item in a link form (and a couple of other small data items). </p> <p>Each group in the sidebar was cached, and each related item's entry in its group was cached as well. Controller refactored to accumulate the related items as @relateds, and that code made use of the caches to determine whether the fetch was necessary (on a cache miss). With a little work in intelligent cache expiration, performance was very good.</p> <p>Supposing Project X had 10 related items in each of 12 categories (120 related items). On the first show for Project X, you pay the price. Changing the name of 1 related item in a category would invalidate the cache for that item, that item's group, and the overall sidebar. On the next show for Project X, reconstruction of the sidebar involved 1 cache miss for 1 item (reading that item's record with a join or two), so that item cache got rebuilt, the one category cache rebuilt from the 10 item caches (1 new + 9 existing), cache hits for the other 11 categories (not reading those 110 related items), and yielded a rebuilt sidebar cache at the end.</p> <p>Feels like you could adopt a similar strategy for your tabs, perhaps even finer grained, but that's up to your implementation.</p>
    singulars
    1. This table or related slice is empty.
    1. POWhen is Rails Eager loading by default for all association a good idea?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USrailsdog
    1. USrailsdog
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhen is Rails Eager loading by default for all association a good idea?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThat's a good point of view. I have never look into caching mechanisms before, so i guess i would have to check it out. Do you have some good sources of caching material(tutorials/documentation/etc)?
      singulars
      1. PO
      1. USMurifoX
    2. COIt's been a while since I did he research, but a quick browse yielded this article, which seems to cover the topic fairly well... http://broadcastingadam.com/2011/05/advanced_caching_in_rails/
      singulars
      1. PO
      1. USrailsdog
    3. COThx, i'll check it out.
      singulars
      1. PO
      1. USMurifoX
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload