1.Under the condition of same hardware configuration, when should I consider to use EJB, in what number range of the concurrent user?
2.Is there any way to use store procedure in EJB (put all the SQL into SP)? What is the difference of DB performance in using the SP?
-
two headache ejb questions (1 messages)
- Posted by: Web Master
- Posted on: January 01 2003 01:47 EST
Threaded Messages (1)
- two headache ejb questions by Flying Squad on January 14 2003 02:42 EST
-
two headache ejb questions[ Go to top ]
- Posted by: Flying Squad
- Posted on: January 14 2003 02:42 EST
- in response to Web Master
Is there any way to use store procedure in EJB (put all >the SQL into SP)? What is the difference of DB performance >in using the SP?
The DB performance AFAIK increases if we use Stored Procs. But this may lead to problems, if you plan to migrate to some other database.
Stored procs can be invoked by the normal JDBC CallableStatement, from the EJB or from a DAO.