Cummins interview question

How would you address a performance problem stemming from database queries

Interview Answer

Anonymous

26 Sept 2019

I suppose, if the database I was using had something like "sql explain", I'd use that to find out which queries were slow. In general, I'd add indexes, or perhaps denormalize a bit, or maybe use native SQL instead of JPQL for some queries, to limit the rows returned. Also, lazy loading.