We have a page wherein it loads very slowly (probably because of the complexities of the formulas in the back end), and sometimes the queries return more than 20 rows. the problem is that whenever i input values on the textbox and continue inputting on that one textbox (the page only has 1 inputtable textbox) till you get 15 or more rows with an inputted textbox, only around 7-12 values are saved into the database.
My questions are:
1) How can i make my page work in a way that all of the rows are saved into the database? and
2) If i include variables(ex. sum, etc) on my sql queries instead of making dozens of variables, would it help decrease the server lag time?
We've been dealing with this problem for a week now and sad to say, I'm getting way behind schedule
Thanks for the help
J-Rem