>If select * from returns the entire table (over 50K records) in 0.00 seconds, can I rule out network problems? I only get the delay when I use a 'where' clause (which I always use, I'm just trying to pinpoint the problem)
select * from <filename> nofilter
would probably be a better way for your intended test.