Why is the IsAFruit field an unstored calculation? Making it a stored calculation will speed up the find.
Thank you for posting.
I have not been able to recreate the issue you are describing. Since you have been able to get this search to work when the file is opened locally, it's not clear what is hanging or disconnecting your client for Instant Web Publishing.
Here's what I did:
Created two related tables (related by ProdID):
1 Table ProdSummary
2 Fields:ProdID, Sum_IsAFruit
3 Fields:ProdID, Prod_Type, IsAFruit
I setup Instant Web Publishing on the file, and from Internet Explorer, opened the file and tried to do the same find. There was not a problem getting the found set, and the file remained open in IWP until I logged off.
Have you been able test your connection to any other files shared with Instant Web Publishing from this same client? If not, please try creating a simple file and connect to it from the same client, so that we can rule out anything in the PC's configuration that is interfering with IWP.
Please keep me posted.