Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Script runs slow on network


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

Recommended Posts

In an inventory and invoicing system, I have an invoice with a complex validation script, which is activated by clicking an "add item" button on the invoice This script first checks that data exists in all needed fields, then:

-- determines if the number is for a part or a vehicle

-- if a vehicle, checks the Vehicles database for a valid number

-- checks the Vehicles database to assure that the vehicle remains unsold

If the number applied was a part number, the script :

--checks a 13,000-record parts database to determine that a valid number has been entered,

-- checks that the re-order point has not been reached

--checks that the quantity ordered is indeed in stock, (of course the Parts database itself is dependent on the Line Items database to make this determination)

When all items pass muster, the numbers and quantities are added to the Line Items database and automatically appear in the Invoice's Line Items portal.

All this take about 1.5 seconds on the hosting machine, but takes 3 to 4 MINUTES on the client machines. I can't figure out how to speed this up. Any ideas?

Link to comment
Share on other sites

Well, here are some sample validations I'm using:

#CHECK FOR A VALID PART NUMBER

If [isValid(ValidPart::Part No.)=0]....

#CHECK WHETHER A VEHICLE HAS BEEN SOLD

If[ Derbi Vehicles Inventory::INSTOCK FLAG="SOLD"]....

#CHECK WHETHER SUFFICIENT PARTS EXIST IN INVENTORY

If[Derbi Parts Inventory::Quantity - TempQuantity < 0].....

THERE ARE 4 or five similar validations in the script, all written like these. I don't do any Finds.

Link to comment
Share on other sites

This topic is 7850 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
×
×
  • Create New...

Important Information

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