On 11 Feb 2002, at 18:27, Jeremy Zawodny wrote: > Nope, not for MyISAM it hasn't changed. With fixed rows, tables can > be checked, repaired, and accessed more quickly. If you know the row > size, you know how to get to row 500,123 quickly. It's just > multiplication. But if the row sizes are all different, you have to > scan the rows before it.
I don't understand. Why would you want to get to row 500,123 in the first place? Wouldn't you normally either be finding the record through an index (in which case you'd have the byte position of the record) or scanning through the table anyway? Under what conditions would you be looking for a row number? Filter fodder: sql,query -- Keith C. Ivey <[EMAIL PROTECTED]> Washington, DC --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
