My company is using a horrible online payment system. I need some feedback from programmers. The site uses oracle's PL/SQL pages. I can view the code using the Mozilla web developers tool bar, as you know i cannot see the actual backend. Here's my concern this site is using at least 10 different javascripts just on the home page. I believe this is what makes the site loadtime very slow. Do I make sense on this. Additionally are there factors with using the oracle PL/SQL system that would cause additional loadtime issues. I have never used Oracle.
I think this will be way over your head. If this is an internal webpage. Then you have a client piece like Siebel or something else attaching on the back end. You may actually even have aplication servers to. So this is not a simple question.
A properly tuned Oracle system should (general statement) be able to handle a significant transaction load and perform well in terms of perceived speed (screen updates, etc.). However, as mentioned by Serversnapper, if this system is being accessed over the web (or even on an Intranet), there are numerous other factors that come into play that could affect performance - webservers, network configuation, your external data pipe, etc. As an example, I support a system for Payroll that is accessed via a secure website with the vendor. When they first rolled it out to the main office for us, the users were complaining about the incredibly slow operation - screens would take forever to update. Also, at the same time, our T-1 was flooding and bringing traffic to a halt for everyone. Finally traced it down to the fact that their Payroll application was opening a new connection everytime a screen changed, but wasn't dropping the previous one. So, in a short period of time, the available connections on the T-1 would be saturated and all traffic would grind to a stop. Sorry for the ramble....my way of saying I would suspect other parts of the puzzle before pointing the finger at only Oracle.
Which also brings into play QOS. So there are many factors to think about. If you have a tons of traffic you may want to implement QoS which will prioritize traffic.
Sorry can't help you. We use Oracle Agile system for our PLM solutions. Now if you have an Agile question, I am an expert. 8)
