brigrammer@KuteboiCoder Do you keep the results of queries that will run frequently or are slow in memory close to where they are consumed.
If your non-db server has a UI, have you tried do optimistic fetching on things like link hover and ensuring minimal columns are being served?
GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.
All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.