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.
|