[Solved] make application with database MySQL is faster [closed]

by


For db

  1. Add indexes for frequently searched fields
  2. Think about table partitioning, rarely searched data should be stored in archive tables

For backend

  1. Optimize queries
  2. Minimize cursor fetching

For client

  1. Use pagination to avoid large data loading
  2. Use async loading (SwingWorker for swing, Service for javafx) to avoid UI hanging
  3. Don’t mix archive and working data in one UI form

0

solved make application with database MySQL is faster [closed]