MySql multiple selects batching in .net
- by Amith George
I have a situation in my application. For each x-axis point in my chart, I am plotting 5 y-axis values. To calculate each of these 5 values, I need to make 4 different queries. Ie, for each x-axis point I need to fire 20 sql queries.
Now, I need to plot 40 such points in the my chart. Its resulting in a pathetic performance where it takes close…