Professional Web Applications Themes

Query is slowest, why it works always with the index - MySQL

I have a query that it orders to me for date, and is fastest. Then in an other query I must order for an other field (char (3)) and is slowest, why it works always with the index of the date why in the WHERE there is the condition for the date. How I can make in order to velocizzare the query? Thanks!...

  1. #1

    Default Query is slowest, why it works always with the index

    I have a query that it orders to me for date, and is fastest. Then in
    an other query I must order for an other field (char (3)) and is
    slowest, why it works always with the index of the date why in the
    WHERE there is the condition for the date. How I can make in order to
    velocizzare the query? Thanks!

    andrea.zac@libero.it Guest

  2. #2

    Default Re: Query is slowest, why it works always with the index

    [email]andrea.zaclibero.it[/email] wrote:
    > I have a query that it orders to me for date, and is fastest. Then in
    > an other query I must order for an other field (char (3)) and is
    > slowest, why it works always with the index of the date why in the
    > WHERE there is the condition for the date. How I can make in order to
    > velocizzare the query? Thanks!
    >
    Andrea,

    Without knowing the table structure, which indexes are available and the
    queries you're using, it would be impossible to provide a meaningful
    answer to your question.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    [email]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

Similar Threads

  1. Query works in fine CF5 but not CFMX
    By rgalla41 in forum Macromedia ColdFusion
    Replies: 0
    Last Post: March 8th, 07:27 PM
  2. Query is not using index when it should
    By Tomas Skäre in forum PostgreSQL / PGSQL
    Replies: 0
    Last Post: December 10th, 11:40 AM
  3. sql-query works alone but not in function...
    By Dennis in forum PHP Development
    Replies: 3
    Last Post: September 27th, 03:35 PM
  4. Newb query: index.htm & index.php & the server default
    By Lab309 in forum PHP Development
    Replies: 7
    Last Post: September 22nd, 02:08 PM
  5. Replies: 1
    Last Post: July 2nd, 09:09 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