You're right, nothing lasts long. I recommend using a spray lube that can be applied about every week. I like WD-40, but most people like PB blaster.

I've tried these and none of them last:

Sil-glyde, Graphite spray, Anti-sieze, Wheel bear... Login to read more.