Re: Getting tables in insertion order

On Tue, 01 Apr 2008 13:44:50 GMT, Roedy Green
<see_website@[EMAIL PROTECTED]
> wrote, quoted or indirectly quoted
someone who said :

>What is "insertion" order?

In SQL, if the order rows are inserted in im****tant, you must add a
field to the record that you increment on each insertion or mark with
a timestamp.  Then of course you use a perfectly ordinary ORDER BY on
the field to retrieve in that order.

The autoincrement functions should be much faster than ones you
implement longhand.  Back in the olden days of Codasyl databases, I
discovered incrementing these counters was what took the majority of
database activity.
-- 

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com