Re: automatic field creation

X-Trace
User-Agent: Unison/1.7.9
NNTP-Posting-Host: 66-214-13-172.dhcp.lnbh.ca.charter.com
X-Trace: news.bnb-lp.com 1188014664 66-214-13-172.dhcp.lnbh.ca.charter.com (25 Aug 2007 00:04:24 -0400)
Organization: Send abuse or DMCA complaints to abuse@xxxxxxxxxx
Lines: 52
X-Authenticated-User: vca037
X-DMCA-Complaints: Send abuse or DMCA complaints to abuse@xxxxxxxxxx
X-DMCA-Complaints: The subject line should contain only the 4 letters DMCA
Path: mail.derkeiler.com!drt1!artnm!t1!feeder.news-service.com!feeder2.cambrium.nl!feeder1.cambrium.nl!feed.tweaknews.nl!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!news.bnb-lp.com!not-for-mail
Xref: mail.derkeiler.com comp.databases.filemaker:114322

On 2007-08-24 12:36:12 -0700, Diego B <messadua@xxxxxxxx> said:

Actually there no that many calculated fields (no more than 40,
globally, maybe less,
do you think this could be the problem ?
I noticed that, when I use the tabs in the layouts FM slows down
noticeably.
I would avoid using Tabs, but there are so many fields in the Echo
Table that I am forced to
do that. Is this problem recognized somewhere or I am the first to
report it ?

I suspect it's not the tabs it's the fields displayed on the tabs. Yes, 40 calculated fields could slow down a solution depending on how many related fields they refer to or what the calculation is. No one else has reported tabs as a performance drag.

I like this idea, more than auto-enter option.
The script should be something like

set field:: Doppler_GlobalAverage
Insert calculated result:: Average (Basal_Lateral; Bas_InfSeptum;
Bas_InfLat etc...)

I would put the calculation directly in the Specify dialog of the Set Field. Insert calculated result is redundant, and that script step requires that the field be on the layout. Set Field does not.

And if you're using Average on screen, that's DEFINITELY the cause of your slowdown. Every time you move from record to record, or from Tab to Tab, every Average field that displays will have to re-evaluate in order to display.

An average of values on the present record can easily be set by script and be valid.

If your Average covers all records in the db, then every time you enter a new record the average will change for all records, and this is not a good candidate for scripted setting, because the values in all other records will become invalid.

In that case, you'd need to restructure your db to only display average or other summary fields on specific layouts or on reports, rather than on live layouts where you enter data.
--
Lynn Allen
--
www.semiotics.com
562.938.7890
Member Filemaker Business Alliance
Long Beach, CA

.

Relevant Pages

  • Re: OT: Umra posting statistics for May 2008
    ... rather than adding tabs (which can go all over the place if ... horror when I clicked on the "show formatting" button. ... language Jo's script is written in but something like C or Perl's ... always welcome :-) I'm just using Agent, ...
    (uk.media.radio.archers)
  • Re: Trim() isnt stipping tab characters off my data in vbscript
    ... The data file looks like this: ... The script code reads the input file, ... The code segment below then parses it into discrete array fields to be used later in the script for mapping. ... If I delete the tabs the script works fine. ...
    (microsoft.public.scripting.vbscript)
  • Re: Tabs in label/title with pgnuplot (Windows)
    ... > When I have tabs in xlabels, titles, etc. in a gnuplot script, the ... > tabs appear in the image as the two letters N and L, ... when I use pgnuplot.exe on Windows to run the script. ... piping commands into gnuplot. ...
    (comp.graphics.apps.gnuplot)
  • Trim() isnt stipping tab characters off my data in vbscript
    ... I have a data on our server that houses data for mapping specific folders to ... The script code reads the input file, ... The issue I'm having is that the Trimcommand is not stripping the tab ... If I delete the tabs (which makes the ...
    (microsoft.public.scripting.vbscript)
  • Re: Script Optimization
    ... I like using tabs because of the text editor I use, the script at ... Can't you configure it to use 4 spaces per indent - and not use "hard" tabs? ... keeping them in case the indentation is ever lost - makes it easy to ... to accomodate the functions - changed functions to not chdir as much), ...
    (comp.lang.python)