how should we cache a database using redis?

lets say i have an api call to the database on first pass then on the second pass its the the cached version​most routes takes 1-2 seconds to responsesome routes takes 5-8at worse is 15-25 seconds​will it be pointless to cache routes the is virtually fast and small less than 500kb? is 5 seconds expiry too short?what if my query takes 15 seconds to execute should the cache be longer than 15 seconds to be optimal?

Submitted July 02, 2020 at 05:01AM by KommSur