0 Replies Latest reply on Oct 28, 2003 2:12 AM by robotowen

    why use PrepareStatement?

    robotowen

      In findByPrimaryKey mothed, Jboss has used PrepareStatement to excute SQL.Therefore in the database(MS SQLSERVER) which have 2,000,000 rows record it will be made for database server become so slow and CPU is so high.But i change this code to JDBC to visit database use Statement,all things become very well .who can tell me the reason?