View Single Post
      09-27-2019, 10:42 AM   #46
Easy Listening
Registered
2
Rep
3
Posts

Drives: 2016 M4 Coupe
Join Date: Apr 2014
Location: Camas, WA

iTrader: (0)

flgfish is on the money. This is almost certainly database-related.

*Log your (slow) queries.
*Make sure your config is on-point.
*Make sure your hardware makes sense for the job (sufficient RAM, using SSDs, etc).
*InnoDB or MyISAM? (You probably want InnoDB for this use case - check your slow queries log.)
*Cache intelligently.
*Horizontal scaling can be tricky with MySQL and "unsophisticated" codebases like the old-school VB 3.x. Consider migrating to "semi-managed" services like Amazon's AWS RDB.

I'd love to help.