Very Slow When Using Desc Clause

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Joel

    Very Slow When Using Desc Clause


    I'm scrolling by Order_# where I find and display on screen the < (lesser
    then) value of Order_#. Here's the syntax:

    "Select * From Orarchd Where `Order_#` < " & lngOrderNumber & " Order By
    `Order_#` Desc".... Order_# is the primary index.

    lngOrderNumber is the current value of Order_#. Here's the problem ...it
    takes forever to find the next record (at least 10 seconds)



Working...