I have a MVC project with a form and a submit button.
The values are passed to the controller. One method will fetch data from the dataset according to the parameters passed. Then some VB functions will work with the data retrieved.
Currently I have the whole dataset being filled after the ajax.
My problem is the db is very big and it takes more time to get the results than I wish to.
I tried to fill the dataset at windows.onload puting a specific function just for that in the same controller but that way when the ajax call is made there's no dataset filled.
Is this possible and I just need to do it the right way or it has to fill after the ajax call?