Comparison of four methods for commonly used WebServices to return data

1. directly return the DataSet object

 

Feature: the DataSet object is returned directly.

Application scenarios: 1. intranet. 2. When the Internet and the data size are kb.

2. Return the byte array after the DataSet object is serialized using binary.

Features: The processing mode of byte array streams.

Application Scenario: big data exchange.

3. Return the byte array after the datasetsurrogate object is serialized using binary.

Features: serialization using open-source components provided by Microsoft is still the processing mode of byte streams. For more information, see: http://support.microsoft.com/kb/829740/zh-cn

Application Scenario: big data exchange.

4. Return the byte array after the datasetsurrogate object is serialized and zip in binary format.

Features: the open-source component provided by Microsoft is used to compress and transmit byte stream arrays, which is still the processing mode of byte streams. For more information, see: http://support.microsoft.com/kb/829740/zh-cn

Application Scenario: This method is recommended when the Internet environment needs to transmit large data volumes of network data. This is also a method that I strongly recommend to you.

The WebServices code is as follows:

1. WebServices
2. Using system;
3. Using system. Collections. Generic;
4. Using system. Web;
5. Using system. Web. Services;
8. Using system. Data;
9. Using Microsoft. Practices. enterpriselibrary. Common;
10. Using Microsoft. Practices. enterpriselibrary. Data;
11. Using system. IO;
12. Using system. Io. compression;
13. Using system. runtime. serialization. formatters. Binary;
14. Namespace webservice1
15. {
16. /// <Summary>
17. /// Summary of service1
18. /// </Summary>
19. [WebService (namespace = "http://tempuri.org/")]
20. [Webservicebinding (conformsto = wsiprofiles. basicprofile1_1)]
21. [System. componentmodel. toolboxitem (false)]
22. Public class service1: system. Web. Services. WebService
23. {
24. [Webmethod (description = "datasdatasdatas datasdatasdatas")]
25. Public dataset getdataset ()
26. {
27. String SQL = "select * from MERs ";
28. Database DB = databasefactory. createdatabase ();
29. Dataset DS = dB. executedataset (commandtype. Text, SQL );
30. Return Ds;
31. }
33. [Webmethod (description = "Returned DataSet object byte array after binary serialization")]
34. Public byte [] getbytes ()
35. {
36. Dataset DS = getdataset ();
37. Binaryformatter BF = new binaryformatter ();
38. Memorystream MS = new memorystream ();
39. BF. serialize (MS, DS );
40. Byte [] buffer = Ms. toarray ();
41. Return buffer;
42. }
44. [Webmethod (description = "returns the byte array of the datasetsurrogate object serialized in binary")]
45. Public byte [] getdatasetsurrogatebytes ()
46. {
47. Dataset DS = getdataset ();
48. Datasetsurrogate DSS = new datasetsurrogate (DS );
49. Binaryformatter BF = new binaryformatter ();
50. Memorystream MS = new memorystream ();
51. BF. serialize (MS, DSS );
52. Byte [] buffer = Ms. toarray ();
53. Return buffer;
54. }
56. [Webmethod (description = "returns the datasetsurrogate object serialized in binary and zip compressed byte array")]
57. Public byte [] getdatasetsurrogatezipbytes ()
58. {
59. Dataset DS = getdataset ();
60. Datasetsurrogate DSS = new datasetsurrogate (DS );
61. Binaryformatter BF = new binaryformatter ();
62. Memorystream MS = new memorystream ();
63. BF. serialize (MS, DSS );
64. Byte [] buffer = Ms. toarray ();
65. Byte [] zipbuffer = compress (buffer );
66. Return zipbuffer;
67. }
69. // Compressed byte array
70. Public byte [] compress (byte [] data)
71. {
72. Memorystream MS = new memorystream ();
73. Stream zipstream = new gzipstream (MS, compressionmode. Compress, true );
74. Zipstream. Write (data, 0, Data. Length );
75. Zipstream. Close ();
76. Ms. Position = 0;
77. Byte [] buffer = new byte [Ms. Length];
78. Ms. Read (buffer, 0, Int. parse (Ms. length. tostring ()));
79. Return buffer;
80. }
81. }
82. }

Copy code

The code for the client to call WebServices is as follows:

 

The client calls WebServices.

1. Using system;
2. Using system. Collections. Generic;
3. Using system. Web;
4. Using system. Web. UI;
5. Using system. Web. UI. webcontrols;
6. Using webservicesclient. localhost;
7. Using system. Data;
8. Using system. runtime. serialization. formatters. Binary;
9. Using system. IO;
10. Using system. diagnostics;
11. Namespace webservicesclient
12. {
13. Public partial class _ default: system. Web. UI. Page
14. {
15. Service1 S = new service1 ();
16. Protected void page_load (Object sender, eventargs E)
17. {
19. }
21. // Directly return the DataSet object
22. Protected void button#click (Object sender, eventargs E)
23. {
24. Stopwatch Sw = new stopwatch ();
25. Sw. Start ();
26. Dataset DS = S. getdataset ();
27. Gridview1.datasource = Ds. Tables [0]. defaultview;
28. Gridview1.databind ();
29. Sw. Stop ();
30. Label1.text = string. Format ("Time consumed: {0} millisecond", SW. elapsedmilliseconds. tostring ());
31. }
33. // Obtain the byte array after the DataSet object is serialized using binary.
34. Protected void button2_click (Object sender, eventargs E)
35. {
36. Stopwatch Sw = new stopwatch ();
37. Sw. Start ();
38. Byte [] buffer = S. getbytes ();
39. Binaryformatter BF = new binaryformatter ();
40. Dataset DS = BF. deserialize (New memorystream (buffer) as dataset;
41. Gridview1.datasource = Ds. Tables [0]. defaultview;
42. Gridview1.databind ();
43. Sw. Stop ();
44. Label2.text = string. Format ("Time consumed: {1} millisecond; data size: {0}", buffer. length. tostring (), SW. elapsedmilliseconds. tostring ());
45. }
46. // Obtain the byte array after the datasetsurrogate object is serialized using binary.
47. Protected void button3_click (Object sender, eventargs E)
48. {
49. Stopwatch Sw = new stopwatch ();
50. Sw. Start ();
51. Byte [] buffer = S. getdatasetsurrogatebytes ();
52. Binaryformatter BF = new binaryformatter ();
53. Datasetsurrogate DSS = BF. deserialize (New memorystream (buffer) as datasetsurrogate;
54. Dataset DS = DSS. converttodataset ();
55. Gridview1.datasource = Ds. Tables [0]. defaultview;
56. Gridview1.databind ();
57. Sw. Stop ();
58. Label3.text = string. Format ("Time consumed: {1} millisecond; data size: {0}", buffer. length. tostring (), SW. elapsedmilliseconds. tostring ());
59. }
60. // Obtain the byte array after the datasetsurrogate object is serialized and zip by binary.
61. Protected void button4_click (Object sender, eventargs E)
62. {
63. Stopwatch Sw = new stopwatch ();
64. Sw. Start ();
65. Byte [] zipbuffer = S. getdatasetsurrogatezipbytes ();
66. Byte [] buffer = unzip. Decompress (zipbuffer );
67. Binaryformatter BF = new binaryformatter ();
68. Datasetsurrogate DSS = BF. deserialize (New memorystream (buffer) as datasetsurrogate;
69. Dataset DS = DSS. converttodataset ();
70. Gridview1.datasource = Ds. Tables [0]. defaultview;
71. Gridview1.databind ();
72. Sw. Stop ();
74. Label4.text = string. Format ("Time consumed: {1} millisecond; data size: {0}", zipbuffer. length. tostring (), SW. elapsedmilliseconds. tostring ());
75. }
76. }
77. }

Copy code

The test results are shown in sequence:

 

2009-4-13.jpg(33.94 K) 12:21:12

 

Special instructions on the test results: because the test environment is local and the data volume is not large, the test results are not very close to the actual situation. If you have any conditions, you can test them, we also hope to provide the test results for your reference. (Wen/Shen Shan laolin)

The development environment is vs2008 SP1 + sqlserver2008sp1. The database is the northwind database.

 

Original article: http://www.pin5i.com/showtopic-23733.html