• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
Our staff reported that it's significantly slower while browsing in MEDIA collection of Web OPAC, comparing to browsing in FULL catalog.

I have an observation that may or may not be relevant. Browsing by the same wording in this collection for the second time seems to get faster, but still not as fast as in FULL catalog.

I don't have a good test case to compare with other collections, but so far other collections don't seem to have the slow browsing problem.

Resolution:
util h/1/10 shows that the ABC_MEDI base has 18,399 records:

ABC_MEDI | 18399| Yes | No | *** Err **

This is about 1% of your records. It may be that specifying "Y" in tab_base.eng column 8 (to build the z0102 for the base) could improve the Browse performance.

After making this change to tab_base, you would need to rerun p_manage_32 to make it take effect. I estimate 2 - 5 hours. It locks the library.


[From site:] The indexing fixed it.

• Article last edited: 10/8/2013