Jonathan Rochkind wrote: > Jian Lin wrote: >> I wonder if a Ruby on Rails developer has encounter this before: suppose >> it is a long article (say 100,000 words), and I need to write a Ruby >> file to display page 1, 2, or page 38 of the article, by >> >> display.html.erb?page=38 >> >> but the number of words for each page can change over time (for example, >> right now if it is 500 words per page, but next month, we can change it >> to 300 words per page easily > > Why divide it in the database? Store it one field in the database, and > when you fetch it from the database just perform the logic to find > page=38 and then display that.
is it true that it all the 100,000 words are in one record (one row), then every time, the whole field needs to be retrieved. If we assume one work is about 6 characters long (with the space), then it is 600kbyte per read. I hope to make it "read as needed"... 500 words and about 3kbyte read per page each time. -- Posted via http://www.ruby-forum.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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
