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

[Gjermund Gusland Thorsen]

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
>