or

Hi, I know that this topic was raised here before but I can’t really get anywhere reading previous posts. Could someone point me in the right direction?
I have created a clear page , added radgrid, object data source and radscriptmanager, paging enabled(10) . Objectdatasource is using dataset based on stored procedure retrieving 100k rows. I understand that initial load time can be slow as it’s a lot of data, but I was hoping that switching between pages will be really quick. Looking at profiler when I go form one page to another the same query is executed on sql server, I am not sure why we would query for data we already have. Could someone tell me what I am doing wrong and what should I do to make it quicker ?<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="grdActivity"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="grdActivity" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server"> </telerik:RadAjaxLoadingPanel> <div id="RecentActivityContent" class="QuickViewContent"> <telerik:RadGrid runat="server" ID="grdActivity" DataSourceID="objActivity" Width="360px" GridLines="Horizontal" Skin="Sunset" ShowHeader="false" > <HeaderStyle CssClass="HistoryGridHeader" /> <PagerStyle Mode="NextPrevNumericAndAdvanced"></PagerStyle> <MasterTableView AutoGenerateColumns="false" CssClass="GridRecentActivity"> <GroupByExpressions> <telerik:GridGroupByExpression> <SelectFields> <telerik:GridGroupByField FieldAlias="Date" FieldName="Date" FormatString="{0:D}" HeaderValueSeparator=" from date: " /> </SelectFields> <GroupByFields> <telerik:GridGroupByField FieldName="Date" SortOrder="Descending" > </telerik:GridGroupByField> </GroupByFields> </telerik:GridGroupByExpression> </GroupByExpressions> <Columns> <telerik:GridTemplateColumn DataField="Message" HeaderText="Message" UniqueName="Message"> <ItemTemplate> <asp:Label runat="server" id="Label1" Text='<%# Eval("Type") %>' CssClass="FirstColumn" /> - <asp:Label runat="server" id="lblMessage" Text='<%# Eval("Message") %>' /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> <ClientSettings ReorderColumnsOnClient="True" AllowDragToGroup="True" AllowColumnsReorder="True"> <Selecting AllowRowSelect="True"></Selecting> <Resizing AllowRowResize="True" AllowColumnResize="True" EnableRealTimeResize="True" ResizeGridOnColumnResize="False"></Resizing> </ClientSettings> </telerik:RadGrid><telerik:RadScriptManager ID="RadScriptManager1" Runat="server"></telerik:RadScriptManager><telerik:RadTabStrip ID="RadTabStrip1" runat="server" SelectedIndex="0" ontabclick="RadTabStrip1_TabClick" Skin="Black"> <Tabs> <telerik:RadTab runat="server" NavigateUrl="~/Default.aspx" Selected="True" Text="Home"> <Tabs> <telerik:RadTab runat="server" NavigateUrl="~/Careers.aspx" Text="Careers"> </telerik:RadTab> <telerik:RadTab runat="server" NavigateUrl="~/ContactUs.aspx" Text="ContactUs"> </telerik:RadTab> <telerik:RadTab runat="server" NavigateUrl="~/About.aspx" Text="About Us"> </telerik:RadTab> </Tabs> </telerik:RadTab> <telerik:RadTab runat="server" NavigateUrl="~/Service.aspx" Text="Services"> <Tabs> <telerik:RadTab runat="server" NavigateUrl="~/GetAQuote.aspx" Text="Get A Quote"> </telerik:RadTab> </Tabs> </telerik:RadTab> <telerik:RadTab runat="server" NavigateUrl="~/Products.aspx" Text="Products"> <Tabs> <telerik:RadTab runat="server" NavigateUrl="~/pads.aspx" Text="Pads"> </telerik:RadTab> <telerik:RadTab runat="server" NavigateUrl="~/holiday1.aspx" Text="Holiday Cards"> </telerik:RadTab> </Tabs> </telerik:RadTab> <telerik:RadTab runat="server" NavigateUrl="~/Resources.aspx" Text="Resources"> </telerik:RadTab> <telerik:RadTab runat="server" NavigateUrl="~/Uploadafile.aspx" Text="Up Load A File"> </telerik:RadTab> <telerik:RadTab runat="server" BackColor="Transparent" Font-Bold="True" ForeColor="Red" Text="On-line Specials" NavigateUrl="~/Specials.aspx"> </telerik:RadTab> </Tabs></telerik:RadTabStrip><script type="text/javascript"> function pageLoad() { var tabstrip = $find("RadTab"); $telerik.$("a", tabstrip.get_element()).bind("focus", function () { var index = $telerik.$("a", tabstrip.get_element()).index(this); tabstrip.get_tabs().getTab(index).set_selected(true); }); }</script>DataTable dt = new DataTable();dt.Columns.Add("Column1");dt.Columns.Add("Cost");string[] info = new string[2];info[0] = "Row1_cell1";info[1] = "23.00";Session["DataTable"] = dt;RadGrid1.DataSource = dt;RadGrid1.DataBind();<telerik:RadPanelBar style="margin-left:8px;" ID="RadPanelBar1" Runat="server" Skin="Office2007" Width="210px" onitemclick="RadPanelBar1_ItemClick" OnClientItemClicked="onitemclick"> <Items> <telerik:RadPanelItem runat="server" Owner="RadPanelBar1" Text="Speak & Listen.." Expanded="True"> <Items> <telerik:RadPanelItem runat="server" Owner="" Selected="True" Text="Friends News Feed" Value="nfeed"> </telerik:RadPanelItem> <telerik:RadPanelItem runat="server" Owner="" Text="Following Public Profiles" Value="try"> </telerik:RadPanelItem> </Items> </telerik:RadPanelItem></telerik:RadPanelBar>
<telerik:RadMultiPage ID="RadMultiPage1" runat="server" OnPageViewCreated="RadMultiPage1_PageViewCreated">
</telerik:RadMultiPage>protected void RadMultiPage1_PageViewCreated(object sender, RadMultiPageEventArgs e) { } protected void RadPanelBar1_ItemClick(object sender, RadPanelBarEventArgs e) { RadPageView pager = new RadPageView(); pager.ID = e.Item.Value.ToString(); Control userControl = Page.LoadControl("Newsfeed/" + e.Item.Value.ToString() + ".ascx"); userControl.ID = e.Item.Value.ToString() + "usercontrol"; pager.Selected = true; pager.Controls.Add(userControl); RadMultiPage1.Controls.Add(pager); }function onitemclick(sender, args) { var multiPage = $find("<%=RadMultiPage1.ClientID%>"); var item = args.get_item(); var itemt = item.get_value(); if (multiPage.get_pageViews().get_count() > 2) { for (var i = 0; i < multiPage.get_pageViews().get_count(); i++) { if (multiPage.get_pageViews().getPageView(i).get_id() == itemt) { var pageView = multiPage.findPageViewByID(itemit); pageView.set_Selceted(true); pageView.show(); item.set_postBack(false); } } } }