Lets say it was a DB of first and last name and every new entry was added to the top and once a day a script would alphabetize the whole thing.
Why do you want to create a new sorted table everyday? You can just create an index on the fields and use ORDER BY to retrieve it in an ordered sequence.
it is more of a what if question. I know that if I had a table of first and last name I would not add new entries to the top. I am just curious to see how long it would take to reorder a DB of about 10000 records.
depends on the cpu, memory available, database software, indexes on the table, ... only way to know it is to try it if you don't want to try it but have a rough idea (if it's seconds or minutes): see how much the difference is between these statements: select * from table select * from table order by lastname, firstname