in reply to Re: Checking return results from an execute
in thread Checking return results from an execute

I thought it was worth mentioning that I have found 'SELECT COUNT(1) FROM TABLE' to be faster on certain databases than 'SELECT COUNT(*) FROM TABLE'.

-----------------------------------
Frank Wiles <frank@wiles.org>
http://frank.wiles.org

  • Comment on Re: Re: Checking return results from an execute