January 7, 200224 yr 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. 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? I could send sample codes od my page, but the page is quite large. (20KB) Please help me!
January 7, 200224 yr 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
January 7, 200224 yr I am posting forms from browser to FM Unlimited on 500Mhz Intel with 10-15 fields with 10-50k data (text database) in split seconds.
January 10, 200224 yr Author 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>
January 10, 200224 yr Just a thought... perhaps it is the -Format file that is slowing down WC, not the form that calls it.
January 10, 200224 yr Take a look at the layout used: <input type="hidden" name="-lay" value="huonetilakartoitusa" > Does it contain summary calculations?
January 11, 200224 yr Author 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
January 16, 200224 yr Author 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....
Create an account or sign in to comment