>From: <[EMAIL PROTECTED]> > >I need a 20 GB + DB that I'd like to access by row number or physical order.
Are you certain? In my experience, people who claim they need to access by physical order are making a bunch of faulty assumptions, and REALLY want to access by temporal order, which is not the same thing. There are many things that can make the physical order meaningless, unless you are writing data recovery utilities or similar. >Of course I could use a special rownum column... >mySQL already maintains such >table internaly. I haven't examined the source code, but are you sure? It most likely keeps track of things via offsets, rather than row numbers. -- ---- SQL SQL SQL SQL SQL SQL SQL SQL ---- : Jan Steinman -- nature Transography(TM): <http://www.Bytesmiths.com> : Bytesmiths -- artists' services: <http://www.Bytesmiths.com/Services> : Buy My Step Van! <http://www.Bytesmiths.com/van> --------------------------------------------------------------------- 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
