Re: Composite key vs Serrogate for SeqId

Posted by cjhowe on
URL: http://ofbiz.116.s1.nabble.com/Composite-key-vs-Serrogate-for-SeqId-tp174109p174111.html

That's somewhat true for the orderId (you'll likely
lose several sequential orderIds when you grab 10 in
sequence but only use 3 before the cache expires).
However, I'm referring to the orderItemSeqId, the line
items of the order.

--- David Welton <[hidden email]> wrote:

> > Does
> > the sequence (01,02,03, etc) hold any meaning that
> > needs to be maintained?
>
> BTW, having sequential numbers like this might not
> be such a hot idea,
> as your competition could use that to get an idea of
> how many orders
> you do in a day/week/month/etc...
>
> --
> David N. Welton
>  - http://www.dedasys.com/davidw/
>
> Linux, Open Source Consulting
>  - http://www.dedasys.com/
>