in reply to
1. Make sure patient_id is indexed.
2. Page the output. If you're using MySQL you can do this with LIMIT.
Priority 1, Priority 2, Priority 3
Priority 1, Priority 0, Priority -1
Urgent, important, favour
Data loss, bug, enhancement
Out of scope, out of budget, out of line
Family, friends, work
Impossible, inconceivable, implemented
Results (28 votes),