[WebDNA] Conversion of 500.000 records; advise needed

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101619
interpreted = N
texte = Hi all, I am running a web-forum built entirely using WebDNA. The forum contains more than 500.000 records or submissions to threads if you prefer and around 8 different databases which controls it's fundamentals. Now I need to make a conversion of some of the data within one of the main databases. I need to convert a WebDNA CART value to a 12 digit UTS (Unix Time Stamp). The reason is that I am not able to do a useful sort of a CART value within a [search] context and moreover it gives me the option of making a Function which extracts the TS to a "human" date and time format. Well, anyway the task is to convert 500.000 CART value to UTS. The code below seems to crash the server and seems very slow. I have never gone beyond approx.. 1.000 records with this code. Any help or advise is appreciated. ---- code ---- [search db=/forum/db/l4text.db&nel4_skudata=[blank]&AllReqd=T] [foundItems] [ReplaceFoundItems]latest_date=[format 12s][l4_sku][/format][/ ReplaceFoundItems] [/founditems] [/search] ---- code ---- PS. The site which runs the forum is located at: http://www.macnyt.dk/forum in case your are curious. Only registered members can write to the forum. Palle Bo Nielsen Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Conversion of 500.000 records; advise needed (Donovan Brooke 2008)
  2. Re: [WebDNA] Conversion of 500.000 records; advise needed (Palle Bo Nielsen 2008)
  3. Re: [WebDNA] Conversion of 500.000 records; advise needed (Palle Bo Nielsen 2008)
  4. RE: [WebDNA] Conversion of 500.000 records; advise needed ("Terry Nair" 2008)
  5. [WebDNA] Conversion of 500.000 records; advise needed (Palle Bo Nielsen 2008)
Hi all, I am running a web-forum built entirely using WebDNA. The forum contains more than 500.000 records or submissions to threads if you prefer and around 8 different databases which controls it's fundamentals. Now I need to make a conversion of some of the data within one of the main databases. I need to convert a WebDNA CART value to a 12 digit UTS (Unix Time Stamp). The reason is that I am not able to do a useful sort of a CART value within a [search] context and moreover it gives me the option of making a Function which extracts the TS to a "human" date and time format. Well, anyway the task is to convert 500.000 CART value to UTS. The code below seems to crash the server and seems very slow. I have never gone beyond approx.. 1.000 records with this code. Any help or advise is appreciated. ---- code ---- [search db=/forum/db/l4text.db&nel4_skudata=[blank]&AllReqd=T] [founditems] [replacefounditems]latest_date=[format 12s][l4_sku][/format][/ ReplaceFoundItems] [/founditems] [/search] ---- code ---- PS. The site which runs the forum is located at: http://www.macnyt.dk/forum in case your are curious. Only registered members can write to the forum. Palle Bo Nielsen 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:

Use of Back and Reload Buttons on ShoppingCart page? (1997) Who is doing sign-ups-got it (1998) Lookup Notfound (1998) RE: [WebDNA] Build Name for 6.1 (2008) Re:quit command on NT (1997) WebCatalog-NT?'s (1996) Can I invoke an ssi plugin from within a webcat page (1997) PCS Customer submissions ? (1997) RE: Help name our technology! (1997) [ListFiles] from a remote host (2003) Log-in Scheme (2003) WCS Newbie question (1997) WebCatalog2 Feature Feedback (1996) WebCatalog [FoundItems] Problem - AGAIN - (1997) Problems with ^ could be solved with [REPLACE CHARACTERS] (1997) emailer w/F2 (1997) New iMac, now ... how do I make webdna serve .html files? (2005) Email (1998) emailer (1997) Re2: AAgghh!! Help, please. SSL strikes again. (1997)