Hi. I am new to Oracle DB. I want some help from you side. Actually, I want to create an Oracle DB with over 10 million records. The records consist of fields like: Book Title Publisher Year of publication Book edition no. Author(s) Author affiliation(s) Book description As could be seen, the fields will consist of small number of words. However, I want that the field "Book description" should be as long as the user want it to be, may be upto 1000 words or even more. I want to know that is it wise to include the entire collection of words in the database itself (which will ultimately increase the size of the DB)? Or should I store only the keywords in the database and the "Book description" data in a separate file and the file could be retrierved when required. I want the data to be entered in the DB using a PHP form and retrieved by a PHP form.
you should be fine to store the description in the db (in a varchar or long datatype), particularly if you're going to want people to be able to search/display that description.