query-performance Archives

[Solved] query taking too much time with irritated performance [closed]

January 14, 2023 by Kirat

You don’t indicate any indexes. You will need them to improve performance. OK, I don’t understand the part after the semi-colon, so I’ll ignore that. Your whole query does a count(*) of a sub select, but you are doing a bunch of aggregation in the sub-query (calling SUM) which is work the database doesn’t have … Read more

[Solved] . It’s working fine when I pass 10-15 input but taking more than 5 minutes for 30 input. I need to make it work for 100 inputs

December 21, 2022 by Kirat

. It’s working fine when I pass 10-15 input but taking more than 5 minutes for 30 input. I need to make it work for 100 inputs solved . It’s working fine when I pass 10-15 input but taking more than 5 minutes for 30 input. I need to make it work for 100 inputs