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 hilsenPalle 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:

Re: Web requests in que... ( Palle Bo Nielsen 2007)
Re: Web requests in que... ( Donovan Brooke 2007)
Re: Web requests in que... ( Clint Davis 2007)
Re: Web requests in que... ( Palle Bo Nielsen 2007)
Re: Web requests in que... ( Donovan Brooke 2007)
Re: Web requests in que... ( Palle Bo Nielsen 2007)
Re: Web requests in que... ( Donovan Brooke 2007)
Re: Web requests in que... ( "Will Starck" 2007)
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]