• Post Reply Bookmark Topic Watch Topic
  • New Topic

Large Databases

 
M. Marple
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear authors,

I read, EJB �s useful when processing large quantities of data?

In what range of data quantities is EJB meaningful?

Is there an upper limit?

Thank you for your attention
 
Mike Keith
author
Ranch Hand
Posts: 304
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not sure about the context that you heard that in, but I'll take a guess...

The query language of JPA (called JPQL) provides support for a feature called bulk updates and deletes. This means that you can perform operations on large quantities of data in a single operation without going into native SQL and without causing the entities to be loaded into memory.

In general, entities may be mapped to large tables with large data sets. When querying, though, each entity (unless it is in a lazily-loaded relationship) is typically loaded into memory to be processed.
 
Jeroen T Wenting
Ranch Hand
Posts: 1847
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Let's see, we have a database server (just one of many) which at the moment has 6GB free diskspace, our monitoring systems are screaming that it's critically short.
We expect that to fill in under a week if the volume of data increases just a little bit (at the moment it's in equilibrium, with expired data being deleted as fast as new data comes in).

EJBs do well handling that.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!