General information
Title:
Matching speed of browse for displaying all records
I give the option of displaying all patient names (approx 1500) in our database as a last resort to users. I tell them that this is the slowest method of searching for a patient. It takes about 3 seconds to display the entire list of names in a list control.
The select is very simple:
SELECT unique_id, patname from demogrph into cursor cAllPats
This query takes about 3 seconds even though I have indexed on the field "patname". Doing a query that returns the complete results from a table seems redundant. How can I display (into a grid or list control) the fields from the table directly and thus decrease the 3 second query time to almost instantaneous?
A BROWSE is quite efficient, can I harness this? It can display the fields I want (ordered too) almost instaneously.
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