Wednesday, April 27, 2011

Faster Occupant Searches

A customer pointed out to me that their Occupant name searches took far longer to return results than their Owner name searches. Looking at the SQL tables used in the searches it seemed like the problem stemmed from the fact that a relatively few number of property records had Occupant names defined so the search had to wade through a sea of blank names before it got to anything meaningful. I changed the underlying search table so that now an Occupant search only searches through property records that have an Occupant name listed. Because of this you'll notice that the Navigation Screen will show a much smaller quantity of Total Pages when you do an Occupant search. You should also notice that those searches are much faster. This is a change I implemented to your SQL data behind the scenes so you do not need to download anything to get the new search process.

No comments:

Post a Comment