December 11, 200124 yr Help me! :-) I've just in the process of upgrading our company's web-based FMPro dbase. It used to run on FM4.1. When upgraded the database takes many times *longer* to log a user on (the html pages use portal and other commands to fetch the list of users from the dbase), but once in the dbase searches etc are *many* times faster. Is there a secret setting that I'm missing to speed up the log-on? The html is copied below. I'd really really appreciate your help. Thanks -Andrew <body> <h2>Database ([fmp-currenttoken]): Login</h2> <center> Please select user i.d., enter password, and press "Login": <form action="fmpro" method="post"> <input type="hidden" name="-db" value="[fmp-currentdatabase: raw]"> <input type="hidden" name="-lay" value="check_login"> <input type="hidden" name="-recid" value="[fmp-currentrecid]"> <input type="hidden" name="-edit"> <table> <tr> <td align=right> User : <td colspan=2> <select name="_user"> [fmp-if: currentcookie:cdb_user .eq.] <option value="" selected>- select your id - [fmp-else] <option value="[fmp-cookie:cdb_user]" selected>[fmp-cookie:cdb_user] [/fmp-if] [fmp-portal: show_users] <option value="[fmp-field: show_users::user]">[fmp-field: show_users::user] [/fmp-portal] </select> <tr> <td align=right> Password : <td colspan=2> <input type=password name="_passwd"> </table> <input type="hidden" name="_ip_addr" value="[fmp-clientip]"> <input type="hidden" name="client_state: b_name" value="[fmp-currenttoken]"> <input type="hidden" name="-script" value="check_login"> <input type="hidden" name="-target" value="_top"> <input type="hidden" name="-format" value="add_menu.cdml"> <input type="submit" value="Login !"> </form> </body>
December 11, 200124 yr I don't know about your speed question, but there will be a problem if there is a near-simultaneous call on your script.
December 11, 200124 yr I had exactly the same problem earlier this year. It turned-out to be some sort of coruption with the file. I rebuilt the file in 5.5 and all was fine. Hope this helps. Garry
December 11, 200124 yr Just incidentally, if your solution is being hosted on a shared FM Server, another solution's script can interfere with yours on a near-simultaneous request.
December 18, 200124 yr Author Hi Tried recovering the files in FM4.1 and FM5.5, ie before and after the conversion without any luck. Anyone got any other ideas? Thanks again. -Andrew
December 18, 200124 yr Are the slowdowns only occuring if users are using Netscape 6.x browsers? We are having a problem with this on a Win2k server! All the best. Garry
December 19, 200124 yr Scripts on web and cookies are the most unreliable things in FileMaker. Maybe you are starting to discover the problems...
December 21, 200124 yr Author Hi Thanks for these thoughts. No - everyone here uses Explorer (we standardised a while back) - and it's giving the problems. Any thoughts? -Andrew
December 24, 200124 yr Author Hi On further investigation, anything that goes thru' the webcompanion in FM5.5 Unlimited seems much slower than FM4.1's webcompanion. Any thoughts? Thanks _Andrew
December 28, 200124 yr Author I'm slowly getting there. It's something to do with the file relationships getting screwed up, but I've tried every recommended way to fix them including re-doing them all and no good. Help! Thanks -Andrew
January 23, 200223 yr Author Hi Now that everyone's back from Christmas and New Years - does anyone have any more thoughts on this please? Any clues would be very helpful at this point. Thanks -Andrew
January 24, 200223 yr How is it with FMU v. 5? Can you try that? That is 5-7 times faster than v. 4. Did you try pages without scripts? Without cookies?
January 30, 200223 yr Author Am working through it trying to find more clues. It seems to be something to do with valuelists - the longer the lists, the longer they take to come thru' the webcompanion (ie much faster in 4.1 and slow in 5.5). The code is: [fmp-valuelist: itema, list=levels] <option value="==[fmp-valuelistitem]">[fmp-valuelistitem] [/fmp-valuelist] Any thoughts would be appreciated. Thanks _Andrew [ January 30, 2002: Message edited by: AndrewB ]
Create an account or sign in to comment