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: [EMAIL PROTECTED]
>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.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
