I have following setup, WindowsXP, jboss-4.0.4.CR2, MyEclipse IDE and completed developing small inventory program which has following entity
(some more documents with dependencies)
The entities, session bean(stateless) works perfect. I have about 3000 products (expected to grow in double size in a month or two), 500 Categories, and about 50,000 movement lines.
To add new product: manager.persist(product) takes less than one second (not measure though) buts its update which takes about 30 to 120 seconds. Clearly a bottleneck in the application, here is the code to update Product:
manager.merge(product); manager.find(Product.class, product.getProductNo);
Is there anyone out there who can help me with the problem. The performance specially for updating any entity does not improve even if i slim down the JBoss as per tutorial available on the website.
Help here will be really appreciated.