Re: [Resin-interest] Amber (JPA) Table Indexes

2009-03-31 Thread Daniel López
Isn't that something one would do at the database level? D. Scott Hernandez escribió: Is there a way to hint to Amber that a column should be indexed? For example we will be doing a lot of queries like this: Select u from User where u.isActive == true ... And it would be nice if the

Re: [Resin-interest] Amber (JPA) Table Indexes

2009-03-31 Thread Scott Hernandez
Hibernate lets you add a @Index to entities/tables for this. http://www.hibernate.org/hib_docs/annotations/reference/en/html_single/#d0e2305 Since JPA is creating, and maintaining the schema it is nice to keep that config all in one place. I would say that for serious tuning you may need to do

[Resin-interest] Amber (JPA) Table Indexes

2009-03-30 Thread Scott Hernandez
Is there a way to hint to Amber that a column should be indexed? For example we will be doing a lot of queries like this: Select u from User where u.isActive == true ... And it would be nice if the isActive column is indexed. Thanks in advance, Scott