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

Automatic message

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

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

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

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

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.