What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: Web requests in que...

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 69097
interpreted = N
texte = Please find the code below. Please ignore text and code within [!] and [/!] l4.db is 137.8MB and appox 20 fields l4_txt1 is a text string which can be quite long l4_sku is needed for relation l4_index is needed for future sorting .... and I do agree that WebDNA should be able to handle the task and even quite quick. But something is rotten here and I dont think its in the code. I have a bad feeling about the configuration of the server or the fact that something has gone wrong which calls for a re- install. ---- code ---- Split DB - 2007 [include file=/includes/admin_area_navigation.inc&raw=F] [!] [flushdatabases] [math]start=54598[/math] [/!] [search db=/forum/db/ l4.db&nel4_skudata=_dummy&rank=off&AllReqd=T&startat=[start]] [text]volume=[numFound][/text] [numFound][foundItems][numFound] [append db=/forum/db/l4_message.db&AUTONUMBER=l4_index]l4_message_sku= [url][l4_sku][/url]&l4_message_txt=[url][l4_txt1][/url][/append] [!] [/!] [!] [showif [index]\500] [shownext position=end&max=1] [redirect /admin/forumsplit/no2.tpl?start=[start]&doc1] [/shownext] [/showif] [/!] [/foundItems] [/search]
[index][l4_sku][l4_date][volume][format 50s][l4_txt1][/format] ...
---- code ---- On 20/06/2007, at 22.23, Donovan Brooke wrote: > Palle Bo Nielsen wrote: >> Hi all, >> While I'm cleaning my databases I got another question. >> Any good suggestions on how to fix this issue. >> HTTP request #1 arrives >> HTTP request #2 arrives >> HTTP request #3 arrives >> -- the execution of #2 and #3 will no start before #1 has ended. >> This is not normal procedure. Any good advise would be much >> appreciated. >> So let's say I start a db conversion using WebDNA and it's going >> through 150MB of data and parsing it etc. - a task which seems to >> take hours - then WebDNA will not accepts any other tasks while >> perming this current task. Looking at Activity Monitor it garbles >> up 160 Threads and approx. 50% of CPU and the machine ends up >> being rather slow. >> Mac OS X Server 10.4.9 (all updated) >> WebDNA 6.x >> Palle > > > Palle, I don't think it should take that long... lets see your > code! > > Donovan > > > > > -- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE EUCA Design Center > <- Web Development (specializing in eCommerce),-> > <- Desktop Publishing, Print Consulting, Labels -> > <-Glass Products, off-hand Classes/studio rental-> > PH:>(608) 835-2476 > TALK:>http://artglass-forum.com > WEB:> http://www.euca.us & http://www.egg.bz > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ > -- Venlig hilsen Palle B. Nielsen (PowerPalle) http://www.macnyt.dk/ iChat: powerpalle ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Web requests in que... ( Palle Bo Nielsen 2007)
  2. Re: Web requests in que... ( Donovan Brooke 2007)
  3. Re: Web requests in que... ( Clint Davis 2007)
  4. Re: Web requests in que... ( Palle Bo Nielsen 2007)
  5. Re: Web requests in que... ( Donovan Brooke 2007)
  6. Re: Web requests in que... ( Palle Bo Nielsen 2007)
  7. Re: Web requests in que... ( Donovan Brooke 2007)
  8. Re: Web requests in que... ( "Will Starck" 2007)
  9. Web requests in que... ( Palle Bo Nielsen 2007)
Please find the code below. Please ignore text and code within [!] and [/!] l4.db is 137.8MB and appox 20 fields l4_txt1 is a text string which can be quite long l4_sku is needed for relation l4_index is needed for future sorting .... and I do agree that WebDNA should be able to handle the task and even quite quick. But something is rotten here and I dont think its in the code. I have a bad feeling about the configuration of the server or the fact that something has gone wrong which calls for a re- install. ---- code ---- Split DB - 2007 [include file=/includes/admin_area_navigation.inc&raw=F] [!] [flushdatabases] [math]start=54598[/math] [/!] [search db=/forum/db/ l4.db&nel4_skudata=_dummy&rank=off&AllReqd=T&startat=[start]] [text]volume=[numFound][/text] [numFound][founditems][numFound] [append db=/forum/db/l4_message.db&AUTONUMBER=l4_index]l4_message_sku= [url][l4_sku][/url]&l4_message_txt=[url][l4_txt1][/url][/append] [!] [/!] [!] [showif [index]\500] [shownext position=end&max=1] [redirect /admin/forumsplit/no2.tpl?start=[start]&doc1] [/shownext] [/showif] [/!] [/foundItems] [/search]
[index][l4_sku][l4_date][volume][format 50s][l4_txt1][/format] ...
---- code ---- On 20/06/2007, at 22.23, Donovan Brooke wrote: > Palle Bo Nielsen wrote: >> Hi all, >> While I'm cleaning my databases I got another question. >> Any good suggestions on how to fix this issue. >> HTTP request #1 arrives >> HTTP request #2 arrives >> HTTP request #3 arrives >> -- the execution of #2 and #3 will no start before #1 has ended. >> This is not normal procedure. Any good advise would be much >> appreciated. >> So let's say I start a db conversion using WebDNA and it's going >> through 150MB of data and parsing it etc. - a task which seems to >> take hours - then WebDNA will not accepts any other tasks while >> perming this current task. Looking at Activity Monitor it garbles >> up 160 Threads and approx. 50% of CPU and the machine ends up >> being rather slow. >> Mac OS X Server 10.4.9 (all updated) >> WebDNA 6.x >> Palle > > > Palle, I don't think it should take that long... lets see your > code! > > Donovan > > > > > -- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE EUCA Design Center > <- Web Development (specializing in eCommerce),-> > <- Desktop Publishing, Print Consulting, Labels -> > <-Glass Products, off-hand Classes/studio rental-> > PH:>(608) 835-2476 > TALK:>http://artglass-forum.com > WEB:> http://www.euca.us & http://www.egg.bz > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ > -- Venlig hilsen Palle B. Nielsen (PowerPalle) http://www.macnyt.dk/ iChat: powerpalle ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Palle Bo Nielsen

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:

WebCat2b13 Command Reference Doc error (1997) [append] problem (1997) customizing the color of user's pages (1997) Mime Headers for Mail (1998) Mac Webcat 3.0.3b1 memory leak redirect inside search (1998) Setheader question (1999) Possible Bug in 2.0b15.acgi (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) WebTen and WebCat (1997) Automatic Forwarding using WebCat (1997) Is there a max number of fields? (1998) Grant, please help me ... (1997) back button loses cart (2000) Secure Server (1997) [WebDNA] Range calculation w/negative values (2011) Fun with dates (1997) EIMS Problems (1997) New global preference ... ??? (2000) [WebDNA] Capitalize surprise (2012) Car Database (2002)