18.09.2012, 10:56
40ms is not to much at all! It's less than 1/10th of a second! I suggest you use threaded queries when loading though, it let's the server focuss on other things whilst processing your request with the mysql server.
For benchmarking I suggest you use the snippet written by Slice (or was it an tutorial, just use ****** or search) however that may not be ideal in this case. It'll tell you how much times the function can execute in one milisecond. Keep in mind this is saving, it has to get all variables from the array, parse them in to a string, and execute the query on the mysql server, threading the query and so updating your mysql plugin to R7 will cut some of that time.
For benchmarking I suggest you use the snippet written by Slice (or was it an tutorial, just use ****** or search) however that may not be ideal in this case. It'll tell you how much times the function can execute in one milisecond. Keep in mind this is saving, it has to get all variables from the array, parse them in to a string, and execute the query on the mysql server, threading the query and so updating your mysql plugin to R7 will cut some of that time.