Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 8416 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

We have 1400mzh AMD running on Unlimited, 1000AMD runing web server, and 800mzh running filemaker server.

We have one Filemaker application. And I'am moving it to Internet. I have sliced it to sevral pages becouse it's quite bib solution. We have couple of pages that seem to get very much time.

Form is sent to FMserver.. It takes about 8 sec to send form to databse and give format file to user. How can I speed up Fomr processing?

On one page we have 54 fileds to fill up. If I send just a balnk form it takes as much time to proces as it would be full form. All inputs are send with edit action to database. crazy.gif" border="0

I have sliced database layouts to multinle small pieceses. That seem not to be helping anyting.

I tryded this same form processing with APS and SQL-server. Action were happend as fast as any one could need. (very fast).

So, what is taking my time on form procesing on Filemaker? shocked.gif" border="0

I could send sample codes od my page, but the page is quite large. (20KB)

Please help me!

Posted

Is it all forms submitted to FM that are slow?

Try a test by making a small layout (just a few data fields). Then do some queries and updates (edits) on that layout. If that works ok, build-up the fields on the layout to see if you can isolate the problem.

All the best.

Garry

Posted

It's still taking about 6 secs to complete this form...

I have divided my layout to multible small layouts. So that I only have those field on my Filemaker layout (name="-lay" value="huonetilakartoitusa").

What is taking time on this prosces? Machines are't slow. The network is full dublex 100mbs switch network. I'am runing test's on local network(10 meters avay from servers...). Fill up with in filemaker layout happends in a second.

This is my shorthen version of my slow page:

<html>

<head>

<title>Koti-optimi</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

<body bgcolor="#FFFFFF" link="#000000" vlink="#000000" alink="#000000" background="http://rakentajan.suorakanava.fi/kuvat/suorakanava1/rrtuotteet/kotioptimibcr4.gif">

<form method="post" action="FMPro" name="FMPro">

<input type="hidden" name="-db" value="koti-optimi301.FP5" >

<input type="hidden" name="-lay" value="huonetilakartoitusa" >

<input type="hidden" name="-format" value="suorakanava/tyhja.htm">

<input type="hidden" name="-error" value="suorakanava/erroroptimi.htm">

<input type="hidden" name="-recid" value="[FMP-currentrecid]">

<input type="text" name="keittiokoko" value="" size="3">

<select name ="keittiolattia">

<option></option>

<option value="Muovimatto">Muovimatto</option>

<option value="Parketti">Parketti</option>

<option value="Klinkkeri">Klinkkeri</option>

<option value="Laminaatti">Laminaatti</option>

<option value="Linoleum">Linoleum</option>

<option value="Korkki">Korkki</option>

<option value="Luonnonkivi">Luonnonkivi</option>

</select>

<select name ="keittioseinat">

<option selected>

<option value="Levy+maali">Levy+maali</option>

<option value="Tapetointi">Tapetointi</option>

<option value="Muovitapetti">Muovitapetti</option>

<option value="Laatoitus">Laatoitus</option>

<option value="Paneeli">Paneeli</option>

<option value="Puolipaneeli">Puolipaneeli</option>

</select>

<select name ="keittiokatto">

<option selected>

<option value="Levy+maali">Levy+maali</option>

<option value="Paneeli">Paneeli</option>

</select>

<input type="text" name="ruokahuonekoko" value="" size="3">

<select name ="ruokahuonelattia">

<option selected>

<option value="Muovimatto">Muovimatto</option>

<option value="Parketti">Parketti</option>

<option value="Klinkkeri">Klinkkeri</option>

<option value="Laminaatti">Laminaatti</option>

<option value="Linoleum">Linoleum</option>

<option value="Korkki">Korkki</option>

<option value="Luonnonkivi">Luonnonkivi</option>

</select>

<select name ="ruokahuoneseinat">

<option selected>

<option value="Levy+maali">Levy+maali</option>

<option value="Tapetointi">Tapetointi</option>

<option value="Muovitapetti">Muovitapetti</option>

<option value="Laatoitus">Laatoitus</option>

<option value="Paneeli">Paneeli</option>

<option value="Puolipaneeli">Puolipaneeli</option>

</select>

<select name ="ruokahuonekatto">

<option selected>

<option value="Levy+maali">Levy+maali</option>

<option value="Paneeli">Paneeli</option>

</select>

<input type="text" name="olohuonekoko" value="" size="3">

<select name ="olohuonelattia">

<option value="Muovimatto">Muovimatto</option>

<option value="Parketti">Parketti</option>

<option value="Klinkkeri">Klinkkeri</option>

<option value="Laminaatti">Laminaatti</option>

<option value="Linoleum">Linoleum</option>

<option value="Korkki">Korkki</option>

<option value="Luonnonkivi">Luonnonkivi</option>

</select>

<select name ="olohuoneseinat">

<option selected>

<option value="Levy+maali">Levy+maali</option>

<option value="Tapetointi">Tapetointi</option>

<option value="Muovitapetti">Muovitapetti</option>

<option value="Laatoitus">Laatoitus</option>

<option value="Paneeli">Paneeli</option>

<option value="Puolipaneeli">Puolipaneeli</option>

</select>

<select name ="olohuonekatto">

<option selected>

<option value="Levy+maali">Levy+maali</option>

<option value="Paneeli">Paneeli</option>

</select>

<input type="text" name="takkahuonekoko" value="" size="3">

<select name ="takkahuonelattia">

<option selected>

<option value="Muovimatto">Muovimatto</option>

<option value="Parketti">Parketti</option>

<option value="Klinkkeri">Klinkkeri</option>

<option value="Laminaatti">Laminaatti</option>

<option value="Linoleum">Linoleum</option>

<option value="Korkki">Korkki</option>

<option value="Luonnonkivi">Luonnonkivi</option>

</select>

<select name ="takkahuoneseinat">

<option selected>

<option value="Levy+maali">Levy+maali</option>

<option value="Tapetointi">Tapetointi</option>

<option value="Muovitapetti">Muovitapetti</option>

<option value="Laatoitus">Laatoitus</option>

<option value="Paneeli">Paneeli</option>

<option value="Puolipaneeli">Puolipaneeli</option>

</select>

<select name ="takkahuonekatto">

<option selected>

<option value="Levy+maali">Levy+maali</option>

<option value="Paneeli">Paneeli</option>

</select>

<input type="text" name="Tyohuonekoko" value="" size="3">

<select name ="Tyohuonelattia">

<option selected>

<option value="Muovimatto">Muovimatto</option>

<option value="Parketti">Parketti</option>

<option value="Klinkkeri">Klinkkeri</option>

<option value="Laminaatti">Laminaatti</option>

<option value="Korkki">Korkki</option>

<option value="Luonnonkivi">Luonnonkivi</option>

</select>

<select name ="Tyohuoneseinat">

<option selected>

<option value="Levy+maali">Levy+maali</option>

<option value="Tapetointi">Tapetointi</option>

<option value="Muovitapetti">Muovitapetti</option>

<option value="Laatoitus">Laatoitus</option>

<option value="Paneeli">Paneeli</option>

<option value="Puolipaneeli">Puolipaneeli</option>

</select>

<select name ="Tyohuonekatto">

<option selected>

<option value="Levy+maali">Levy+maali</option>

<option value="Paneeli">Paneeli</option>

</select>

<input type="submit" name="-edit" value="Seuraava sivu ->>">

</form>

</body>

</html>

Posted

I have tryed empty format file.It seems very clear that speed is depending on post action. It takes as much time to proces empty format file as it would be full of data..

The layout dose not contain any summary fileds. But many off layout fields has autoenter calculation for cases were user don't give any input.. Could this be the reason....? Exp. kettioseinat field has autoenter calc like this "If(Keittiokoko="";"";"Paneeli")"

Timo

Posted

As far as we have now tested our solution... It shows up that Instant Web publisihing is realy instant... By this I mean that some how, some way istant puplising submits are 10-times faster than custom web publisihing submits... Can anubody tell me why is this.

And what tag (-mode value="beowse")? In instant publishing...

And how can I speed up filemaker submits?

Should I consider turning to use ASP and ODBC-connection to Filemaker... I really doubt it.. It seems to be even more slower.... frown.gif" border="0

This topic is 8416 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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