Hi, My application deployed in JBoss 3.2.6 uses a CMP with fields(similar to): entitynamePK String In DB varchar(255) PK entitytime Timestamp In DB datatime entitystate Integer In DB int entitysize Integer In DB int entitystr String In DB varchar(50)
DB used is MS SQL Server. The field 'entitynamePK' is indexed in the DB. My problem is, In one of my session bean methods..say x(), I use findByPrimaryKey(String entitynamePK) for finding the entity by PK. Now, based on certain business logic, all other fields would be updated. I tried pre-filling the DB with 100 records, and ran a performance test on method x() to know the processing time reqd for this method. For 100 pre-filled records, the processing time was say 't1'. Then I filled the DB with a count of 20,000 records, and ran the same performance test, now the processing time raised to some where near..(10*t1). Later I found that the additional processing time is entirely because of the findByPrimaryKey() - finder. I'am little worried about the multiple by which the processing time is varying between the 100 pre-filled records & the 20,000 pre-filled records. I'am not sure - where to attack the problem:: In DB or in JBoss?? Any pointers regarding the same would be much appreciated. Thanks in advance.. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3884056#3884056 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3884056 ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
