DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Performance query on based application

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    I have a perfomance query:
    Our application is about to go web based and there are 2 architecture solutions. At the moment the application is executed on Client PCs. They execute a package which sends back the sql to execute, i.e. the package will return 'sqlplus / 'command' (command could be select * from test@aodb).
    1. To go 3 Tier architecture. Put the application on the Web server using db_links to access the database.
    2. Or put the application onto the database server (therefore don't need to use db_links), and just use the web server to serve HTTP requests etc.
    There are 1000 users using this application.

    The 'application'/Web server will be located at the same location as the database server. Both servers are Windows NT.

    Which is the best solution? Has anyone any experience? Has anyone any white papers or Case studies?
    Thanks.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    I would choose the first option.

    -Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    Thanks, but could you explain why this is the best solution. Wouldn't there be a problem with the network traffic between application server and the database server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width