From: "Walden H. Leverich" <WaldenL@TechSoftInc.com> > When that SP (stored procedure) is called from > the ASP it is really just a call to the xxx program passing it > the parameters. You can do anything you want at that point. I take that to mean that you're using an SQL Call statement to run the stored procedure. That can be good and, not-so-good. You're using the AS/400 to handle database and business logic. That's good. However, the Host Servers that you connect to (in my opinion) were not designed for the dynamics of Web applications. A new host server job is activated for each connection. Then after that, the stored procedure is activated. After the run, the stored procedure is deactivated, and the host server job ends. It consumes significant CPU time. You run into even more difficult scalability issues than you do with CGI. Nathan M. Andelin www.relational-data.com
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.