Short-Term vs Long-Term Agent Memory: A Deep Dive