AVG does the job well - but the first time you install it, it will want to download quite a large batch of virus updates.
I'm spoiled by broadband - AVG updates itself daily, and I don't even see it. I think I'd still use it if I were on dial-up, but would probably restrict its updates to off-peak times when I can keep a beady eye on it.