They make the _smartest_ people in Kansas! <g> Turns out RBase was eliminating 185,000 duplicates from my select... took nearly a minute... <tomato red face>
So others can benefit; I had left an extra table reference in my select from previous experimenting. Many thanks Sami, Ben Petersen On 11 Apr 2002, at 13:40, Sami Aaron wrote: > Ben, > > Add the word "ALL" in your statement: > > Sel ... + > union ALL ... + > Sel ... > > Without the word "ALL", R:BASE is looking for and eliminating duplicated > records from the query. > > Sami > > ----------------------------------------------------------- > Sami Aaron > Software Management Specialists > 19312 W 63rd Terr > Shawnee KS 66218 > 913-915-1971 > http://www.softwaremgmt.com > ----- Original Message ----- > From: "Ben Petersen" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, April 11, 2002 5:08 AM > Subject: Improving Union Performance > > > > Hi All, > > I have one statement constructed as: > > > > Sel ... + > > union ... + > > Sel ... > > > > It is operating against fairly small tables (sub 1k rows), but is > > painfully slow. Oddly, each select independently is almost > > instantaneous. Is there something I might be doing that causes the > > Union to slow things down? > > > > Thanks, > > > > Ben Petersen > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
