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.
