I have an invoice table related to a line item table. When In the invoice table I create a new line items in a portal. I'm trying to figure out why it takes so long (10-12 seconds) to add a line item to the invoice via the relationship.

There are about 50,000 records in the line item table.

Any help would be much appreciated, I have tried everything I can think of.

Do you have any auto-entered calculations and/or validation set up in the line item table?

There are some auto enter calcs in the table, however they are not on the layout where the new record is created. There is an auto enter serial number for Line Item ID.

The auto enter calcs are things like extended price, that equals quantity X item price. could that be causing the problem?

Auto-entered calculations are performed regardless of being on the layout. However, a simple multiplication of local values shouldn't cause any problems. Why don't you post a clone of your file?

The funny thing is, when I made this file a clone, a new record is created very quickly now? The only difference is the number of records.

Let me know if the attached file helps.

You can log in as a guest with full access.

ImpactShop_Clone.fp7.zip

Edited November 9, 201015 yr by Guest

I'm afraid your file is too complex for me to understand within a reasonable amount of time. I'd suggest you try the following:

1. Save a compacted copy of your file.

2. Recover a COPY of your file; if the recovered copy runs faster, your file is corrupted (do NOT use the recovered copy - use a clean backup instead).

3. Clean up your file: remove missing tables, turn off 'validate always' for fields that are not validated at all, rebuild indices etc. I would also re-check the structure and try to reduce the number of relationships and calculations.

Eventually, I suspect, there is something in a new record that needs to get data from existing records (not necessarily in the same table) - and with a large amount of data that takes time.

It could be a unique field validation, or a relationship that sorts by a related field that causes the slow-down.

Thanks guys... I'm still playing around with it. hopefully we can get it figured out soon.