balooka Posted December 19, 2002 Posted December 19, 2002 Hi, I have a few InlineActions that perform a find, but when I observe the Db while some pages are loaded, it's processing data as it should but also 'refreshes' the window alot. I'm not sure, but if I *could* freeze the window, would that reflect on any new Inline-search? I mean, will it refresh on the next reload of that page? My db's are used alot online and I see the statusbar jumping around. I've tried to cut down on lay-out processing by creating an all-white lay-out thats opened as a default (leaving all CGI lay-outs in the background). Does this contribute to anything? Thank, JP ps. does FMserver speed up webconnections compared to a Unltd version on a Mac G4, 2Mb line?
iSolve Posted December 24, 2002 Posted December 24, 2002 Hi Balooka, In my experience, running a number of subsequencial find actions through InLine Actions is very intensive on the server. You could, conceiveably, freeze the databases window on the server in an attempt to reduce the processing on the server itself, but, to my knowledge, that would best be done through a Script (which would incorporate the search action aswell). On my server (Mac OS 8.X, FM Unlimited 5.0), I also see the various screens flicker a little, but it has no known ill effect on the performance of those databases. The way in which I have most recently found that I could speed up my server has been through removing all non-essential fields from the CGI layouts. I use a number (approx 33) of Summary Fields to give me totals for the found set in a particular database, but the calculations of these fields, when not necessary for the format file requested, does negatively impact the performance of the server. As such, I created a new layout, without the summary fields, which I reference whenever I need these totals. Thanks Luke PS. To the best of my knowledge, FM Server does not provide Web Interface, and only allows connection from workstations using FileMaker Pro directly. As such, it would not be suitable for your current requirements (unless you want to change the way in which your users interface with the server).
balooka Posted December 26, 2002 Author Posted December 26, 2002 Thanks for the reply Luke, I've seen those screens flicker too and already did modify the lay-outs as you said in your reply. I wanted to know this since the DB's are hit alot, and the startupscreen of the site in question has about 8 inlinecalcs directed to 4 db's. It's all working fine on a G4, 533, OSX.2.3. I did however put up a network monitor (XMonitor) to keep a lil track of the load, and it seems that hiding de DB's takes less CPU time. I'm not sure however if this is really true since i do not count visitors in time. One inlineaction does hit a script that will set the pageviews to +1, but that could also mean the page is reloaded... Thanks JP
Recommended Posts
This topic is 8072 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 accountSign in
Already have an account? Sign in here.
Sign In Now