Re: [WebDNA] Conversion of 500.000 records; advise needed
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101621
interpreted = N
texte = Ah, okay - first time I've used this replacefounditems tag. Anyway is it at all realistic to change 500.000 records in one go or should I segment the effort? Palle On 14/12/2008, at 22.42, Terry Nair wrote: > 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/ > > --------------------------------------------------------- > 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/ > Venlig hilsen Palle Bo Nielsen (PowerPalle)
Associated Messages, from the most recent to the oldest:
Ah, okay - first time I've used this replacefounditems tag. Anyway is it at all realistic to change 500.000 records in one go or should I segment the effort? Palle On 14/12/2008, at 22.42, Terry Nair wrote: > 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/ > > --------------------------------------------------------- > 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/ > Venlig hilsen Palle Bo Nielsen (PowerPalle)
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:
Dubble Sku's in a Database (1999)
[WebDNA] search command problem (2009)
problems with 2 tags (1997)
small hairball -- stuck on [showif] for related db (1998)
[if] and [showif] - A solution (2002)
[listfiles] (2004)
Expiration of Carts (1997)
Help with ShowNext (1998)
Price Change (2000)
Searching Dates (2000)
stray LF character in the email (2003)
Emailer or [sendmail] questions ... (1998)
[WebDNA] How to code a 301 redirect (2008)
Date Formats (1997)
Sales Tax db (1998)
[WebDNA] [OT] Apple iPad (2010)
New syntax feedback for 4.0 (2000)
WebCatalog not running after upgrade (2000)
HELP WITH DATES (1997)
'0' vs. blank (2005)