Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 18 of 18 total |
SQL Guru wanted |
Mon, Aug 10 2009 11:34 AM | Permanent Link |
"John Hay" | Roy
> Actually its about half the speed of my original script at c1.8 secs. Interesting. My test file had 20K records with 10 variations (ie mailboxes) on a really crappy old machine <bg> and was returning a result in < 0.5 secs. >There was one other tiny problem with your query - it produces the wrong results Hmm.... it looks like it should produce the same as your script - I can't see why not. > The conclusion I came to was that there were only a few mailboxes that anyone would care about there being unread emails in ie those where emails were received into (eg the inbox) the rest of them emails are stuffed into after being viewed / handled. You mean you can move mail out of your inbox ? <bg> John |
Mon, Aug 10 2009 2:27 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | John,
<< Interesting. My test file had 20K records with 10 variations (ie mailboxes) on a really crappy old machine <bg> and was returning a result in < 0.5 secs. >> It may depend upon the RequestSensitive setting for the query, and Roy may have been using a different setting. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Aug 11 2009 4:13 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>It may depend upon the RequestSensitive setting for the query, and Roy may >have been using a different setting. Dead right! Set RequestSensitive to true and the time is c0secs Roy Lambert |
Tue, Aug 11 2009 8:53 AM | Permanent Link |
"John Hay" | Roy
> > Dead right! Set RequestSensitive to true and the time is c0secs > I think it is being "economical with the truth" <bg> John |
Tue, Aug 11 2009 1:50 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Dead right! Set RequestSensitive to true and the time is c0secs >> It's one of the improvements for 2.03 - sensitive result sets with derived tables and/or sub-queries in the SELECT list. Such functionality can replace most LOJ operations and still allow you to generate a sensitive result set. The only catch is that any "lookup" or "calculated" SELECT columns are read-only. For example, this query: SELECT CustNo, Customer.Name AS CustName FROM Orders LEFT OUTER JOIN Customer ON Orders.CustNo=Customer.CustNo can be written to generate a sensitive result set as this: SELECT CustNo, (Customer.Name FROM Customer WHERE Customer.CustNo=Orders.CustNo) AS CustName FROM Orders Then, if you or the user changes the CustNo column value in the result set, the CustName column will automatically re-calculate after the row is updated. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Aug 12 2009 1:59 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>SELECT CustNo, >(Customer.Name FROM Customer WHERE Customer.CustNo=Orders.CustNo) AS >CustName >FROM Orders And I like more new syntax to learn, or is the no SELECT in the subquery a typo? Roy Lambert ps part of another 2.03 feature in 2.02 |
Thu, Aug 13 2009 11:14 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< And I like more new syntax to learn, or is the no SELECT in the subquery a typo? >> Sorry, yes it's a typo. << ps part of another 2.03 feature in 2.02 >> Is that a question ? -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Aug 13 2009 11:55 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< ps part of another 2.03 feature in 2.02 >> > >Is that a question ? Only if you want to treat it as one, more just a comment. Roy Lambert |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |