[ic] Performance issue pulling price from ERP system

[Ron Phipps]

> From: Tim Nelson
> 
> I looking for some advice on how to handle pulling real-time pricing
> from an ERP system in "bulk".  Currently, I have:
> 
> CommonAdjust   [user-price]
> 
> and [user-price] is a usertag that calls out via a socket to an ERP
> system to pull the customer's price.
> 
> This works fine for the late-model POS systems I interact with since
> they have little overhead to pull this off.  However, I have one
POS/ERP
> platform that is running Business Basic and the overhead to start
> up and pull a price for a given customer/item is significant enough
> that the cart and result pages crawl.
> 
> I want to invent some "pre-fetch" type of logic that could request
> multiple item prices from the ERP system as a single request, push
> those values into the session, and then have [user-price] just pull
> from a session buffer.
> 
> Am I making sense here?  Any ideas would be appreciated.
> 
> Thanks.
> 
> Tim Nelson

Tim,

Does your situation require that those prices be in real time?  Perhaps
you could build a script that pulls the pricing for all of your items
into the database nightly, or maybe multiple times per day?  This way
you would only be dependent on the ERP system a few times through out
the day and the speed of the ERP system would not be an issue.

Good luck,
-Ron