[FX.php List] Faster record creation?

[Troy Meyers]

Bob said:

> I would think that a script might be faster than looping through and  
> creating via the web; if I get bored I might give it a try, but  
> offhand, even though I never use scripts for any web apps, this might  
> be the exception.

I bet it would be. We have a machine that is dedicated to doing periodic FM scripts to do maintenance on our databases, such as checking for things that need some sort of deferred processing, things that take too long for the web environment.

Perhaps this approach could be taken. The slave machine could check to see if the "reserve" of sets of unattached sets of 1064 records needs to be replenished, and when it does it could make more. It would just need to do it frequently enough that there would aways be some for the user's rate of creation of parent records. The reserve records could have anticipated relation IDs that would match anticipated new parent records.

-Troy