hi has anyone come across this?
converted our clients VFP to SQL SE. Every now & then, not all the time, but quite freqnetly, they get the following:
Satisfy a purchase order.......they click OK & then it says "checking stock availability, please wait" & it can take between 5 mins & 20 mins to complete. They do another one & it works fine, they do another & its the same, delay
If you do it on the server, it seems to work 100%. Machine isnt getting maxxed out & it has 8GB RAM, so I cant see it being a resource issue, but it never used to do this in VFP, so theyre not very happy!
Any info would be apprecaited
thanks
James