table with only one column being updated

tiger2008 · **Joined:** Sat Jun 07, 2008 8:53 am **Posts:** 3

Hi,

I have one table with columns (id, c1, c2, c3, ..), the operations on this table is as follows,

1. inserting rows
2. read - c2.c3,... are included in this table to reduce joining
3. only column c1 will be updated. but this is a very frequent operation.

performance wise for update , is this a good design or should I split it into 2 tables and use join to retrieve c2, c3,...?

since only c1 will be updated, is there any trick or feature to make update faster?

sanne.grinovero · **Posted:** Sat Jun 07, 2008 1:33 pm

yes you can exclude the other fields from generated SQL for updates;
using annotations there is an option "updatable" on @Column

tiger2008 · **Joined:** Sat Jun 07, 2008 8:53 am **Posts:** 3

thanks.

Cameron McKenzie · **Posted:** Sun Jun 08, 2008 10:36 am

Indeed, you may find the column annotation heplful. Here's the various options that are available:

Code:

@Column(
  name="columnName"; 
    boolean unique() default false; 
      boolean nullable() default true; 
        boolean insertable() default true; 
          boolean updatable() default true; 
  String columnDefinition() default ""; 
    String table() default ""; 
       int length() default 255; 
          int precision() default 0; 
            int scale() default 0;
)

tiger2008 · **Joined:** Sat Jun 07, 2008 8:53 am **Posts:** 3

Thanks.

Cameron McKenzie wrote:

Indeed, you may find the column annotation heplful. Here's the various options that are available:

Code:

@Column(
  name="columnName"; 
    boolean unique() default false; 
      boolean nullable() default true; 
        boolean insertable() default true; 
          boolean updatable() default true; 
  String columnDefinition() default ""; 
    String table() default ""; 
       int length() default 255; 
          int precision() default 0; 
            int scale() default 0;
)