Hi there Pros!
I have a website on which registered users will submit their writings, articles, stories etc .. means lots of text will have to be saved and reterieved.
I talked to someone about this; he recommened using text files for storing articles (pages of text) instead of storing them in database(DB) to keep minimum DB size.
Instead of text files I tried to do that with XML cause its hard to control/search/reterieve text from text files, but i encountered 2 major problems.. (1) I had to convert symbols like <, >, etc (2) how to perform quick search for a specific word in the TEXT.
See http://www.desiwriters.com/preview/12.xml for the format. There will be separate xml file for each user.
Now the problem 1 can be solved easily... but what about when a user wants to search for a specific word or phrase in all articles/writings ?
There will be hundreds or may be thousands of xml files and each xml file will contain many articles/writings.
Can you please guide me what is the most efficient, reliable procedure to adopt ?
If text is stored in database then will the text formating will be saved too ?
you can also reply to me by email on shamisha@ssuet.net
I have a website on which registered users will submit their writings, articles, stories etc .. means lots of text will have to be saved and reterieved.
I talked to someone about this; he recommened using text files for storing articles (pages of text) instead of storing them in database(DB) to keep minimum DB size.
Instead of text files I tried to do that with XML cause its hard to control/search/reterieve text from text files, but i encountered 2 major problems.. (1) I had to convert symbols like <, >, etc (2) how to perform quick search for a specific word in the TEXT.
See http://www.desiwriters.com/preview/12.xml for the format. There will be separate xml file for each user.
Now the problem 1 can be solved easily... but what about when a user wants to search for a specific word or phrase in all articles/writings ?
There will be hundreds or may be thousands of xml files and each xml file will contain many articles/writings.
Can you please guide me what is the most efficient, reliable procedure to adopt ?
If text is stored in database then will the text formating will be saved too ?
you can also reply to me by email on shamisha@ssuet.net
