Re: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever!

2002-03-31 Thread Andrey Hristov
- From: Andy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 31, 2002 6:29 PM Subject: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever! Hi there, I am having a problem understanding how limit works. As I thought limit restricts the amount of results to a given number

Re: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever!

2002-03-31 Thread Andrey Hristov
at http://www.mysql.com/doc/ about joins and how to do LEFT(RIGHT) JOIN. Good luck. Andrey - Original Message - From: Andy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 31, 2002 6:29 PM Subject: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever! Hi there, I

Re: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever!

2002-03-31 Thread Andy
Original Message - From: Andy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 31, 2002 6:29 PM Subject: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever! Hi there, I am having a problem understanding how limit works. As I thought limit restricts the amount of