|A) Modify the connection string to add the packet size property and set its values to 8192.||B) Add the following directive to the page: OutputCache VaryByParam=?|
|C) Add the following directive to the page: OutputCache VaryByControl=?region;city?||D) Modify the connection string to keep your database's connection pool as small as possible.|
You can vary user control output to the cache by specifying the user control name and the parameter. We use the VaryByParam attribute of the OutputCache
A: The Packet Size property of the Connection string is the size in bytes of the network packets sed to communicate with an instance of data provider. It is not an optimal property to change to optimize data retrieval.
C: The company database does not seem to include a region column.
D: If we keep the connection pool small we would allow less simulation connections. However, this would not minimize the required to retrieve and display the data.