Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    17

    Unanswered: fetching problem

    i Have a query which is taking 1sec for excution from my database and where as the same query takes 9 secs for fetching data in the portal. what might be the problem please explain???

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    You will have to look at all the components involved in your portal. In particular look at network connectivity. If your query is very long and complex this needs to be transmitted from the portal to the database server. The data will also need to be sent back. I had written a small article about this PHP & Mysql – architecture IT Integrated Business Solutions
    If you are satisfied that your network is working fine then look at your application servers ability to process the data and respond to the browser request.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

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