Re: Script losing speed
- From: "Bill Marriott" <wjm@xxxxxxx>
- Date: Thu, 18 May 2006 06:33:26 -0400
Two possible issues:
1) Memory management issues with the $variable growing
2) Having to access data which is not in the cache
Or an interaction between the two. My approach would be to try commenting
out the steps that build the $variable to see if that has an impact on the
speed of the script. Then, I would try dramatically increasing and the
decreasing the cache size FileMaker has to work with (default is 8MB) to see
if that had an impact.
A faster method could be to build what you need in a separate table, then
export the whole table, rather than looping through and putting it all in a
variable.
"Ursus" <ursus.kirk@xxxxxxxxxx> wrote in message
news:446c43b7$0$61088$dbd4b001@xxxxxxxxxxxxxxxxxx
FMP8 Advanced, WinXP
I have made a exporting script. It collects al data I need in a variable.
There are 300 records, which in the end result in a text(htm) file of
358kB. When I start the script it shoots alkong, but during the loops it
gets slower and slower. I'm puzzled by the speedloss. There is only one
global field involved (to to perform the export in the end), all data
needed are stored in local variables, of which there is one that will
export in the end.
The basics are as follows.
Find all records
create htm-header in $Export
loop1, collect the vallues of the current record
Append Loop1data to $Export
loop2, collect related data from a second table
Append Loop2data to $Export
end loop2
goto next record, exit when done
end loop1
create index, append it to $Export
Now stuf the the $Export into the global gExport
omit the record
show omitted only (I now have only one record active)
Export record
It is now a huge issue, I can just wait untill the script finishes, but
the slowing bothers me. Have I done something wrong? Or just stick with
it.
Keep wel, Ursus
.
- References:
- Script losing speed
- From: Ursus
- Script losing speed
- Prev by Date: Re: exporting
- Next by Date: E-Mail via Webpublish versenden
- Previous by thread: Script losing speed
- Next by thread: Re: Script losing speed
- Index(es):
Relevant Pages
|
