We have 5 different Pivot table that use a single Generic Inquiry(GI) as the source . Does this affect performance ? When I open one of the Pivot table which has 190,000 records in it . Th system takes about 30 seconds to load before displaying the records in the Pivot table. I am wondering since a single GI is used as a source for 5 Pivot tables , it takes around 30 seconds to display one of these five pivot table or it is because of the number of records(190,000) in this Pivot. What would you recommend to optimize or streamline ?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.