ok. guys thank you so much for all your help I will do some test and then I will let you know what happens.

Also I have another question:
Is it possible to use and statement in bulk operations that the SQL returns several values?
For example:

SQL: Select Id, Name, State From Games"
How can I  use this SQL that ended in a boost tuple?....I tried it to use it like this example (http://soci.sourceforge.net/doc/statements.html#bulk), but I do not know how to do it Is it possible to it using iterators?

On Thu, Dec 11, 2008 at 1:51 PM, Ricardo Muñoz <rmunoz@warp.es> wrote:
Mario Chacon:
> Thank you so much for your quick answer, but I have a doubt in the
> concurrence, What happens if I have a huge concurrency? Can I lost some Id
> values when I call LAST_INSERT_ID() or the database engine resolve this
> problem?

Frankly i use LAST_INSERT_ID() on a small project only, so i
have not too much experience. Apart from that, mysql doc says: "The ID that
was generated is maintained in the server on a per-connection basis."

http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id

Hope this helps.

>
> Thank you
> Mario...
>
> On Wed, Dec 10, 2008 at 8:41 PM, Ricardo Muñoz <rmunoz@warp.es> wrote:
>
> > Mario Chacon:
> > > Sorry, I forget to put that I'm using Mysql, Is there something with soci
> > > and Mysql to do it?
> >
> > You can use LAST_INSERT_ID(), check out it:
> >
> > http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html
> >
> > > On Wed, Dec 10, 2008 at 5:46 PM, Rainer Bauer <usenet@munnin.com> wrote:
> > >
> > > > Hello Mario,
> > > >
> > > > Wednesday, December 10, 2008, 4:41:02 PM, you wrote:
> > > >
> > > > MC> Is there a method that returns the new Id when I do and insert into
> > in
> > > > a
> > > > MC> auto numeric value?
> > > >
> > > > That depends whether the database server supports that feature. I can
> > > > tell you that you can do it with PostgreSQL using INSERT RETURNING.
> > > > See the last example on the man page here:
> > > > <http://www.postgresql.org/docs/8.3/static/sql-insert.html>
> > > >
> > > > Rainer
> > > >
> > > >
> >
> > >
> > ------------------------------------------------------------------------------
> > > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,
> > Nevada.
> > > The future of the web can't happen without you.  Join us at MIX09 to help
> > > pave the way to the Next Web now. Learn more and register at
> > >
> > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
> > > _______________________________________________
> > > Soci-users mailing list
> > > Soci-users@lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/soci-users
> >
> >
> > --
> > Ricardo Muñoz
> > Warp Networks S.L. http://www.warp.es
> >
> >
> > ------------------------------------------------------------------------------
> > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
> > The future of the web can't happen without you.  Join us at MIX09 to help
> > pave the way to the Next Web now. Learn more and register at
> >
> > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
> > _______________________________________________
> > Soci-users mailing list
> > Soci-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/soci-users
> >

> ------------------------------------------------------------------------------
> SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
> The future of the web can't happen without you.  Join us at MIX09 to help
> pave the way to the Next Web now. Learn more and register at
> http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
> _______________________________________________
> Soci-users mailing list
> Soci-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/soci-users


--
Ricardo Muñoz
Warp Networks S.L. http://www.warp.es

------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you.  Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Soci-users mailing list
Soci-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/soci-users