make application with database MySQL is faster

I was creating an application with java and database is mysql and it was running well but when data get large (more than 500 fields) application running slowly , so How Can I make it fast ?

Add Comment
1 Answer(s)

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
Answered on July 16, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.