November 8, 2013 at 1:01 am
Hi Experts,
I have created CLR functions to retrive data from sharepoint 2010 lists by sharepoint web service..
If i call this function in a queryafter sometime (around 12 hours or some hours) then it takes 1 minutes to fetch 250 data records .. but if i run again the same query then this takes 2 second only.....
so may i know what is the problem about the same.. actually i have to use Stored procedures on this to create SSRS report.. if it will take long time then it will be fail for me...
Is it the best practive to fetch data in one time 1 millian from a big sharepoint list that has abound 50 million by CLR function ??
so please suggest me..
my query is below..
SELECT * FROM dbo.fn_GetListItemsEmployees('http://wks10953:1000/_vti_bin/Lists.asmx','Employees')
November 8, 2013 at 2:07 am
If i call this function in a queryafter sometime (around 12 hours or some hours) then it takes 1 minutes to fetch 250 data records .. but if i run again the same query then this takes 2 second only.....
It's the cached pages in the memory. The first time you run your function it calls for pages from the disk. Then when you run it immediately after, the pages are already there and it takes a little time.
so may i know what is the problem about the same.. actually i have to use Stored procedures on this to create SSRS report.. if it will take long time then it will be fail for me...
You can decrease the 1 minute time if the queries in your function are covered with indexes. Check that stuff.
Is it the best practive to fetch data in one time 1 millian from a big sharepoint list that has abound 50 million by CLR function ??
Always make a try
http://technet.microsoft.com/en-us/library/ms131103.aspx
Igor Micev,My blog: www.igormicev.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply