Hi,

my current task is to persist messages into a database table. To make this database more performant our dba wants me to use a new table per day.

I know that hibernate shards allows me to partition my data over mutliple databases but (afaik) i can't change the table name that is used for each shard and it doesn't look like i can add shards at runtime.

Is there a way to do what my dba wants with hibernate? What would be best practice for a requirement like this?

Greetings,
Laures

it's true that in some cases that's a good trick, but many database engines are able to map this kind of sharding "behind the scenes": i.e. you'll always deal with the same table name, but it will be physically stored in different zones according to any custom sharding rule.

With Hibernate you could do that by customizing the Persister (see annotation options @org.hibernate.annotations.Entity(persister=yourImplementationClassName) ), or in case you're never interested in loading older than today data it might be simpler to generate the table name for today dynamically by extending your Dialect.