<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="http://syndication.webwiz.co.uk/rss_namespace/">
 <channel>
  <title>DevForce Community Forum : RdbQuery.SupressQueryInversion</title>
  <link>http://www.ideablade.com/forum/</link>
  <description>This is an XML content feed of; DevForce Community Forum : DevForce Classic : RdbQuery.SupressQueryInversion</description>
  <pubDate>Sat, 11 Apr 2026 07:07:46 -700</pubDate>
  <lastBuildDate>Thu, 12 Jul 2007 16:36:56 -700</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 9.69</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>www.ideablade.com/forum/RSS_post_feed.asp?TID=227</WebWizForums:feedURL>
  <image>
   <title>DevForce Community Forum</title>
   <url>http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png</url>
   <link>http://www.ideablade.com/forum/</link>
  </image>
  <item>
   <title>RdbQuery.SupressQueryInversion : Query Inversion&amp;#034; will cause...</title>
   <link>http://www.ideablade.com/forum/forum_posts.asp?TID=227&amp;PID=504#504</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://www.ideablade.com/forum/member_profile.asp?PF=21" rel="nofollow">IdeaBlade</a><br /><strong>Subject:</strong> 227<br /><strong>Posted:</strong> 12-Jul-2007 at 4:36pm<br /><br /><P =Ms&#111;normal style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><B style="mso-bidi-font-weight: normal"><I style="mso-bidi-font-style: normal"><FONT size=3><FONT face="Times New Roman">Query Inversion" will cause data from two related tables to be loaded into the cache.&nbsp; Sometimes, this is good (because you immediately want to use both tables and would prefer to use a single query to do this).&nbsp;&nbsp;Sometimes, this is bad (because you really&nbsp;only want data from one table, and don't want to wast time and cache storage loading the related table).&nbsp; If you suppress query inversion, you will get data from only one table.&nbsp;If&nbsp;you set&nbsp;SuppressQueryInversion to false (the default), you will get data from both tables.</FONT></FONT></I></B></P><P =Ms&#111;normal style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><B style="mso-bidi-font-weight: normal"><I style="mso-bidi-font-style: normal"><FONT size=3><FONT face="Times New Roman"><?:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></FONT></I></B>&nbsp;</P><P =Ms&#111;normal style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><B style="mso-bidi-font-weight: normal"><I style="mso-bidi-font-style: normal"><FONT size=3><FONT face="Times New Roman">This is what the Reference Help says:</FONT></FONT></I></B></P><P =Ms&#111;normal style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><B style="mso-bidi-font-weight: normal"><I style="mso-bidi-font-style: normal"><FONT size=3><FONT face="Times New Roman"><o:p></o:p></FONT></FONT></I></B>&nbsp;</P><P =Ms&#111;normal style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><B style="mso-bidi-font-weight: normal"><I style="mso-bidi-font-style: normal"><FONT size=3><FONT face="Times New Roman">By default, "query inversion" is performed when using a query containing subqueries. The inversion ensures that all dependent objects are fetched into cache along with the queried entities, and often improves performance. You may want to suppress this behavior, however, if you have many or complex subqueries whose inversion might cause a performance hit, or when you know that you do not require that the dependent entities be cached. <o:p></o:p></FONT></FONT></I></B></P><P =Ms&#111;normal style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1"><FONT face="Times New Roman" size=3>&nbsp;</FONT></P>]]>
   </description>
   <pubDate>Thu, 12 Jul 2007 16:36:56 -700</pubDate>
   <guid isPermaLink="true">http://www.ideablade.com/forum/forum_posts.asp?TID=227&amp;PID=504#504</guid>
  </item> 
  <item>
   <title>RdbQuery.SupressQueryInversion : On queries,we&amp;#039;ve tried us...</title>
   <link>http://www.ideablade.com/forum/forum_posts.asp?TID=227&amp;PID=503#503</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://www.ideablade.com/forum/member_profile.asp?PF=20" rel="nofollow">Customer</a><br /><strong>Subject:</strong> 227<br /><strong>Posted:</strong> 12-Jul-2007 at 4:36pm<br /><br /><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">On queries,&nbsp;we've tried using&nbsp;RdbQuery.SupressQueryInversion</SPAN>&nbsp;<FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">(both setting to true and false - the manual advisises to set it as false in order to prevent inversion, which must be an error?) but it always seems to fetch data from related tables. Is this a known problem, or are we just doing something wrong?</SPAN></FONT>]]>
   </description>
   <pubDate>Thu, 12 Jul 2007 16:36:26 -700</pubDate>
   <guid isPermaLink="true">http://www.ideablade.com/forum/forum_posts.asp?TID=227&amp;PID=503#503</guid>
  </item> 
 </channel>
</rss>