1. How can I learn to make realistic assumptions about database performance? stackoverflow.comI'm primarily a Java developer who works with Hibernate, and in some of my use cases I have queries which perform very slowly compared to what I expect. I've talked ... |
2. Strange performance using JPA, am I missing something? stackoverflow.comWe have a JPA -> Hibernate -> Oracle setup, where we are only able to crank up to 22 transactions per seconds (two reads and one write per transaction). The CPU ... |
3. What is the Best Oracle Driver (THIN) for Oracle 11G stackoverflow.comWe are using Data source based connection pooling in JBoss. We are using JDK 1.6. |
4. Oracle query performance problem stackoverflow.comWe have the following database schema in Oracle 10g Express Edition: Image One of our queries looks like this: |
5. Hibernate-oracle: Performance issue coderanch.comI'm working on a java servlet application that uses hibernate with oracle. This issue concerns with hibernate transaction (between session.beginTransaction() and commit). I'm running a 30 transaction per second load in which all transactions are updating a single column of a specific row of table. Say, column is C, Row is R and table is T. The time taken to run ... |
6. Performance / Oracle hints? forum.hibernate.orgYou can use a direct JDBC query via Session#doWork. Or you can write a subclass of OracleXxxDialect that can handle hints. You'll introduce a very tight dependency on Oracle that way, of course. Another approach would be to inspect the query generated by Hibernate and find out why it's triggering a bad execution plan. Maybe your tables lack an index, or ... |
7. Oracle performance enhancement question? forum.hibernate.orgI was wondering if there's a way to easily extend hibernate 3.0 to make use of the oracle specific optimization technique of beeing able to "defineColumnType" which will prevent Oracle thin driver from making an additonal round-trip to the DBMS to retrieve the meta data for the query result. This can lead to quite a nice performance boost, especially for simple ... |
8. some oracle procedure performance question of hibernate!! forum.hibernate.org |
9. Sql Server 2000 vs Oracle 9i - performance problem forum.hibernate.orgHi everyone, I would like to direct my question especially to people having some experience with Hibernate and Spring frameworks. Short problem description: We have created Spring web application using Hibernate and working with Oracle 9i database (with Spring support for Hibernate mapping). Everything works great, performance is very high ( database read and write operations times are very short ). ... |
10. using oracle index in hibernate for improving performance forum.hibernate.orgHi Friends, I am trying to use the oracle index (index is already created in oracle database) . have added the following line in hbm file for enabling the index but it seems giving no impact on performance , the data is about in multiple tables and each having more then 50 millions of record |
11. Hibernate Oracle Performance forum.hibernate.orgHi, We are facing some performance issues with Oracle10g database using hibernate. oracle.sql.BLOB object is taking more time in persisting the BLOB into the database. When we use the setBytes method rather than creating a BLOB object and directly put the byte[] the performance improves a lot. Is setBytes method an efficient way of handling BLOB data in Oracle10g. How can ... |
