by SBarnes » Fri Jan 17, 2020 5:46 pm
Thanks Mike
I am trying to produce a file through the web api that can be run for a specific debtor and give a price per item for everything that is in their preset list, problem is a customer could have thousands to products and to get the price for each when it may be the default means the process can take a couple of minutes to complete, serious grunt, so I am trying to create a situation where I only need to get the price for those where the default doesn't apply to process less.
Of course given that a customer is going to need a web api key to access this another thought process will be on a scheduled basis create a listing of all debtors and inventory combinations where the debtor has an api key in a permanent working table where the default doesn't apply and use this at file generation time to speed things up.
You have been working with the database I am referring to on a support ticket today so you realise the size we are working with.
Regards
Stuart Barnes