Professional Web Applications Themes

Max Timeout Error - MySQL

My database has 15,000 records. When doing a select statement (with php.ini timeout set to 30 seconds) I get a timeout error from php. I've set the timeout to 60 seconds and the error has gone away. However I would like to speed up the performance, because I have employees just sitting there waiting for a screen. Is ~40 seconds normal for a select command with 2 AND conditions? $p_sql="SELECT * FROM data_record WHERE data_record.sn='$row_array[2]' AND data_record.pass_fail='F'"; $p_result=mysql_query($p_sql); What could I do to speed this up? Any pointers would be greatly appreciated. thanks...

  1. #1

    Default Max Timeout Error

    My database has 15,000 records.
    When doing a select statement (with php.ini timeout set to 30 seconds)
    I get a timeout error from php.
    I've set the timeout to 60 seconds and the error has gone away.

    However I would like to speed up the performance, because I have
    employees just sitting there waiting for a screen.

    Is ~40 seconds normal for a select command with 2 AND conditions?

    $p_sql="SELECT * FROM data_record WHERE data_record.sn='$row_array[2]'
    AND data_record.pass_fail='F'";

    $p_result=mysql_query($p_sql);


    What could I do to speed this up?
    Any pointers would be greatly appreciated.

    thanks

    rjames.clarke@gmail.com Guest

  2. #2

    Default Re: Max Timeout Error

    Wonderful thing indexes are.
    Solved my own problem.

    rjames.clarke@gmail.com Guest

Similar Threads

  1. timeout expired error
    By lambelly@gmail.com in forum MySQL
    Replies: 2
    Last Post: May 3rd, 01:09 PM
  2. SQL Timeout Error
    By jimnpd in forum Dreamweaver AppDev
    Replies: 0
    Last Post: March 5th, 02:14 AM
  3. ** TIMEOUT ERROR WITH PROXY -- HELP !**
    By Alberto in forum ASP.NET Web Services
    Replies: 2
    Last Post: August 26th, 08:19 AM
  4. Recent Timeout Error
    By Brian Peddle in forum ASP Database
    Replies: 3
    Last Post: July 26th, 08:13 AM

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