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

[Gjermund Gusland Thorsen]

With FileMaker 5/6 i used the name of the php script that used that laoyut.

ggt

2009/7/30 Gjermund Gusland Thorsen <ggt667 at gmail.com>:
> I name them xmlPurpose
>
> ggt
>
> 2009/7/30 Leo R. Lundgren <leo at finalresort.org>:
>> I always use seperate layouts for FX/FMPHPAPI, containing only the needed
>> fields without any extra candy. I suffix them with " | XML" but otherwise
>> they're named the same as the "normal layouts", so that they're easy to
>> track.
>>
>>
>> 29 jul 2009 kl. 23.52 skrev 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
>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>> -|
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>