• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How do you store these many posts

 
Ranch Hand
Posts: 10198
3
Mac PPC Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I guess the database for javaranch would be huge as we have many many posts across different forums and this multiplied with the number of users at any given point of time.

Moderators any comment on this?
 
Ranch Hand
Posts: 1609
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Its not just having the huge database, it is also transacting... and transacting faster on the same. Kudos to ranch.
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Jothi,
As point out in another thread, JavaRanch uses flat files, not a database.

While I would expect it to be large, keep in mind the data is just text - not attachments. This makes the memory requirements significantly smaller than say an e-mail system.
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm not sure what multiplying the number of posts with the number of users accomplishes (maybe that was just a figure of speech?), but by now we have something like 370.000 discussion threads (and thus a multiple of that in individual posts).

The raw number of posts is not really a problem, as most of them are old and inactive. On any given day there are usually no more than around 400 active topics. Over time, the posts do take up more storage, but with storage costs being what they are these days, that's not something to worry about. What will degrade over time is searching through the archive of posts. Let's hope that the algorithms used by Lucene get better faster than the search is getting slower through an increasing number of posts...
 
author and iconoclast
Posts: 24207
46
Mac OS X Eclipse IDE Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Some technical details on how JavaRanch stores its forum data is offered in this thread.
 
reply
    Bookmark Topic Watch Topic
  • New Topic