Fundamental script question

[crazybake]

I have a DB running on Filemaker server. In order for a user to generate a schedule, quite a few scripts take place and it is slow. Is it better to create a loop which performs all scripts on each record or perform scripts each which has its own loop... or better yet... what is the best way to perform multiple scripts across the network...

thanks

[Kurt Knippel]

Without more detailed information on what EXACTLY you are doing it is difficult to say. Loops may be faster or slower depending upon the situation.

[crazybake]

good point!!

I did not do a very good job planning my app... but basically I have a scheduling app that lists jobs, due dates, equipment, dates for production and post production and tasks associated with it.. Everything works except it is slow and you may have a simple answer.

an individual will enter a job into the system, then will view jobs which are in pre and post production. The preproduction schedule will perform the various calculations (# of colors, amount of time it takes, the actual preprodcution taks etc.) The post production will list tasks, packaging, delivery, outside services. All of this info comes from the initial job entry.

My fundamental mistake is that when a user looks at one schedule it performs multiple scripts for listing project manager abbreviations, amount of time it takes to do the job, abbreviations for tasks, etc. when they go to the other schedule, it performs diferent tasks... but.. when the user goes back. It performs the sames scripts again...

What is the proper way to peform scripts once so that the proper data is in the schedule the user can just view the data.... however, if the data changes that the scripts will recalculate the time etc...

[jasonwood]

What are the scripts actually doing? Could you use stored calculation fields instead?