Re: Using Applescript to process WebCatalog functions
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17766
interpreted = N
texte = >> >> Performance >> >> of databases (especially acgi-calls) are faster without AppleScript... >> >>A 2 seconds delay is a backdraw anyway, isn't it? >> >> I've never seen a 2 second delay for anything, and I'm on a slow 68K Mac. Is >> there something else going on that's causing this kind of delay on your system? >> I've always had AppleScript on all my Macs and never have I heard of this kind >> of thing before ... > >Yes, that is the same answer I got from Starnine and Foresight... >But it happens. In fact it happens with 4D-databases running in acgi mode.But does it ever happen without 4D running?>Delay is 2-4 seconds when AppleScript is on. Looks like if the Mac receives an acgi call, asks AppleScript first, discovers that he has no chance to handle that call and finally sends the request to the right application (that is my own childish interpretation ;-)If that's what was happening, AppleScript would be slowing doen EVERY acgi call -- including WebCatalog and any ther CGI's running on your web server Mac. But I don't think that's it.>But, on the other hand, it seems to depend on the complexity of a query so it could be 4D itself (compiled app) which goes down when AppleScript is on - but ACI feels innocent either...I tend to believe it's a 4D issue, and yo8ur assessment of the complexity of the 4D search confirms this very clearly.I've used the WebCat plugin and the CGI and never seen this. But I don't use 4D. Considering the information you've given here, I think it's definitely a 4D problem ... and apparently disabling AppleScript helps -- but that doesn't mean it's AppleScript's fault, that probably just means there's an interaction between AppleScript and 4D that 4D cannot handle efficiently ... so when you disable AppleScript, 4D cannot get into that situation so things seem to work faster again ...>There are three 4D-databases on this machine, WebTen with FTP, Autoboot, Timbuktu 3 and nothing else. RAM is 96 MB, 15 MB for each database. In this configuration we can play the game at any time: AS on = delay, AS off = no delay. Perhaps we are the only company with this problem, but that does not help ...You're probably not the only company, but from what I understand, very few companies use 4D on their web servers.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.>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?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
>> >> Performance >> >> of databases (especially acgi-calls) are faster without AppleScript... >> >>A 2 seconds delay is a backdraw anyway, isn't it? >> >> I've never seen a 2 second delay for anything, and I'm on a slow 68K Mac. Is >> there something else going on that's causing this kind of delay on your system? >> I've always had AppleScript on all my Macs and never have I heard of this kind >> of thing before ... > >Yes, that is the same answer I got from Starnine and Foresight... >But it happens. In fact it happens with 4D-databases running in acgi mode.But does it ever happen without 4D running?>Delay is 2-4 seconds when AppleScript is on. Looks like if the Mac receives an acgi call, asks AppleScript first, discovers that he has no chance to handle that call and finally sends the request to the right application (that is my own childish interpretation ;-)If that's what was happening, AppleScript would be slowing doen EVERY acgi call -- including WebCatalog and any ther CGI's running on your web server Mac. But I don't think that's it.>But, on the other hand, it seems to depend on the complexity of a query so it could be 4D itself (compiled app) which goes down when AppleScript is on - but ACI feels innocent either...I tend to believe it's a 4D issue, and yo8ur assessment of the complexity of the 4D search confirms this very clearly.I've used the WebCat plugin and the CGI and never seen this. But I don't use 4D. Considering the information you've given here, I think it's definitely a 4D problem ... and apparently disabling AppleScript helps -- but that doesn't mean it's AppleScript's fault, that probably just means there's an interaction between AppleScript and 4D that 4D cannot handle efficiently ... so when you disable AppleScript, 4D cannot get into that situation so things seem to work faster again ...>There are three 4D-databases on this machine, WebTen with FTP, Autoboot, Timbuktu 3 and nothing else. RAM is 96 MB, 15 MB for each database. In this configuration we can play the game at any time: AS on = delay, AS off = no delay. Perhaps we are the only company with this problem, but that does not help ...You're probably not the only company, but from what I understand, very few companies use 4D on their web servers.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.>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?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Kenneth Grome
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:
WebCat2: Items xx to xx shown, etc. (1997)
Secure Sever and showcart errors (1997)
RE: How much ram??? (1997)
Another question about credit cards (1997)
Weird problems with [SHOWIF]s (1997)
[WebDNA] Ubuntu 16.04.4 LTS (2018)
emailer (1998)
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
Grepping text variable tags (was: No subject given) (2000)
WebCat Bulletin Board Solution ? (1998)
WebCommerce: Folder organization ? (1997)
New Web Site Developers Database (1996)
New Cost Field (1999)
Proper file locations (1997)
Friendly , quick 'security' check, please (2003)
Country & Ship-to address & other fields ? (1997)
Making Thumbnail Graphics (1997)
WebCat2 - Getting to the browser's username/password data (1997)
WebCat and WebTV (1997)
How To question on setting up downloads (1997)