Spawn Wishes
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21441
interpreted = N
texte = Other then my normal wishes for a $2500 program to understand if/then/elseand and/or statements...I think a little more time could be put into perfecting the spawn command.Don't get me wrong, the spawn command is a real lifesaver. However, I'mcurrently waiting for the damn server to finish a spawned process, becausespawned processes seem to get 100% CPU cycle time, and served pages get theshaft. I would really like the ability to set (or have preset) spawnedprocesses to 25% duty cycle, and leave the processor open to servingwebpages as speedy as possible. (I should mention that I am using webcat3,webstar3 on a Mac) Anyway, as I write this, I am sitting here waiting for a30 minute process to finish (updating a database of 4000 items with 40 sizefields per item out of a flat import file) Under a load of one to twoadditional surfers the webserver appears just plain slow (15 second delayto serve webcat processed pages) When I get 6 or 8 surfers the webserverstarts spitting out Gateway timed out messages. Also, although I need to have autocommit databases on (I use a lot oftracking databases and catalog request and email databases on my websites) Ithink there should be a way to turn it off for the databases involved in aspawned processes. In the above example, I take the active database, copy itto a new directory, modify the copy, then if the process is completedsuccessfully, I close the real database, replace it with the new, and openit. During the update, the server busily writes out the temp database to thehard drive (seemingly after every record) causing quite a delay while theupdate is taking place. Brian B. Burton BOFH - Department of Redundancy Department--------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.comAre you a Web Programmer?I am today.
Associated Messages, from the most recent to the oldest:
|
- Re: Spawn Wishes (PCS Technical Support 1998)
- Spawn Wishes (Brian B. Burton 1998)
|
Other then my normal wishes for a $2500 program to understand if/then/elseand and/or statements...I think a little more time could be put into perfecting the spawn command.Don't get me wrong, the spawn command is a real lifesaver. However, I'mcurrently waiting for the damn server to finish a spawned process, becausespawned processes seem to get 100% CPU cycle time, and served pages get theshaft. I would really like the ability to set (or have preset) spawnedprocesses to 25% duty cycle, and leave the processor open to servingwebpages as speedy as possible. (I should mention that I am using webcat3,webstar3 on a Mac) Anyway, as I write this, I am sitting here waiting for a30 minute process to finish (updating a database of 4000 items with 40 sizefields per item out of a flat import file) Under a load of one to twoadditional surfers the webserver appears just plain slow (15 second delayto serve webcat processed pages) When I get 6 or 8 surfers the webserverstarts spitting out Gateway timed out messages. Also, although I need to have autocommit databases on (I use a lot oftracking databases and catalog request and email databases on my websites) Ithink there should be a way to turn it off for the databases involved in aspawned processes. In the above example, I take the active database, copy itto a new directory, modify the copy, then if the process is completedsuccessfully, I close the real database, replace it with the new, and openit. During the update, the server busily writes out the temp database to thehard drive (seemingly after every record) causing quite a delay while theupdate is taking place. Brian B. Burton BOFH - Department of Redundancy Department--------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.comAre you a Web Programmer?I am today.
Brian B. Burton
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:
Help! WebCat2 bug (1997)
logic help (1998)
FW: Shipping calculations (1997)
Why do extra quotation marks sometimes appear in my databases? (1998)
ODBC problems between webcat and filemaker pro (2001)
[WebDNA] Ubuntu 16.04.4 LTS (2018)
Date problems-more (1997)
Integration? (1999)
New Business Opportunity (2006)
Summing fields (1997)
Expanding the Product Database (2000)
Smart caching problems with 2.1b3? (1997)
[WebDNA] I'm stuck... :-( (2009)
[format xs] freeze (1997)
E-mailer error codes (1997)
OT: BulkRegister.com (2002)
WebCat cannot handle compatible search parameters? (1997)
Another question (1997)
database confused (2000)
same bill to and ship to? (1998)