ASHX page/Web page pulling data from mysql... slow response from time to time.
Posted on 2011-09-26
I have a basic .ashx page with comma separate data display around 5-6000 rows.
User will queries with different parameter from the URL field.
My tool are
IIS, MySQL, subSonic, and some vb code behide to calculate data.
I am encounter unknown issue where i query the URL some time it is fast, some times take 1 -2 min. On the very same data.
I disable cache due to the type of data keep changing.
Where could be the first culprit or setting that needed to be done?