1. Performance problems with prepared statements (oracle) forum.hibernate.orgHello, we have a performance problem with hibernate / oracle on a large database table (20 million rows) basically the problem is as follows. we have table with a ternery index, say field1, field 2, field3. the problematic statement is "from table where field1 like ? and field2 like ? and field3 like ?". in our gui we are allowing parameters ... |
2. Hibernate PreparedStatement performance forum.hibernate.orgHi everybody. I just recently started using Hibernate and ran into some problems with the performance of prepared statements. I have a set of select and update HSQL queries, which I run about 1000 times. The base tables do not grow during the test, but the time that it takes to execute a set of queries increases from 200ms at the ... |
3. Improving performance of Importer - PreparedStatements forum.hibernate.orgHi all, I'm optimizing an import process. Characteristics are as follows: * First a new schema is created (DROP + CREATE DATABASE) * No multithreading - Only one thread is inserting records * No other processes are accesing the database at time of import * Database: MySQL 5.0 * Only one Hibernate session is used * Connection is provided externally from ... |
4. disable prepared statements for performance on postgresql forum.hibernate.orgI'm having performance issues on postgresql 8.2 and think I've concluded that the problem is that postgresql cannot optimize queries by using constraint exclusion or partial indexes when prepared statements are used via hibernate. Is there any way to disable prepared statements at the session or session factory level? I could not find any answers in the forum or documentation. I ... |
5. Queries vs statements vs prepared statements (performance q) forum.hibernate.orgNewbie Joined: Tue Jan 15, 2008 7:57 am Posts: 2 All, I read fair amount on that topic, but still am not sure what wouls be the best choice for my system. The system is a fairly big web application on Tomcat 5 using Oracle 9 database. The most important thing is it must serve hundreds of requests per minute. Performance ... |
6. MSSQL 2005 Performance Problem because of Prepared Statement forum.hibernate.orgI have a Problem with an old (1.1 patched) version of Hibernate and ran into an boring performance Problem on a Live server of a customer. I have on Use Case where hibernate makes about 5000 select calls to a mssql server, these are executed with sp_prepare and sp_execute the performance is horrible because the mssql server 2005 doesnt understand that ... |