For some reason this select statement runs very slow.
this has been going on for about 6-9 months but have not had time to deal with it.


There are 200 records in the Foxpro table
Takes about a minute to run

SELECT * from training ORDER by Description INTO CURSOR alltrain
SELECT training
USE
SELECT AllTrain

_SCREEN.Height=gnMaxHeight
_SCREEN.Width=gnMaxWidth

GOTO TOP
REPORT FORM AllTrain.frx PREVIEW
USE


I have a few of these in this small application and the behavior happens in another small app
This is the query from it.

CLOSE TABLES
nYear=0
SELECT 0
USE invoices ORDER reportdate
*REINDEX
Do FORM Years
PUSH MENU _MSYSMENU

_SCREEN.Height=gnMaxHeight
_SCREEN.Width=gnMaxWidth

REPORT FORM income.frx FOR YEAR(invoices.Received)=nYear OR EMPTY(invoices.Received) NOCONSOLE PREVIEW

_SCREEN.Height=gnHeight
_SCREEN.Width=gnWidth


nYear=0
POP MENU _MSYSMENU

SELECT invoices
USE