General information
Category:
Coding, syntax & commands
Title:
Foxpro 9 Select very slow
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only