locked
Performance of an Oracle-based application RRS feed

  • Question

  • We have Oracle-based enterprise resource planning (ERP) application that facilitates order entry, invoicing, dispatch, stock management, and purchasing. However, it took as much as 30 seconds to perform queries from the remote offices, which were linked via Frame Relay.

    Any experiences or ideas shared will be greatly appreciated.


    Best,

    Steve


    Thursday, November 22, 2007 6:22 AM

All replies

  • Since our productivity is suffering, I need immediate help.
    Our users are constantly complaining about application performance in the remote offices.

    Steve
    Thursday, November 22, 2007 8:40 AM
  • Coming across the similar issues, we evaluated the cost of upgrading the WAN links; but ruled it out as it is too expensive.

    Patrick
    Friday, November 23, 2007 5:46 AM
  • I would say migrate to SQL Server since you already found the forum for that product ;-)

     

     

    WesleyB

    Visit my SQL Server weblog @ http://dis4ea.blogspot.com

    Tuesday, November 27, 2007 7:57 PM
  • I explored MPLS, and QoS as ways to expedite the application traffic. Unfortunately MPLS was too expensive and QoS did not provide additional capacity.

    Damien
    Friday, November 30, 2007 6:15 AM
  • We analyzed router-based compression. But compression performance did not work well. After researching the market, currently we are considering Juniper, Cisco and Riverbed.

    Patrick
    Wednesday, December 5, 2007 10:36 AM