Skip to main content

Where does the time go? In "link_to"

For a table with 9400 records:

The following code, all Ruby On Rails-ed up, takes 8.15s
<table>
<tr>
<% for column in Journalabbr.content_columns %>
<th align="left"><%= column.human_name %></th>
<% end %>
</tr>

<% for journalabbr in @journalabbrs %>
<tr>
<% for column in Journalabbr.content_columns %>
<td><%=h journalabbr.send(column.name) %></td>
<% end %>
<td><%= link_to 'Show', :action => 'show', :id => journalabbr %></td>
<td><%= link_to 'Edit', :action => 'edit', :id => journalabbr %></td>
<td><%= link_to 'Destroy', { :action => 'destroy', :id => journalabbr }, :confirm => 'Are you sure?' %></td>
</tr>
<% end %>
</table>

By removing content_columns and send_columns and explicitly stating what columns to print, and keeping the same output, the code takes 7.86s.
<table>
<tr>
<th>Full Journal name</th>
<th>Journal name abbr.</th>
</tr>

<% for journalabbr in @journalabbrs %>
<tr>
<td><%=h journalabbr.full_name %></td>
<td><%=h journalabbr.abbr %></td>
<td><%= link_to 'Show', :action => 'show', :id => journalabbr %></td>
<td><%= link_to 'Edit', :action => 'edit', :id => journalabbr %></td>
<td><%= link_to 'Destroy', { :action => 'destroy', :id => journalabbr }, :confirm => 'Are you sure?' %></td>
</tr>
<% end %>
</table>

Removing all erb takes 0.46s.
<table>
<tr>
<th>Full Journal name</th>
<th>Journal name abbr.</th>
</tr>

<% for journalabbr in @journalabbrs %>
<tr>
<td><%=h journalabbr.full_name %></td>
<td><%=h journalabbr.abbr %></td>
</tr>
<% end %>
</table>
Now, removing all link_tos and replacing them with explicit HTML and javascript, with the same functionality as the first code, takes 0.655s! Just as neat and much faster!
<table>
<tr>
<th>Full Journal name</th>
<th>Journal name abbr.</th>
</tr>

<% for journalabbr in @journalabbrs %>
<tr>
<td><%=h journalabbr.full_name %></td>
<td><%=h journalabbr.abbr %></td>
<td><a href='/journalabbr/show/<%= journalabbr.id %>'>Show</a></td>
<td><a href='/journalabbr/edit/<%= journalabbr.id %>'>Edit</a></td>
<td><a href='/journalabbr/destroy/<%= journalabbr.id %>' onclick="return confirm('Are you sure?');">Destroy</a></td>
</tr>
<% end %>
</table>
Cool code HTML escaping and highlighting from palfrader.org

Comments

Post a Comment

Popular posts from this blog

Flowing text in inkscape (Poster making)

You can flow text into arbitrary shapes in inkscape. (From a hint here).

You simply create a text box, type your text into it, create a frame with some drawing tool, select both the text box and the frame (click and shift) and then go to text->flow into frame.

UPDATE:

The omnipresent anonymous asked:
Trying to enter sentence so that text forms the number three...any ideas?
The solution:
Type '3' using the text toolConvert to path using object->pathSize as necessaryRemove fillUngroupType in actual text in new text boxSelect the text and the '3' pathFlow the text

Pandas panel = collection of tables/data frames aligned by index and column

Pandas panel provides a nice way to collect related data frames together while maintaining correspondence between the index and column values:


import pandas as pd, pylab #Full dimensions of a slice of our panel index = ['1','2','3','4'] #major_index columns = ['a','b','c'] #minor_index df = pd.DataFrame(pylab.randn(4,3),columns=columns,index=index) #A full slice of the panel df2 = pd.DataFrame(pylab.randn(3,2),columns=['a','c'],index=['1','3','4']) #A partial slice df3 = pd.DataFrame(pylab.randn(2,2),columns=['a','b'],index=['2','4']) #Another partial slice df4 = pd.DataFrame(pylab.randn(2,2),columns=['d','e'],index=['5','6']) #Partial slice with a new column and index pn = pd.Panel({'A': df}) pn['B'] = df2 pn['C'] = df3 pn['D'] = df4 for key in pn.items: print pn[key] -> output …

Drawing circles using matplotlib

Use the pylab.Circle command

import pylab #Imports matplotlib and a host of other useful modules cir1 = pylab.Circle((0,0), radius=0.75, fc='y') #Creates a patch that looks like a circle (fc= face color) cir2 = pylab.Circle((.5,.5), radius=0.25, alpha =.2, fc='b') #Repeat (alpha=.2 means make it very translucent) ax = pylab.axes(aspect=1) #Creates empty axes (aspect=1 means scale things so that circles look like circles) ax.add_patch(cir1) #Grab the current axes, add the patch to it ax.add_patch(cir2) #Repeat pylab.show()