Automatic indexing in Associated Items columns

Vladi Gubler
Vladi Gubler
February 24, 2017 | Products

Hi,

For Associated Items column we need to be able to quickly fetch the relevant child items for each parent, so you can create advanced forms with repeating tables. When you have a limited numbr of items, it is not an issue, the query will be perfomed very fast. But as your list grows, SharePoint will have a hard time retrieving the child items for the particular parent among thousand of items in the child list.

This is where indexing can help. When you configure indexed columns, SharePoint is able to perform queries on those columns much quicker. What more, once you reach the throttling threshold of the list, all queries are blocked. Unless you are using indexed columns!

Until now, users had to configure the indexes on their own, which was not very convenient. Now, we added automatic index management mechanism. Whenever you create a new Associated Items column or update an existing one, we will ensure that the column we use for fetching items are properly indexed.

Note: this feature is already available on Office 365. Our on-premises customers will receive the feature in the next release.

Loading...

Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.

UltimateForms

Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!

Cost-effective

Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com

Related Topics


© 2019 - Infowise Solutions Ltd
The awesome power of ULTIMATEforms

Quickly and easily turn time-consuming business processes into automated, efficient workflows.

100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!

Cost-effective

Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com


Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.