Web Application Process in Oracle Databases - PowerPoint PPT Presentation

About This Presentation
Title:

Web Application Process in Oracle Databases

Description:

There is a temptation to focus adjusting efforts on the databases only, by looking at parameters, SQL concerns, and PL/SQL program code. However, adjusting solely in the databases only helps with Phase 5 and ignores all of the other areas where performance can degrade. This blog describes how issues can happen at each help the process – PowerPoint PPT presentation

Number of Views:9

less

Transcript and Presenter's Notes

Title: Web Application Process in Oracle Databases


1
Web Application Process in Oracle Databases
There is a temptation to focus adjusting efforts
on the databases only, by looking at parameters,
SQL concerns, and PL/SQL program code.
2
Step 1 Customer Device Efficiency Problems
  • The formulation of a demand in the consumer
    machine is usually the least likely source of
    program performance issues.
  • This is particularly true for underpowered
    client devices with insufficient memory and
    slowly processors.

3
Step 2 Client Machine to Application Server
Transmitting Problems
  • As is true for the consumer machine itself, the
    transmission between the consumer machine and the
    applying server is a less common cause of
    gradually executing web programs
  • For example, uploading huge files (such as
    images) or transmitting a huge block of
    information may slowly down performance.

4
Step 3 Program Server Efficiency Problems
  • The application server itself rarely causes
    important performance deterioration.
  • For computationally intense programs such as
    huge matrix inversions for linear programming
    issues, some performance slowdowns can happen,
    but this is less likely to be an important aspect
    in poorly executing programs.

5
Step 5 Database Efficiency Problems
  • In the databases itself, it is important to look
    for the same things that cause client/server
    programs to run gradually.
  • However, additional web application features can
    cause other performance issues in the databases.

6
Step 4 Program Server to Database Transmitting
Problems
  • Transmission of information from the applying
    server to the databases with 1 Gbps or better
    transmission speeds might lead you to ignore this
    help the process.
  • The trend in current web design is to make
    programs database-agnostic.
  • In the applying server, identifying performance
    issues involves counting the quantity of
    transmissions made.

7
Step 5 Database Efficiency Problems
  • In the databases itself, it is important to look
    for the same things that cause client/server
    programs to run gradually.
  • However, additional web application features can
    cause other performance issues in the databases.

8
  • Thank You
Write a Comment
User Comments (0)
About PowerShow.com