|
sockmonk@xxxxxxxxx wanted us to know:
>If you want to test whether the server is still answering queries, why
>not use something like "SELECT 1" for the query. You should see the
>following benefits:
>* Independent of the particular database or table structure;
>* Should always return exactly one row;
>* That row should contain one field with the value "1" which you can
>also test for;
>* Requires minimal resources from the database server to execute and
>return the result.
>This seems to meet the stated requirements, although it does not test
I agree that this is the original line of thinking and as such the
select statement achieves the desired results, that something is
answering.
--
Regards... Todd
They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety. --Benjamin Franklin
Linux kernel 2.6.8.1-12mdkenterprise 2 users, load average: 1.04, 1.09, 1.08
|
