Jump to content
Sign in to follow this  
taylorg

Increasing find speed on unindexed field

Recommended Posts

I have a large invoice database with a calculation field that calculates the total invoice amount less the total payment amount leaving me with the total outstanding.

This field cannot be indexed resulting in the find being very slow.

Are there any tricks that will enable me to speed up this search?

Is there a way to automate the population of an indexed field based on whether an amount is owing in another field or not?

Share this post


Link to post
Share on other sites

You can use an offline process performed after hours (chron job) to set the contents of an indexed number field to the "total outstanding". This would only be updated once per day and may be incorrect, but finds on this copy of the real field will be fast.

-bd

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.