AnsweredAssumed Answered

8 Table occurences of one table means 158 times slower new record creation !

Question asked by Vincent_L on Nov 22, 2009
Latest reply on Nov 23, 2009 by Vincent_L

Summary

8 Table occurences of one table means 158 times slower new record creation !

Description of the issue

Hi, I run a script for creation (with looping) 1367 records in a table. I searched way to optimize it beacuse to create the record and populate 2 fields just after record creation took 158 seconds for 1367 records ! That's only 8 record per second. That table is in a fp7 file with other tables. There's 8 TO involving it. If I remove all TO it takes 1 second to create those same 1367 records ! So having the table involved in 8 TO makes record creation 158 times slower ! So don't make TO !!!! I can't see why this would be legit that record creation would be impaired by the number of TO. 

Outcomes