I am a developer of e-commerce websites modules. The module displays some dynamic data (html) on website pages with ajax call. Ajax call gets html from database. 1 query for each page load. Database query response size is about 10kb.
My client is worried that this is too much, they wrote they saw significant increment of DB processing consumption because of that. They say that analysing DB queries they see that query-cache is not caching query answer since it's bigger that 10KB.
Is that really something too big? My guess it that my client see increment of DB processing consumption because of something else.
But let's say that each query would return from database html with size 100kb. Would be that something too much if this would happen on each page load? Is that something significant or just minor impact?
I hope somebody can give some insight about that based on own experiences. I have my own answer about that, but it may be too subjective.
Thank you!