|
Ah, beautiful. That's exactly what is taking the time, the JDBC connections to the 400. It's taking 2 minutes to load all the street names up and properties. I was worried it might do that on our application server, but you've answered my fears. Thanks, Ron Power Programmer Information Services City Of St. John's, NL P.O. Box 908 St. John's, NL A1C 5M2 Tel: 709-576-8132 Email: rpower@xxxxxxxxxx Website: http://www.stjohns.ca/ ___________________________________________________________________________ Success is going from failure to failure without a loss of enthusiasm. - Sir Winston Churchill NGay@xxxxxxxxxxxxx Sent by: java400-l-bounces@xxxxxxxxxxxx 30/03/2005 01:17 PM Please respond to Java Programming on and around the iSeries / AS400 <java400-l@xxxxxxxxxxxx> To Java Programming on and around the iSeries / AS400 <java400-l@xxxxxxxxxxxx> cc Subject Re: Web project sloooow Ron, My experience is that if you have a sufficiently beefy PC (1 GB ram is essential, which I seem to remember you said you did have) then the WSDC test environment is not all that bad. It takes a while to start, but once its up and running its not bad. What totally kills the application is that my PC is then initiating JDBC connections to the iSeries to retrieve data - some screens running 50+ SQL statements to produce the output. When I run these on the proper iSeries web server, the 50+ SQL statements happen in a blink. In WSDC they take absolutely ages due to the network traffic involved. In the end this depends on so many factors, such as how beefy of an iSeries web server you have, how it is configured, how good/bad the connection between your PC and iSeries is, and the types of operations your app is performing, that you probably won't really for certain until you try it... Regards, Nigel Gay, Computer Patent Annuities. |---------+------------------------------> | | RPower@xxxxxxxxxx | | | Sent by: | | | java400-l-bounces@m| | | idrange.com | | | | | | | | | 30/03/2005 12:07 PM| | | Please respond to | | | Java Programming on| | | and around the | | | iSeries / AS400 | | | | |---------+------------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: "Java Programming on and around the iSeries / AS400" <java400-l@xxxxxxxxxxxx> | | cc: | | Subject: Web project sloooow | >--------------------------------------------------------------------------------------------------------------| Out of curiosity, will my java web project run faster on a real server than it does on my pc using WDSc as a test server? If so, by about how much? Ron Power Programmer Information Services City Of St. John's, NL P.O. Box 908 St. John's, NL A1C 5M2 Tel: 709-576-8132 Email: rpower@xxxxxxxxxx Website: http://www.stjohns.ca/ ___________________________________________________________________________ Success is going from failure to failure without a loss of enthusiasm. - Sir Winston Churchill -- This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l. ******************************************************************************** The information in this message is confidential and may be legally privileged. It is intended solely for the addressee; access to this email by anyone else is unauthorised. If you are not the intended recipient: (1) you are kindly requested to return a copy of this message to the sender indicating that you have received it in error, and to destroy the received copy; and (2) any disclosure or distribution of this message, as well as any action taken or omitted to be taken in reliance on its content, is prohibited and may be unlawful. ******************************************************************************** -- This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.