Jump to content

Recommended Posts

sal88    0

I've finally created a database design report for my eight year old database! Quite a few errors (see attached). Can anyone suggest which element I should tackle first? There have been reports of sluggish performance so I want to tackle that first:

DDR.png.604650c413fd70cbe95d34b295f3b31f.png

Many thanks

Share this post


Link to post
Share on other sites
Wim Decorte    456

Collect info from the user users about what exactly is sluggish, otherwise you may be fixing things that don't need fixing.

Also use the FMS stats log and the top call stats log to help put some numbers to it.

While you wait for that, try to map out some of the usual suspects:

- messy file references

- layouts with more than 1 portal on it

- sorted relationships

- layouts with lots of unstored calcs and/or summary fields on it

- ...

Share this post


Link to post
Share on other sites
sal88    0

Sounds good Wim, thanks! Re layouts with more than one portal - quite a few if not most of my layouts have more than one portal. Is this a problem in itself or are there certain ways to ensure good performance when using multiple portal? Or a limit for number of portals?

Same question for sorted relationships and unstored calcs/summary fields on layouts.

What would an example of a messy file reference look like?

Cheers

Share this post


Link to post
Share on other sites
Wim Decorte    456

messy file references: any file reference that has multiple entries, some of which lead nowhere; multiple file reference entries that really point to the same file,..

 

Portals: understanding how a portal forces FMP and FMS to exchange data is crucial.  If you have multiple portals (and worse: of the portals are filtered, sorted or use a sorted relationship) then you have multiple of those interactions going on just to draw the layout.  

A lot of performance problems I have had to deal with over the years come from too much unneeded data being displayed on screens.

Share this post


Link to post
Share on other sites
Lee Smith    147

Hi Wim,

Would putting the portals in sliders, or popups improve the performance?

Share this post


Link to post
Share on other sites
IdealData    23

There's no mention of the server hardware, FMS config, network config or user count - these are also linked to performance issues.

Was there a point in time when the performance was considered OK?

Share this post


Link to post
Share on other sites
Wim Decorte    456

That's why I recommended starting with the FMS logs; it keeps good track of the 4 traditional machine bottlenecks: processing power, memory, disk i/o and network i/o.  If those stats show strain on any of those then the consideration is: how much strain and is there a possibility of solving it with more horsepower. 

Share this post


Link to post
Share on other sites
sal88    0

Thanks for all the  responses guys. Especially Wim's wise suggestion of finding out where it's slow. It turns out people are happy with the performance, I think this must be due to the server upgrade done months ago (i just assumed the slowness persisted).

MT!

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Who Viewed the Topic

    8 members have viewed this topic:
    NLR  dickiechung  john renfrew  360Works  smith7180  ryan360Works  doughemi  rjmanns 
  • Similar Content

    • By Dave Ramsey
      Since FileMaker 16 now exports a plugin "source" code with the DDR (even if the plugin is not present) for plugin script steps, it would be helpful to have a way to identify a plugin based upon this "source" code.  It would be immensely helpful if developers could provide this information.  
       
      For reference the "source" code that I'm talking about is "FMmp" in the sample plugin source code.
       
      In the interest of gathering this information, I whipped up a Google Form for data collection.  To reduce misuse, this form is entry-only.  Once created, there is no way to edit a record.  If the information changes over time (say, you would like users to go to a different URL), just make a new record.  I can't speak for everyone else, but FMPerception will likely be using the last record available for each source code.
       
      At some later date, this may be expanded into a larger registry, but for now I'd just like to get some data.  Follow this link to fill out the form:
      FileMaker Plugin Registry Form
       
      I don't have any interest in being the only person with access to this information, so if you would like to view the results, feel free to click here.
      Plugin Registry - Google Sheets
       
      If there is some other registry, just point me to it, and I'll apologize for the distraction.
       
      Thank you very much.
      Dave Ramsey
       
      P.S.  Here's an example of how it looks when FMPerception knows about your plugin:
       

    • By Guy_Smith
      Is it always safe to delete a script when the DDR lists no Layouts that use the script and no other Scripts that call the script?
      I'm trying to clean up my file without shooting myself in the foot:  I can't think of why I would ever need such a script, but don't want to find out the hard way that I could still need them.
      Thanks in advance,
      Guy
       
    • By Guy_Smith
      YIKES!  I tried to generate a DDR for my solution and got the following error:  
      SAXParseException:  Invalid character 0x12 in attribute value 'PlatformType' (Occurred in entity C:/Users\guys\AppData\Local\Temp\FMTEMPFM5128_4.tmp', at lime 24503, column 981.)  I have attached a screenshot for clarity.  The PlatformType bit is interesting as I work on the file at my office on a PC (Windows 10) and at home on a Mac (OS X Sierra).
      I clicked the OK Button three times and a DDR popped up, but only contained the Report Overview Page:  The correct amounts of Tables, Relationships, etc. showed up, but none of the links work:  It's an empty DDR.
       
      After shutting down FMP, reopening the file and trying again, I received the same error except the "FMTEMPFM5128_4.tmp" changed slightly to "FMTEMPFM5128_6.tmp".  (the 6 replaced the 4)
      I am, as usual, clueless - any ideas out there?
       
      Thanks,
      Guy
      SAX Parse Exception 092916.pdf
    • By m_fitzgerald
      I've used the PHP simpleXML library as the basis of a simple tool for querying the XML DDR produced by FMPA . It's fairly functional and it has the benefit of being fast. Unlike other tools it doesn't require pre-processing of the XML prior to use.
      I've decided to publish it under the GNU AFFERO licence.
      If you're comfortable running a PHP script under localhost you can install it on your machine and make use of it. It's available from http://www.notyourhomework.net
    • By michele
      Hello,
       
      I just discovered something scary.  I wanted to check if a specific script was used on a layout as I wasn't sure anymore.  So I created a DDR.
       
      When checking the script in the DDR the 'Layouts that use this script' and 'Scripts that use this script' parts were empty.
      Still I felt a bit unsure about deleting my script, so I searched for it manually on my layout and...I found it.
      I used it in a portal on a button (=text).
       
      Is this a known bug of the DDR or did I miss something?
×

Important Information

By using this site, you agree to our Terms of Use.