I worked with hibernate more than 3 years, still I have some questions regarding performance:
- deletion - is it any way to delete without reading the data. I mean:
Delete * from customers where name='John'
is much faster than selecting data, fetching it, than deleting each record based in ID.
- scrollable cursors
if the result of the select query is expected to be huge so it is unpractical to display the whole data, programmer may decide to fetch the first nnn records to display them in an user interface, than once the user pages or scrolls the control, the required data is fetched on demand. Practically the programmer can access the cursor in a random (as opposed to sequential) fashion. How does Hibernate fit in this approach? Please note this approach is bound to the database server capability, old databases such as Oracle 8 does not support it (at least I tried and didn't succeed few years ago).
- insertion issue
It seems the memory of the process is increasing once we add new entries to the database.
- instanceof does not work if using class inheritance. The classes seems to be always an instance of the base class, even if Hibernate could 'know' what class actually to instantiate, by using a discriminator.
It seems except Update, I have covered with questions all possible CRUD opperations