Hi

This is something you should have a look at

http://docs.jboss.org/hibernate/core/3.3/reference/en/html/performance.html
<http://docs.jboss.org/hibernate/core/3.3/reference/en/html/performance.html>
As an example, in one of our projects we had basic audit fields like creator
user and modifier  user in every table.

Each time a grid was displayed, because of Eager Fetching, user table rows
were fetched along with
the other table rows. We could not go for lazy loading as the creator and
modifier were to be displayed too

Finally what we did was break @ManyToOne relationship of those tables with
user table and directly place
the business key (which in that case was username) into those tables.

e.g

class Transaction {

   .... Fields ...

   @ManyToOne
   private User creator;

   @ManyToOne
   private User modifier;

}

changed to

class Transaction {

   private String creatorName;
   private String modifierName;
}


Hope it helps
regards
Taha


On Wed, Dec 29, 2010 at 4:04 PM, Duruk_Kab <durgesh.ka...@nuware.com> wrote:

>
> Hi All, Thanks alot for your suggestions.
>
> I have implemented GridDataSource so I am retrieving only required data
> from
> the back end to be displayed on the grid. (SetMaxResults + Pagination)
>
> But I do have many things associated with the Grid as Error image, Check
> boxes with JavaScript validation, Formatting for Amount / Date, Editable
> grid, Have more than 50 columns and 50 rows etc.
>
> http://tapestry-users.832.n2.nabble.com/file/n5874184/Detail.bmp
>
> Is it taking 3-4 seconds to load the grid because of all these features? I
> could trace that codebase takes maximum 2 seconds to retrieve the data from
> the back end. Is this issue is related to the Browser?
>
> Taha, Can you give me any reference regarding Lazy Loading and even at
> times
> removing hibernate based table relationships... as you pointed out?
>
> Please help me to conclude on what is taking time as I dont think I have
> any
> issues with the code base.
>
> @ DK
> --
> View this message in context:
> http://tapestry-users.832.n2.nabble.com/Grid-with-Scroll-synchronization-Customization-tp5863225p5874184.html
> Sent from the Tapestry Users mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org
> For additional commands, e-mail: users-h...@tapestry.apache.org
>
>

Reply via email to