Tag Archives: performance

Fake Materialized Views

Posted on November 27, 2006 by Geoff Lane

In a previous post, I discussed materialized views in Oracle. I wanted to share a relatively simple technique that can be used to create similar functionality in Oracle or another database. Why Use Something Else? Materialized Views are a feature … Continue reading →

Posted in Code | Tagged , , | 1 Comment

Oracle Materialized Views

Posted on October 29, 2006 by Geoff Lane

So the existence of Materialized Views might not be news to the Oracle DBAs around the world, but I present topics from the perspective of a software developer. As software developers we often have to use databases with our applications. … Continue reading →

Posted in Code | Tagged , , , | 2 Comments

Hibernate Query Translators

Posted on October 21, 2006 by Geoff Lane

I’ve recently been doing some performance testing and tuning on an application. It makes use of Hibernate for the data access and ORM and Spring to configure and wire together everything. As I was looking at all of the configuration … Continue reading →

Posted in Code, Java | Tagged , , , , | Leave a comment

Hibernate HQL And Performance

Posted on August 23, 2006 by Geoff Lane

The Hibernate ORM tool give you the ability to write SQL-esque queries using HQL to do custom joining, filtering, etc. to pull Objects from your database. The documentation gives you a lot of examples of the things you can do, … Continue reading →

Posted in Code, Java | Tagged , , , , | 14 Comments