21 reputation
2
bio website
location
age
visits member for 2 years, 3 months
seen Apr 17 '12 at 18:18

Apr
14
comment SELECT with large WHERE IN clause taking long time
Yes. For this application I am doing a backup of data where the data is a subset based on the patients extracted from appointments where the filters are doctor(s) and/or appointment date range.
Apr
14
comment SELECT with large WHERE IN clause taking long time
Thanks. Gave it a try and works. Also added indexes, which helped some. Still takes time but not near as long.