How to prevent auto enter calculation from executing while creating a new record

[rsin]

Hi Everyone,

 

 

I have a database table containing around 700 fileds and half of them are auto enter calculations. Every time i create a new record it takes a long time to create, even more the first time. I just need the record to be created, rest calculations can be done afterwards through scripting. I cannot remove the calculations.

 

Have tried creating the record in seperate table(with the required data only) and then importing those data into my main table, but still, it takes a while.

 

So i was thinking of a way if i can supress the calculations while the new record is created. Is there any or other way of achieving that?

 

In desperate need of this performance tuning.

 

Thanks

[Wim Decorte]

Automatic message

This topic has been moved from "Site Instructions" to "Calculation Engine (Define Fields)".

[Wim Decorte]

Why can you not remove the calculations?  Seems like the logical thing to do.  Take off the auto-enter calcs and add them later in the business logic scripting

[bcooney]

I think that the existence of 350 auto-enter calcs is a red flag to poor design and thus poor performance.

[Lee Smith]

Hi rsin and welcome to the Forum,

 

I moved your topic from "Site Instructions" to "Calculation Engine (Define Fields)".

 

The Site Instruction Topic is for Admin’s use, not for asking how to questions.

 

Lee

[comment]

I think that the existence of 350 auto-enter calcs is a red flag to poor design

 

I agree. But the 350 auto-entered calculations are very likely a by-product of having 350 "regular" fields to begin with. It's a very rare entity that requires 350 attributes to describe properly. I'd suspect many of those fields to be numbered and used as a poor substitute for multiple records in a related table.