显示wss图片库:速度
应用场景：获取图片库指定文件夹下允许发布的所有图片,图片数量非常庞大！
一开始,载入页面始终维持在17秒左右;
结果这样实现了，不到1秒钟, faint !
一开始,载入页面始终维持在17秒左右;
结果这样实现了，不到1秒钟, faint !
1
#region
2
WindowsImpersonationContext wic = null;
3try
4
{
5wic = CreateIdentity(User,Domain,Pwd).Impersonate();
6
7SPSite site = new SPSite(webUrl);
8SPWeb web = site.OpenWeb();
9SPList list =web.Lists[libName];
10Uri uri = new Uri(webUrl);
11string header = "http://" + uri.Host + ":" + uri.Port.ToString();
12SPFolder fld=web.GetFolder(libName).SubFolders[folderName];
13SPQuery query = new SPQuery();
14query.Folder = fld;
15foreach(SPListItem item in list.GetItems(query))
16{
17//判断发布字段
18if( Convert.ToBoolean(item["发布"]) == true)
19{
20 string imgUrl1 = header + item.File.ServerRelativeUrl;
21 string title = item.File.Title;
22 string time = item.File.TimeCreated.ToString("MM/dd HH:mm");
23 string content = item["说明"].ToString();
24
}
25}
26}
27catch
28{
29}
30finally
31{
32 if(wic != null)
33 wic.Undo();
34}
35
#endregion
#region2
WindowsImpersonationContext wic = null;3
try4
{5
wic = CreateIdentity(User,Domain,Pwd).Impersonate();6
7
SPSite site = new SPSite(webUrl);8
SPWeb web = site.OpenWeb();9
SPList list =web.Lists[libName];10
Uri uri = new Uri(webUrl);11
string header = "http://" + uri.Host + ":" + uri.Port.ToString();12
SPFolder fld=web.GetFolder(libName).SubFolders[folderName];13
SPQuery query = new SPQuery();14
query.Folder = fld;15
foreach(SPListItem item in list.GetItems(query))16
{17
//判断发布字段18
if( Convert.ToBoolean(item["发布"]) == true)19
{20
string imgUrl1 = header + item.File.ServerRelativeUrl;21
string title = item.File.Title;22
string time = item.File.TimeCreated.ToString("MM/dd HH:mm");23
string content = item["说明"].ToString();24
}25
}26
}27
catch28
{29
}30
finally31
{32
if(wic != null)33
wic.Undo(); 34
}35
#endregion