performance of application is slow because of loops.

[randhir]

hi,

i am using FileMkaer pro 11 advanced my application is of size 27mb ,the performane of application is slow ,how we improve the performance of application is there any software or any technique to enhance the performance of application

[bcooney]

Randhir,

You need to be much more specific. What is your setup? A hosted file? WAN access? IWP?

What is slow? List views? Sorts?

Optimization is an art-form in FileMaker development and there are several "best practices" that exist. See HOnza's blog, as this is a topic that he has explored recently.

hth,

Barbara

[randhir]

hi,

I am using filemaker pro 11 advanced in MAC when i am using this script which i attached when it run it takes 30 minutes to perform is there any solution for this problem.

[randhir]

i am using application in hosted not in server

[Lee Smith]

I merged your two topics. Please do not multiple post you questions.

Automatic message

This topic has been moved from "FileMaker Security Management → Intellectual Property" to "Database Schema & Business Logic → Calculation Engine (Define Fields)".

[bcooney]

Just from the brief glance at your scripts, I am sure that a more experienced developer would be able to optimize this system. What is the goal of this script?

[Aussie John]

You might be better served uploading a basic version of the database as it isn't easy to see how the script is running and yes the goal would be a good idea.

[Vaughan]

There are only two things that affect performance:

1) the amount of data (both record data and interface data like graphics) that has to be moved from the server/disk to the client and back again

2) the number of calculations that have to be performed by the client

There are ways to minimise both.

It's important not to prematurely optimise a solution. That is, always code efficiently but only optimise when it's necessary. A report may take 6 hours to run. It may take a week to optimise this down to 3 hours, or a month to get it down to 2 hours. If the report is run every day then it's a good return on the investment. If the report is run only once a year then it's not worth optimising.

[Fitch]

In your script, it calls the "set fields new record" multiple times. We don't know exactly what this script does, but if it's doing essentially the same thing each time, then you could simply use Duplicate rather than New Record, and not have to call the subscript/set all those fields every time.

It looks like you're trying to set up a calendar. Have you looked at seedcode.com? They make a fine FileMaker-based calendar, including a free version that might be very instructive for you.

[randhir]

hi,,

In this script new records script is taken with each new records script a different record is set in that field.

[Fitch]

That sentence made no sense at all. Did my suggestion make any sense to you? It's hard to go any further unless you post the subscript or a copy of the file.

[Vaughan]

i am using application in hosted not in server

If this means the FMP file is on a shared network volume: this is BAD, very bad. Not only is it slow it will cause data corruption.