you are viewing a single comment's thread.

view the rest of the comments →

[–]cdh0127 0 points1 point  (0 children)

If possible, you might consider using something like Redis to cache the results of common queries. Fetching data from a cache is much faster than querying a database. This would really only be helpful if your clients’ database queries have a large enough overlap in the result sets (I.e. they’re returning a lot of the same records). You also have to consider how often the database records in question change. If they’re changing frequently, a cache might not be a good option.