Currently, I'm using ESET NOD32 antivir. Works wonder, their heuristic engine really is awesome. In terms of resource usage, I can barely even notice any load while running full scan on my PC.

In terms of updating, they concentrate more on updating the pattern for their heuristic engine over virus signatures, thus update files are usually very small.

So far, I'm happy with it after 2 months of using it.