Sisyphus Database Retrieval

It is a special case of The Ramp. This smell occurs when performing repeated queries that need only a subset of the results.

Solution:Use advanced search techniques that only return the needed subset.

Related smells: The Ramp

Reference

Smith, C. U., & Williams, L. G. (2003). More new software performance antipatterns: Even more ways to shoot yourself in the foot. Computer Measurement Group Conference.