>I have a SQL Server 6.5 query that is based on a date range. For example, if I put in 03/01/1999 and 03/15/1999 I get results quickly. If I put in 03/01/1999 and 03/31/1999 it takes a very long time. Any ideas?
>
>The code:
>
>SELECT id, first, middle, last, type, expdt, fromdt, thrudt, 9999.99 as dues, 999 as instal, 9999 as months from master where group = 'Member' and delet <> 1 and exprdt >= m.expdt1 and expdt <= expdt2 and id not in (select dueid from dues where period = ?m.period or (duetype = 'LIFE' and thrudt = '12/31/9999')) order by last

Hi Dave, how're things? That's a weird problem. Is it proportional, like if your m.expdt2 is 3/20 is it a little slower, and if it's 5/31, is it extremely slow? Or is there a cutoff date where it all of a sudden slows down? And is it pulling off a lot of records with a longer interval? And could it be a RAM vs. diskspace problem, where the small interval fits in RAM but the larger one doesn't? Couple ideas, anyway, since no one else has come forth, though I'm no SQL-Server expert...