From: Jan Steinman Date: November 1 2002 5:39pm Subject: Re: Select by row number List-Archive: http://lists.mysql.com/mysql/123800 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >From: > >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): : Bytesmiths -- artists' services: : Buy My Step Van!