select limit question

[Anon]

Hi!

I think I read somewhere that when I use a statement like:

select * from table limit 10, 20;

MySQL will select the whole table but only return rows 10-20.

I think that takes too long with large tables...

Is there a command where MySQL does NOT have to selet the whole table but only the rows that are needed, thus making the command execute/finish faster?

[brandonschnell]

1) "LIMIT 10, 2O" would return rows 11 - 30.

http://www.mysql.com/doc/S/E/SELECT.html

2) actually a LIMIT can seriously speed up mysql queries on large tables.

http://www.mysql.com/doc/L/I/LIMIT_optimization.html

3) if your queries are still slow, you'll need to index the commonly used columns.

[Anon]

Hey, im trying to learn php...ive tried to set up a some-what forum...
at http://truthugs.com/cyberrap/mementery.html

to join...if you can please view and enter deatils and press submit you will see nothing comes up after submit except Fname:
Lname:
Eaddy:
in those blanks shoudl be the info you typed in......
please if yall can help email me at [e-mail]
or whatever...im currently looking for staff members to help with php i run cyberrap.net

---

Giancarlo
cyberrap.net