⟩ Suppose You are creating an ASP.NET page for selling movie tickets. Users select a region, and then theyselect from a list of cities in that region. The site displays the names and locations of movietheaters in the city selected by the user.Your company, XYZ Brothers, maintains a list of theaters in a database table that includes thecity, name, and street address of each theater. You want to minimize the time required to retrieveand display the list of theater names after a user selects the region and city.What should you do?A. Modify the connection string to add the packet size property and set its values to 8192.B. Add the following directive to the pageOutputCache VaryByParam=?city?C. Add the following directive to the pageOutputCache VaryByControl=?region;city?D. Modify the connection string to keep your database?s connection pool as small as possible.
B. Add the following directive to the page:
OutputCache VaryByParam=?city?