search

tuupola / slim-api-skeleton

Slim 3 API skeleton project for Composer
MIT License
312 stars 62 forks source link

Cache #34

Closed swotools closed 6 years ago

swotools commented 6 years ago

Hi @tuupola! Does it make sense to add psr6 handler (ie redis or memcache) to the psr7 already implemented? The ETAG don't reduce connection .. or I'm wrong? I lost my way ... I think I need to reduce db conns and I think I need to add cache handler into api? Otherwise I still use psr6 for single application with misaligned data! How can I continue in the right way?

tuupola commented 6 years ago

I think adding a PSR-6 cache for database causes more problems (cache invalidation etc) than it creates solutions. If database is currently a bottleneck I would look into using ProxySQL as a query cache.