James Gill Posted October 5, 2012 Posted October 5, 2012 I have an extremely simply relationship in Filemaker 12 Authorization -> AuthorizationLineItems The authorization table has about 20k records and the AuthorizationLineItem table has about 90k records. When performing a search on an indexed calculation field directly on the AuthorizationLineItem table this search takes less than a second. However, when searching that field same indexed field through the above relationship from the Authorization table, the search takes in excess of 5 seconds to complete. Is there some fundamental issue with the above relationship that I'm not aware of, or is Filemaker 12 WAY slower when it comes to related searches when compared to Filemaker 11?
Recommended Posts
This topic is 4492 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now