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.
Compiling them myself
Merijn's HP-UX software
Whatever is shipped with my OS release
None, i use PerlScript
Results (194 votes),