What is the best way to store permalinks/slugs when you have the parent-child model like Radiant? In radiant each page can have many child pages and each page has slug which is unique in the scope of parent. Now, every time a create request is made. it finds all associated ancestor pages and there children. Eg.: If the request is http://mysite.com/a/b/c/d/e/f , it will find all the pages from a-f(around 12 queries for finding the page and finding its children), which is quite unnecessary if you store "a/b/c/d/e/f" itself in the slug. Actually, I have a pretty big table. Is it efficient to store this complete url and index it and search in table on the basis of this slug rather than querying for all the parent pages/other-entities ?? -- Arpit Jain Senior Undergraduate Student Department of Computer Science & Engineering Indian Institute of Technology, Kharagpur, India. Web: http://www.arpitjain.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---