Thanks for your reply, Robert! I'm using one table with a single value in it. I read about the 'where' parameter so that I can use a different row for each type - but I don't see the benefit of it.
On May 6, 3:08 pm, Robert Rudduck <[email protected]> wrote: > How do you have your hilo table(s)s setup (i.e. one table with row per type, > or single value)? > > - Robert > > > > > > On Thu, May 6, 2010 at 1:50 PM, nicklang <[email protected]> wrote: > > Hi, > > > I'm using hilo for my id generation - and here is my confusion... > > > I'm updating 3 entities (corresponding to 3 tables). > > > I checked the mysql log and I see 3 select/update queries to the hilo > > table before the real queries - I thought the idea of hilo was that it > > only needs to get the hi once?? > > > I'm using the value of 1000 for maxlo - I'm not sure if this is > > reasonable. The way I understand it is that the client gets the hi > > once say its value is 58 - then it multiplies by the maxlo and > > increments to generate more ids - for example 58001, 58002, 58003... > > > But instead I'm getting 58058, 59059, 60060 - what is up with that?? > > > Any insight is appreciated! > > > -- > > You received this message because you are subscribed to the Google Groups > > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<nhusers%[email protected] > > > > > . > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/nhusers?hl=en. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
