• 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.
 
Forget this weirdo. You guys wanna see something really neat? I just have to take off my shoe .... (hint: it's a tiny ad)
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!