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.
Non-existent; I don't have TV
Non-existent; my TV doesn't have/need a remote
Under my control; I watch alone
Under the control of whoever shouts loudest
Under the control of whoever gets it first
One of many, and the TV has a mind of its own
Results (76 votes),