Sami -- It's "Ben", but I'll forgive you <g>.
On 12 Apr 2002, at 9:16, Sami Aaron wrote: > Bernie - It's not "smart" - it's the voice of experience. > > I once ate $1,600 on a client project because there were legitimate > duplicate records in a table and I couldn't figure out why when I did EITHER > select statement, all the records showed up properly, but when I unioned > them the dups were missing. And I was too bull-headed to look up the SELECT > ... UNION syntax ... For a couple of days I just kept trying different > things and adding columns of numbers and so on ... > > Anyway, I'm glad someone could benefit from my mistakes! > Sami > > > ----- Original Message ----- > From: "Ben Petersen" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, April 11, 2002 10:26 AM > Subject: Re: Improving Union Performance > > > > 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/ > > > > > > > > > ================================================ > 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/
