Milind Kulkarni wrote: > > We are in the process of developing a set of batch programs. Currently > all the batch programs are developed in Oracle PL / SQL and we > want to migrate them to Java environment. Has anybody worked on > the similar assignment? What are the major issues involved. It > would be great, if somebody can point out some resources for > batch processing.
To restate.... You have a number of processes, written in some combination of stored procedures and perhaps straight SQL, which you are going to entirely re-write in Java and run outside of the database (ie not using "Java stored procedures".) Then I can think of one immediate and very obvious impact. Unless the existing SQL code is extremely inefficient your new code in Java will be significantly slower. It would be hard to imagine it not being at least twice as slow. It wouldn't surprise me if it is 10 times slower. And it could be as much as 100 to 1000 times slower, depending on exactly what you are doing and the amount of data that is involved. =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
