Looks like a bug in the "|" operator method -- I think I have a fix.
Anthony On Tuesday, October 22, 2013 1:20:15 PM UTC-4, Richard wrote: > > Ok, actually, it the "|" that lead to the "problem". > > len(rows1) > >>> 1 > len(rows2) > >>> 3 > > rows3 = rows1&rows2 > > len(row3) > >>> 4 > > len(rows1) > >>> 1 > len(rows2) > >>> 3 > > But > > rows4 = rows1|rows2 > > len(rows4) > >>> 4 (in my use case) > > len(rows1) > >>> 4 > > len(rows2) > >>> 3 > > Richard > > > > > On Tue, Oct 22, 2013 at 1:01 PM, Richard Vézina > <ml.richa...@gmail.com<javascript:> > > wrote: > >> Hello Anthony, >> >> Not sure if it is an issue or web2py (or python) is intent to work like >> so... But let's say I have 2 rows sets : >> >> rows1 = query1 >> rows2 = query2 >> >> rows_combined = rows1 & rows2 >> >> rows_combined and rows1 seems to be equal, I mean rows1 seems to be >> containing rows2, so I can't do rows1 & rows3 and not having rows2 since >> they are already in rows1 case the preceding rows1 & rows2... >> >> Thanks >> >> Richard >> >> >> On Tue, Oct 22, 2013 at 12:21 PM, Richard Vézina >> <ml.richa...@gmail.com<javascript:> >> > wrote: >> >>> Yes sir!! >>> >>> I didn't think about it, I don't need to matter with duplicate, since >>> each component of the union are mutually exclusive... >>> >>> At least it was working with or, but very long... >>> >>> Thanks Anthony!! >>> >>> Richard >>> >>> >>> On Tue, Oct 22, 2013 at 11:45 AM, Anthony <abas...@gmail.com<javascript:> >>> > wrote: >>> >>>> On Tuesday, October 22, 2013 11:28:07 AM UTC-4, Richard wrote: >>>> >>>>> Hello, >>>>> >>>>> I try to do union as explain the book, but it keeps running and >>>>> running... on row1|row2, I hava complexe query though with a lot of join >>>>> and subrequest... >>>>> >>>> >>>> It loops through row2 and checks whether each record already exists in >>>> row1, so if there are a lot of records in either and the records are >>>> complex, I suppose that could take a while. If you just do row1&row2 >>>> instead, that will just combine the two sets of records without removing >>>> duplicates -- so if you don't need to worry about duplicates, that should >>>> be a lot faster. >>>> >>>> Anthony >>>> >>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/web2py (Source code) >>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to web2py+un...@googlegroups.com <javascript:>. >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>> >>> >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
