Jump to content

Increasing find speed on unindexed field


taylorg
 Share

This topic is 7396 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
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

Link to comment
Share on other sites

This topic is 7396 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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