﻿<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?)  » SQL View performance question with BO</title><generator>InstantForum 2017-1 Final</generator><description>StrataFrame Forum</description><link>http://forum.strataframe.net/</link><webMaster>StrataFrame Forum</webMaster><lastBuildDate>Wed, 09 Sep 2026 10:25:31 GMT</lastBuildDate><ttl>20</ttl><item><title>SQL View performance question with BO</title><link>http://forum.strataframe.net/FindPost21774.aspx</link><description>I have a SQL VIEW which joins multiple tables. Created a SF BO based on the view. Then a Custom BBS. Then a user control to fire off a Sharpshooter report. There are parameters on the user control and a button the user clicks to then run the report. The click event of the button does a SELECT with a WHERE clause to narrow down the data. My question is to confirm whether the SF Framework is waiting until I issue the SELECT to fill the BO, or does it fill it automatically initially with all the data and then refill it when I issue the SELECT.?&lt;/P&gt;&lt;P&gt;Like in FoxPro you could use a view with NODATA returned until you actual fill the view.</description><pubDate>Mon, 02 Feb 2009 15:22:23 GMT</pubDate><dc:creator>Ross L. Rooker, Sr.</dc:creator></item><item><title>RE: SQL View performance question with BO</title><link>http://forum.strataframe.net/FindPost21777.aspx</link><description>Thanks for your quick response.</description><pubDate>Mon, 02 Feb 2009 15:22:23 GMT</pubDate><dc:creator>Ross L. Rooker, Sr.</dc:creator></item><item><title>RE: SQL View performance question with BO</title><link>http://forum.strataframe.net/FindPost21775.aspx</link><description>BO have no automatic mechanism to fill them (though there are some standard fill methods like FillByPrimaryKey, FillByParent, etc).  This is because the BO is disconnected from the table(s)/view(s)/sproc(s) that actually get the data. There is no way for it to know how you might like to fill it.  So, the only way it would ever get filled is if some code of yours actually fills it.&lt;br&gt;
&lt;br&gt;
Hope that makes sense.</description><pubDate>Mon, 02 Feb 2009 15:02:45 GMT</pubDate><dc:creator>Greg McGuffey</dc:creator></item></channel></rss>