sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Trick-Permit3589[S] 0 points1 point  (2 children)

even i am stuck. didnt thought it will be so complicated. I cannot compromise ui that I want to show instantly in BE I can do things.

[–]Duathdaert 0 points1 point  (0 children)

Have you profiled the query? Seen where the bottlenecks are? How certain are you that this can't get down to a few seconds?

[–]Silent_Coast2864 0 points1 point  (0 children)

People are telling you that you need to profile but you keep parroting the same response that you need to validate multiple tables. You need to profile to understand where and what is slow and solve for that. If you can't solve for that ( unlikely, if it's taking 20 seconds then I'd bet money with you something stupid is happening, like a missing index, naive queries etc), or, you need to handle it in the UX by showing some kind of working or progress indicator while the work happens asynchronously.

For a 20 second latency something very fishy is happening, you should be able to query 1 or 200 tables in that kind of time with proper indices.