Professional Web Applications Themes

Slow query problem - MySQL

Here is the situation: I have a web server pointing to a database on a different server. When a query is made from the web server to the database server, it takes like 30 seconds to complete. However, when I execute the exact same query from the command line (on the same computer as the web server) it completes instantly.   find that when the query is being executed from the web, it stays in the table for 30 seconds, or so, until it completes. So, it looks like the connection between the web server and the db server is ...

  1. #1

    Default Slow query problem

    Here is the situation: I have a web server pointing to a database on a
    different server. When a query is made from the web server to the
    database server, it takes like 30 seconds to complete. However, when I
    execute the exact same query from the command line (on the same
    computer as the web server) it completes instantly.
     
    find that when the query is being executed from the web, it stays in
    the table for 30 seconds, or so, until it completes. So, it looks like
    the connection between the web server and the db server is not the
    issue; rather, it is something to do with the way it is executed? I'm
    not sure. Does anyone have any ideas about how to fix this problem?

    Thanks in advance.

    GregAgee@gmail.com Guest

  2. #2

    Default Re: Slow query problem

    com wrote: 

    How much data are you retrieving from the remote server?

    Cheers,
    Nicholas Sherlock

    --
    http://www.sherlocksoftware.org
    Nicholas Guest

  3. #3

    Default Re: Slow query problem

    I am an idiot. I never indexed any of the necessary rows. Now
    everything is fantastic. Thanks for replying.

    Nicholas Sherlock wrote:
     

    GregAgee@gmail.com Guest

Similar Threads

  1. Slow Query Help
    By megalith in forum Coldfusion Database Access
    Replies: 7
    Last Post: October 12th, 04:36 PM
  2. Slow Query
    By Stuart in forum Informix
    Replies: 3
    Last Post: December 8th, 02:28 PM
  3. Occasional slow query
    By AK in forum IBM DB2
    Replies: 2
    Last Post: August 19th, 04:20 PM
  4. Inconsistantly slow query
    By Willy in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 17th, 12:49 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139