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

[Chris Hansen]

David,

Jonathan is right on track.  Unstored calcs and summary fields  
especially can add time.  Be sure you ONLY have the fields on there  
that you need.

Another thought: you could create the records one at a time, but only  
populate (and use a layout) with one or two fields, and then use  
another layout with a portal to edit all of those records with a  
single query.  This may even be a situation where using a FileMaker  
script (as opposed to doing everything with PHP) would make sense.

Note that there are two keys here:

1) FileMaker does the work for all of the fields on any layout you  
use, whether you do anything with the returned data or not;

2) There is a fair amount of overhead involved with informational XML  
(header information, if you will) returned for each XML query, so the  
fewer the queries the better (FYI, the FileMaker API for PHP uses an  
even MORE verbose schema...)

HTH

--Chris

On Jul 29, 2009, at 3:52 PM, Jonathan Schwartz wrote:

> 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
>