I have a form with a grid.
The record source of the grid is a table "ITEMS".
"ITEMS" has Indexes:
Status (could be "I","R" and a few others)
Entered_date
Description
The data has a filter on STATUS
AND have the option to order the records on the grid by:
Entered_date
Description
No order
This is my problem:
When the status = "I" (grid filtered on status, "SET FILTER TO status = 'I'") the navigation in the grid is pretty quick regardless of the order, but when I change it to status = "R" and the order is "entered_dt" or "description" the navigation gets slow but when I go to "no order" then it's fast.
There are around 55,000 Records in this table. About 22,000 are status = "I", 8 are status = "R" and the rest are made up of other statuses. This slow response only happens when status is "R" and has order "entered_dt" or order "description".
Maybe somebody has any wild ideas about why this could be happening.
Thanks!
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