changed the universe:> Most desktop database software that's being used to serve web data (4D, FMP, > etc.) should be run on a separate computer from the web server -- because > desktop databases are generally CPU hogs, and their uncooperative behavior > towards web servers almost demands that they are run on a separate machine in > order to free up the web server CPU to serve incoming requests as they come in.The databases need a webserver on the same machine and there is no difference in performance when they run on a different one as long as the machine does not come to the limit. You can't compare FileMaker and compiled 4D-applications. 4D/NetLink has outstandig performance, sometimes beaten by WebCat :-) but, to be honest, for dedicated WebCat tasks only. That's why we start to use WebCat now for shopping. I've never seen an Oracle application with the speed of 4D or WebCat on the web, plain SQL databases are pretty fast but really plain... > >when I see such a behavior and cannot find an acceptable explanation I blame > AppleScript for doing some funny things under the hood... > > I would tent to believe it's 4D and not AppleScript that's causing the problem. > Have you tried removing 4D from the equation to see if anything else can > possibly create the slowdowns you're experiencing?Yes, I have done it and it is like you suspect ;-) But - again - we can't live without 4D now and I am still not sure if the effect ist just clearly shown in our configuration and less clearly in others. AppleScript is a wonderful tool but has to be be handled with care - bigger applications should do their own job anyway and not engage my machine for tasks I cannot control. For heavy scripting is Unix the right platform, for occasional tasks AppleScript is ideal.So, to come to a conclusion: we started the discussion with updating databases using AppleScript. And after all I recommend not to do so, it can run too often when triggered by a customer. If someone wants to script his webserver-machine, it is wise to keep the nuber of scripts down and use them for administrative tasks only. Never ever let a customer play with it - remember the behavior of a standard desktop machine while a heavy script runs in background. On a fast welltuned server the impact may be harder to see - but it is here. Peter __________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21
Peter Ostry
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
where to put code (1998)
BR (1997)
Trouble with my database (1998)
(2001)
Forcing price recalculation in shopping cart (1998)
Download URL & access on the fly ? (1997)
Does [Sendmail] create html? (2002)
Emailer (1997)
RePost: NAT and the CART (1999)
taxRate is fine but taxTotal isn't (1997)
Image maps/Webcat (1997)
Date or time comparisons have bugs ... (1998)
OT: BulkRegister.com (2002)
Fwd: 502 Bad Gateway (1998)
[WebDNA] [switch] [case] only works with "=" comparisons.. true? (2009)
[WebDNA] Access to WDNA_OFS.db (2013)
2.0Beta Command Ref (can't find this instruction) (1997)
Search design (1997)
WC Database Format (1997)
Emailer Chokes on bad address (1997)