[FX.php List] can only create 4 records before timeout

[Jonathan Schwartz]

First things first.

- Reduce layout fields to just those needed for this script.

- increase timeout setting in php, either in ini or with an ini set  
command in the script.

- Add some logging that tells you where the time is being spent. You  
have to log to a file instead if the screen because nothing gets  
written to the screen until the script finishes. And if the browser  
times out you get nada.

Hth.



Jonathan Schwartz
Exit 445 Group
415-370-5011

On Jul 29, 2009, at 2:22 PM, Troy Meyers <tcmeyers at troymeyers.com>  
wrote:

> David,
>
> If the layout you are referring to during creation has all 200  
> fields (or even just more than you need), then I'd definitely try  
> your option (2.) first. Here I have many layouts for different  
> purposes, and putting only the fields needed to accomplish the  
> purpose makes great speed improvements.
>
> -Troy
>
>
>
>> I am using a loop to create records when they do not exist.  As I  
>> stated
>> yesterday, it only gets four records created before timeout.
>>
>> IIS 6 & the FM7 WPE is on a dedicated Win2K3 server.  FileMaker  
>> Server 7
>> is on an adjacent Win2K3 server and both are connected via a local
>> gigabit switch and both are dual processors with adequate RAM.  I am
>> trying to find out what is causing the performance hit or latency
>> issues.  I can monitor both servers' processor & network %usage and  
>> it
>> appears that the FM7 Server is doing some significant number  
>> crunching
>> over the processor when I run the script.
>>
>> Should I try:
>>
>>  1. moving FileMaker Server onto the same hardware?
>>
>>  2. performing the FMNew() on a layout with just a few fields?
>>
>>  3. upgrading to a newer version of FileMaker Server?  (is there any
>>
>>  increase in performance in 9 or 10? I am certain FileMaker will tell
>> me
>>
>>  that I need to upgrade.  However buget precludes that possibility  
>> for
>> now)
>>
>>  4. reducing the number of fields and or relationships in the
>> database?
>>
>>  The table I am working in has over 200 fields.
>>
>> Any ideas?
>>
>> Thanks,
>>
>> David Cox
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list