If Session takes long time to run, how to improve its speed

[purushotham.dwh]

If Session takes long time to run, how to improve its speed

[yepstraightastudent]

help me with this question!!11

Suppose you have a very long steel bar, with a regular pentagonal cross-section where each side of the pentagon is 2 cm in length. This bar will be suspended vertically over a very deep chasm. At the bottom end of the steel bar, there is a spherical steel weight with a diameter of 50 cm. Going up the bar, at every 3 metre increment, there is a spherical steel weight with a diameter of 30cm.

If the density of the steel is exactly 7.8 g/cm3, the steel can withstand a tensile stress of 400 MPa, and gravity is 9.81m/s2, what is the maximum possible length, in metres, that the bar can extend without breaking? Round down to the nearest metre, submit only a number (with no additional or extraneous information), and disregard any deformation of the bar or any other forces acting on the bar.

[prasanth_v]

This is a common question asked in interviews. To increase the session performance there are different options:

1. Pipeline Partioning ( The best solution)

2. Increase size of cache if your session uses Aggregrator, Rank, Lookup and joiner transformations

3. Increase commit intervals.