Hello all, I am looking for some advice on best practice. I want to create a tabbed view of the database. To give an idea, it should look something like: http://www.brainjar.com/css/tabs/demo.html Let say I have a table called product with about 3000 different products. I want a tabbed box, like the above, with tabs such as: ''abc'' ''def'' ''ghi''....''xyz'' Each tab will contain products structured by alphabetical order. So if I click on abc, it will return a list of all products that begins with a or b or c. Now my questions: Performance wise, would you go for a SQL call per tab (select * from product where name is like ''a'' or name is like ''b'' or name is like ''c'') OR a general select * and then programatically build up the tabbed box? I was thinking about using Iframe as in the tab demo. so each inline page would be abc.rhtml which would contain a call to a helper which would build the values from a specific sql call (for a b c and not select the entire product table). I beleive it is the easiest. Would you agree? If not from a find_all how would you build the table - I have some ideas but would love some ''best practice'' exemple? Thanks, Carl -- Carl-Gustaf Harroch --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---