Win a copy of Java Concurrency Live Lessons this week in the Threads forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Store serialized class in database  RSS feed

 
Michal Glowacki
Ranch Hand
Posts: 114
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello,

I have a service, that is parsing live XML feed and display on my site. Due to problem, I might want to create cluster, I have created one service doing the parsing and then I store it in database as byte array, so clustered client apps simply load it from database, deserialize and display to end user. The problem is: db table with about 7000 rows weights 9GB... Well, it does not look like good solution, is there anything you could advise?

Regards,
Michal
 
K. Tsang
Bartender
Posts: 3633
16
Firefox Browser Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is more of a database storage question than Java.

Depending what DBMS you use, viable options are:
1) partition tables according to some key (eg date range)
2) compress data
3) assign table definition to proper buffer pools (eg if one line of data is 8K put that table in a 8K buffer pool)

 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!