Re: Antwort: Re: Why Heap Tables doesn´t support auto increment ?colums

2001-03-02 Thread Alexander Skwar
So sprach Gerhard Schmidt am Thu, Mar 01, 2001 at 04:02:54PM +0100: > Besides the fakt tha this ID not unique. There ist the Problem that > the ID you proposed ist an String ID and strings als Index are the Well, but he could make a two column primary key, where the first is the timestamp, and

Re: Antwort: Re: Why Heap Tables doesn´t support auto increment ?colums

2001-03-01 Thread Gerhard Schmidt
On Thu, Mar 01, 2001 at 02:37:30PM +0100, Entryon Corp., Chief Technical Officer - P. Hasenfratz wrote: > > > Why not use a timestamp column to guarentee the order in which rows get > > > inserted into the table? You can then order on the timestamp column. > > > > Hmm, timestamp, ie. seconds as f

Re: Antwort: Re: Why Heap Tables doesn´t support auto increment colums

2001-03-01 Thread Entryon Corp., Chief Technical Officer - P. Hasenfratz
> > Why not use a timestamp column to guarentee the order in which rows get > > inserted into the table? You can then order on the timestamp column. > > Hmm, timestamp, ie. seconds as finest resolution, might be to broad depending on > the hits his site will get - imagine that 2+ users access the

Antwort: Re: Why Heap Tables doesn´t support auto increment colums

2001-03-01 Thread alexander . skwar
On 01.03.2001 11:56:59 Richard Ellerbrock wrote: > Why not use a timestamp column to guarentee the order in which rows get > inserted into the table? You can then order on the timestamp column. Hmm, timestamp, ie. seconds as finest resolution, might be to broad depending on the hits his site wi