I am doing load testing on my environment, i am having more than 100k tasks, And defined task vairables. When i try to apply filter to search on task variables i have never get any response, How to improve because when i want to search something specific based on task variable it is not working as expected.
I see always loading screen. Is there any better way to search ?
I just found something interesting. After analysing this above script, i tried to find out why this query is taking longer time and found that some of the columns are not being indexed in mysql. I added index to these and it helps me a lot and drastically improved my task list loading time. Hopefully someone get help with this.