• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What to store

 
ryan sukale
Ranch Hand
Posts: 53
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ranchers.

When you have an application that has a large number of entries posted by a user, like a forum, where do you store all this stuff??
In database field typed as CLOB/BLOB?

I mean that when we have all these forum posts, where do they all go? Putting them into a database using CLOBS/BLOBS would result in lowering in response time for each request.

How does forum like javaranch or any other forum do it? Give me an idea, because i have never dealt with databases before.

Kindly help.

Thanks in advance.
 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The standard approach would be to use a VARCHAR, not a CLOB.

What do you mean by "lowering in response time" - compared to what?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33674
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ryan,
When designing a database, you want to make it possible to look up information. Think about finding a post in this forum. I don't just want to all the posts that you made. I also want to look up threads, do searches, etc. If I had all your posts in one CLOB, they would be extremely difficult to find.

A much more logical approach is to have a posts table so we can lookup each thing individually. This forum uses the database structure provided by jforum.net. (with a few things added on.) I recommend looking at their site if you are curious about the exact schema.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic