can sorting be avoided

2001-02-26 Thread TEXLID_SUPPORT
Hello, I have a table which keeps a list of of clients. When a new client is to be added to the list I want it to be added to the first row of the table so that I will have a list of clients with the most recent arrival at the top and the least recent at the bottom of the table. I know I can

Re: can sorting be avoided

2001-02-26 Thread Peter Skipworth
Edd, mySQL, like any other RDBMS, does (and can not) not insert data in a guaranteed order into a table. While mySQL might usually insert the most recent record "last" in a table, you should never rely upon the fact. Refusing to sort your data on the basis of system load sounds a little strange