With large sets of data, comes great responsibility. Our admins, of course, know this to be true. And sometimes, we feel like they deserve a little extra love. Because, as any admin knows, sometimes they make an easy target for “feedback” from their end-users about how their system works. And occasionally, the input they receive isn’t quite something along the lines of, “Wow, I fully understand and appreciate all of the efforts that you put into maintaining our platform that streamlines all of our critical workflows and processes. It’s super great!”
So we thought it was time to show you, our admins, some love with new functionality that should make your lives a bit easier. In fact, if your users have ever come to you with feedback around wanting an easier way to search for information within TrackVia, we’ve got some great news for you!
TrackVia’s new Table-level Indexing capability will allow admins to directly impact their application’s search performance. “How is this possible?” you might be thinking.
It’s simple… (well, not really.) Let me explain: searching through large sets of data can actually be a very involved and complex process, which makes the ability to index at the table-level very significant. But because I don’t want you to put you to sleep while reading this blog, I’ll spare you all the technical details. That said, if you’re a fiend for knowledge, you can read more about the topic in this article on SQL Indexing or in this resource on Database Indexing.
Instead of getting stuck in the technical weeds, we’ll focus on the positive impact this new functionality will have for your end users and how to set up the feature in TrackVia. In order to fully grasp how table-level indexing will improve performance in your application, it’s important to first understand how default search currently occurs in TrackVia.
Presently, if a user searches via the search bar at the top right of the app, TrackVia will run what’s known as a, “Table scan.” When a table scan is initiated, TrackVia will search every record across every column for every single instance of the word or phrase that has been entered. This “Table Scan” search method has its pros and cons:
• The Pros: The search results will contain every instance of the word or phrase at-hand from any record and field. This is great, especially if you don’t know where a certain term is located or want to find every instance of a particular word or phrase.
• The Cons: TrackVia literally scans through EVERYTHING in your app. When working with large datasets, this can present the potential to run into some issues. For example, if the search term entered is too broad, it could yield inaccurate results due to all of the potential matches. Slow results or even no results is another possible downfall that can occur if it takes too long for the system to look through the hundreds of thousands or even millions of records in your app. And as you well know, neither of these scenarios is overly ideal.
With TrackVia’s Table-level Indexing, admins now will be able to manage what fields TrackVia will leverage for search. This means that admins can now index fields for high performance search by controlling the method, in which TrackVia will search their fields. Up to five fields can be indexed, and each can have different search parameters, including:
● Starts with:
● Is Identical To:
Once fields are selected, values entered into the Search Bar will only search the fields that you’ve chosen to be indexed. So instead of going through every single field each time a search is performed, TrackVia will only scan through the fields that have been indexed. This makes searching way more efficient and much faster! And it’s relatively simple and straightforward, right?
Subscribe to TrackVia’s Blog