2 Replies Latest reply on Nov 23, 2009 4:37 PM by Vincent_L

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

    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.