Slow for initial record

[Donkick]

I have a invoice database with a related table for line items.

The line items are added by the user in a portal on the invoice layout. (via relationship "allow creation of records in this table via this relationship")

The problem occurs when the user adds a line item, the script symbol comes up and it takes about 18 seconds! I have a script that basically duplicates the line item above. When the script adds a record it is almost instant.

FYI I am running this solution on 3 machines with one of the machines hosting the database (no server software)

Any suggestions

[jamesducker]

If there are lots (tens of thousands) of records in the line items table, one thing to look for is any fields with "Unique" ticked in the data validation. This can slow things down in the manner you describe.

James

[Donkick]

Yes, there is a serial number for each line item, but I don't see any field with the unique value checked.

There are 50,000 records in the Line Item table

[Donkick]

when I run the script in debugger it moves right along until it gets to the new record/request step, then it takes a little bit of time. Does anyone have any suggestions?