Re: [PHP-DB] Re: SQL WHERE datetime NOW

2004-01-06 Thread Richard Davey
Hello John, Tuesday, January 6, 2004, 5:20:22 PM, you wrote: J On further reading, it appears LIMIT stops the query running once x number J of records are retrieved without sorting the whole table first. Where did you read this? If you profile your query you'll notice that in say a 10,000

Re: [PHP-DB] Re: SQL WHERE datetime NOW

2004-01-06 Thread John
Richard Davey [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello John, Tuesday, January 6, 2004, 5:20:22 PM, you wrote: J On further reading, it appears LIMIT stops the query running once x number J of records are retrieved without sorting the whole table first. Where did you