|Changing Tablename changes on-the-fly? [message #1063235]
||Wed, 12 June 2013 18:53
| Adam Vainder
Registered: June 2013
We have a reporting detail table that, due to performance concerns, we are considering refactoring to produce a new instance of the table for each individual report. The table names would end with "_<report_id>" e.g. details_1, details_2, etc|
This is an Oracle 11g SE with no option to switch to Enterprise, nor to change to a different database with partitioning; the reason for the consideration is that as the table gets large and/or stale rows are deleted, the performance gets terrible.
One thing stopping us is that our Eclipselink entity has the @Table attribute.
Eclipselink access is being made in web services in GF.
We also would have multiple user at once, so any solution would have to be entirely session-based.
I would like to know if, and how, we could change the table name for the entity on-the-fly (at startup is not an option because new reports can happen all the time)?
Thank you for your time.