Soldato
i have a form that when submitted, works out a total, saves the input information to a mysql database, emails a copy and then displays the quote to the user.
this can sometimes take a good 10 seconds to do when it's the first time done. if i go back edit the quote and click submit then it can be instant.
i suspect the slow down is coming from mysql, only because it's at this point that the database connection is first opened, and then from then on it's been opened once i guess the second time isn't so slow, but this is just a gut feeling.
any suggestions as to how you'd go about finding out what is slow?
this is written in php/mysql
this can sometimes take a good 10 seconds to do when it's the first time done. if i go back edit the quote and click submit then it can be instant.
i suspect the slow down is coming from mysql, only because it's at this point that the database connection is first opened, and then from then on it's been opened once i guess the second time isn't so slow, but this is just a gut feeling.
any suggestions as to how you'd go about finding out what is slow?
this is written in php/mysql