Experiences in "how to manage much data" needed

Does this have negative effects on querries, which search in a bigger time range? E.g. few days, a whole year?