RE: [WebDNA] Conversion of 500.000 records; advise needed
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101620
interpreted = N
texte = Hi Palle, You may like to take note that when using ReplaceFoundItems within the Search tag, there is no need to use the FoundItems tag. This could help speed things up ...;-) Cheers Terry Nair -----Original Message----- From: Palle Bo Nielsen [mailto:powerpalle@powerpalle.dk] Sent: Monday, December 15, 2008 03:41 To: talk@webdna.us Subject: [WebDNA] Conversion of 500.000 records; advise needed 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 --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us old archives: http://dev.webdna.us/TalkListArchive/
Associated Messages, from the most recent to the oldest:
Hi Palle, You may like to take note that when using ReplaceFoundItems within the Search tag, there is no need to use the FoundItems tag. This could help speed things up ...;-) Cheers Terry Nair -----Original Message----- From: Palle Bo Nielsen [mailto:powerpalle@powerpalle.dk] Sent: Monday, December 15, 2008 03:41 To: talk@webdna.us Subject: [WebDNA] Conversion of 500.000 records; advise needed 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 --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us old archives: http://dev.webdna.us/TalkListArchive/
"Terry Nair"
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:
[WebDNA] Installing 6.0 onto Server 2008 (2011)
possible, WebCat2.0 and checkboxes-restated (1997)
A Current Feature or Futre Concept (1998)
Thanks ! (1997)
Can't add a field (1998)
convert characters (2003)
two questions (1997)
WebCat2 beta 11 - new prefs ... (1997)
TCPConnect to query for Domain expiration (2000)
Re:I've had it! (1999)
WebCatalog can't find database (1997)
[shippingtotal] Fixed... (2002)
Sense/Disallow HTML tags during $Append (1997)
Got WebCat buyer's remorse? (1998)
Discount solution? (1998)
WebCatalog can't find database (1997)
Text limits in NT version? (1997)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
shipcost (1997)
[username][password] not showing up! HELP! (1999)