32K+
30+
300+
Our submissions table which has more than 700k records was performing horribly. The maximum time to just fetch the data from the table was more than 6 seconds. The query was rather simple. All we had in there were 4 joins, a couple of where clauses (about 4), sorting read more by clicking on the title..
Written on: 15th Jan 2024