Tracking database speed

[Jesse Barnum]

I'd like to display on web pages how long it took the database to generate a page, and I would like to be accurate to the millisecond level. For example, "This search took 1.242 seconds to complete." Is there any way to do this with FileMaker?

[Anatoli]

Not with FileMaker. You can do that with JavaScript.

[Jesse Barnum]

Could you use JavaScript to measure the speed of the page generation on the server (which is what I would like to do), or would it only measure the entire process, including sending the request across the internet, receiving the response, downloading graphics, etc.

[Anatoli]

I think it will be possible to measure the entire process, but without graphics (always bad idea to serve them through FM).

To do it in FM will require some plugin and writing and reading to/from field.

[Keith M. Davie]

"Could you use JavaScript to measure the speed of the page generation on the server (which is what I would like to do)..."

From observing sites which have mentioned transaction times, I note that the timing notice is sometimes displayed on what appears to be a meta redirect page. On such a page there needs be no graphics.

Since I do not have experience in timing events such as your interest, I hope you find this observation useful.

[Jesse Barnum]

Keith, thanks for the suggestion. I actually got this to work quite well using the Web Services Connector servlet for Apache & FileMaker.