.net WebService 大數據量時性能的提高

1.直接返回DataSet對象

1. [WebMethod(DescrWord=******");
2. SqlCommandcmd=newSqlCommand();
3. cmd.Connection=sqlCon;
4. cmd.CommandText="select*fromT_User";
5. SqlDataAdapterda=newSqlDataAdapter(cmd);
6. DataSetds=newDataSet();
7. da.Fill(ds);
8. returnds;
9. }

1. [WebMethod(Description="返回DataSet對象用Binary序列化后的字節數組")]
2. publicbyte[]GetUserListDateSetBytes()
3. {
4. DataSetds=GetUserListDateSet();
5. //序列化
6. BinaryFormatterser=newBinaryFormatter();
7. MemoryStreamstream=newMemoryStream();
8. ser.Serialize(stream,ds);
9. returnstream.GetBuffer();
10. }

1. [WebMethod(Description="返回DataSetSurrogate對象用Binary序列化后的字節數組")]
2. publicbyte[]GetUserListDateSetSurrogateBytes()
3. {
4. DataSetds=GetUserListDateSet();
5. DataSetSurrogatedss=newDataSetSurrogate(ds);
6. //序列化
7. BinaryFormatterser=newBinaryFormatter();
8. MemoryStreamstream=newMemoryStream();
9. ser.Serialize(stream,dss);
10. returnstream.GetBuffer();
11. }

1. [WebMethod(Description="返回DataSetSurrogate對象用Binary序列化并ZIP壓縮后的字節數組")]
2. publicbyte[]GetUserListDateSetSurrogateZipBytes()
3. {
4. DataSetds=GetUserListDateSet();
5. DataSetSurrogatedss=newDataSetSurrogate(ds);
6. //序列化
7. BinaryFormatterser=newBinaryFormatter();
8. MemoryStreamstream=newMemoryStream();
9. ser.Serialize(stream,dss);
10. //壓縮
11. returnCom
12. ///<returns></returns>
13. publicbyte[]Compress(byte[]data)
14. {
15. MemoryStreamms=newMemoryStream();
16. GZipStreamzipStream=newGZipStream(ms,CompressionMode.Compress);
17. zipStream.Write(data,0,data.Length);//將數據壓縮并寫到基礎流中
18. zipStream.Close();
19. returnms.ToArray();
20. }

5.結果圖

• .net_webservice大數量時性能的提供.rar (119.2 KB)
• 下載次數: 26

• DataSetSurrogate.rar (8.7 KB)