Re: LIMIT 0,10 retrieves 10 records, but takes forever!

thanx, I am gonna play with it Andy "Andrey Hristov" <ahristov@icygen.com> schrieb im Newsbeitrag news:004301c1d8ca$276af940$0b01a8c0@ANDreY... > Another suggestion - use explicit joins. > SELECT c.*, p.province, co.country > FROM test.cities AS c LEFT JOIN test.countries AS co USING(country_c) > LEFT JOIN test.provinces AS p ON c.province_no=p.province_id > ORDER BY country , province > limit 0, 10; > > This might work. If not read the docs at > http://www.mysql.com/doc/ > about joins and how to do LEFT(RIGHT) JOIN. > > Good luck. > > Andrey > > ----- Original Message ----- > From: "Andy" <news.letters@gmx.de> > To: <php-db@lists.php.net> > 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. True.. the number of results is only that high how high I > > specify it with limit. > > > > But the querry takes as long as without limit. I am trying to avoid to long > > waiting times if a user is > > by exident searching for to many records. > > > > This is my querry: > > > > SELECT c.*, p.province, co.country > > FROM test.cities c, test.provinces p, test.countries co > > WHERE c.city like 'd%' > > AND p.province_no = c.province_id > > AND p.country_c = c.country_c > > AND c.country_c = co.country_c > > ORDER BY country , province > > limit 0, 10 > > > > This takes 30 s on a 2.5 mio entries table > > > > How could I really restrict the results to 10. So that mysql just returns > > after 10 results? > > > > Thanx, Andy > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > >