10,000 Recorc Per Second (In EJB 3.0)| JBoss.org Content Archive (Read Only)

1 2 3 Previous Next 37 Replies Latest reply on May 7, 2007 11:26 AM by fhh Go to original post

30. Re: 10,000 Recorc Per Second (In EJB 3.0)

grdzeli_kaci Apr 23, 2007 11:23 AM (in response to grdzeli_kaci)

if i achieve 1000 dummy insert per second i will be happy :)
i recount it 10 times, it is maximum amount for per second.
Actions
31. Re: 10,000 Recorc Per Second (In EJB 3.0)

grdzeli_kaci Apr 24, 2007 1:18 AM (in response to grdzeli_kaci)

can anybody tell me where is which type of statement my program use ??

somewhere i found that it possible to configure cash for preparestatement .....

is anybody knows about it ?
Actions
32. Re: 10,000 Recorc Per Second (In EJB 3.0)

fhh Apr 24, 2007 6:14 AM (in response to grdzeli_kaci)
insert into TUser (id, userid, username, userdesc) values (iii, 'useridproc', 'usernameproc', 'userdesc'||iii);

Did I mention somewhere that you should use bind variables?

Your problem is not a Java problem, you should start looking at how databases work.

Regards

Felix
Actions
33. Re: 10,000 Recorc Per Second (In EJB 3.0)

grigoras_cristinel Apr 24, 2007 7:10 PM (in response to grdzeli_kaci)

Oracle will suport java stored procedures
So you can preserve logic in java and get maxim from database
Actions
34. Re: 10,000 Recorc Per Second (In EJB 3.0)

grdzeli_kaci May 2, 2007 10:09 AM (in response to grdzeli_kaci)

"grig77cristi" wrote:
Oracle will suport java stored procedures
So you can preserve logic in java and get maxim from database

what did you mean ??

is it useful that sql insert i have oracle than java ???
you think that stored procedure which insert data into table is faster that jdbc sql insert ?

ok, maybe you are right, i will try

Regards,
Paata
Actions
35. Re: 10,000 Recorc Per Second (In EJB 3.0)

fhh May 2, 2007 4:34 PM (in response to grdzeli_kaci)

Java within Oracle is faster than JDBC from outside but not much. Fastest is to use pure SQL, second best ist PLSQL, Java is always slower than the other two. YMMV!

Regards

Felix

BTW: No matter whether Java or PLSQL - bind variables are the key to performance.
Actions
36. Re: 10,000 Recorc Per Second (In EJB 3.0)

grdzeli_kaci May 7, 2007 11:24 AM (in response to grdzeli_kaci)

can anybody help me how i can write java stored procedure into ejb 3.0 ?

how i can get connection from EntityManager ?

here is some example above, but there EntityManager has delegate method...
i can't find delegate in my EntityManager class, it doaded from ejb3-persistance.jar file,

Regards,
Paata.
Actions
37. Re: 10,000 Recorc Per Second (In EJB 3.0)

fhh May 7, 2007 11:26 AM (in response to grdzeli_kaci)

If you have the choice use PL/SQL. There is nothing to be gained by using java - unless you are using external java libs.

Regards

Felix

P.S.: And don't forget to use bind variables.
Actions

1 2 3 Previous Next

Go to original post