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.richard.vez...@gmail.com> 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 <abasta...@gmail.com> 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+unsubscr...@googlegroups.com. >> 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.
