RE: [PHP-WIN] Canceling a Query
| From: | Svensson, B.A.T. | Date: | Thu, 17 May 2001 18:49:30 +0000 |
| Subject: | RE: [PHP-WIN] Canceling a Query | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-7691@lists.php.net to get a copy of this message | ||
Well, a query can be long running without having
to return lots of rows!!!
One can easliy construct a query that will run for
hours, and just returning some few rows, even zero
rows.
First things is basically to drop all index on the
database... ;-) And then start to make nested table
scans... evaluation conditions in the were clause
like 'where 1 = 2 ..' etc... :-)
>-----Original Message-----
>From: John Lim
>Sent: Thursday, May 17, 2001 9:00 AM
>To: php-windows@lists.php.net
>Subject: Re: [PHP-WIN] Canceling a Query
>
>
>Hello,
>
>This is a workaround. Can you use T-SQL's: SET ROWCOUNT ?
>
>This limits the number of rows returned by a query.