• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Very large data content

 
Rj Vasanth kumar
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have to store data of size more then 3000 characters. Is it better to store into database fields directly?
or store it as a BLOB OR CLOB data in db fields?

I may update the data frequently.

Is it efficent if i keep those data in xml file and store it in location of web server? so that i read xml file everytime.

Kindly provide solution for this and minimal database communication.

Thanks
Vasanth
 
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If it's really large character data, I'd CLOB it. And if it's being updated regularly, I wouldn't want the overhead of reading, writing, and re-reading XML files.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic