The most effective way how to store separated data in to database



The situation is like this:



  • We have multiple websites where each of them contains random count of text blocks.

  • We want to store the whole page content (all text blocks) into one column into database. In displaying process of html page we process the content from database and we separate it into text blocks


What is the best way of storing those data? The key point is read and process them as fast as possible. Storing and preprocessing isn't the key point.


In my mind there are some possible ways:



  • Store data as XML

  • Store data separated by a special char

  • Store all texts blocks as one-many relation into database


Any better suggestions?


No comments:

Post a Comment