Re: [WebDNA] Conversion of 500.000 records; advise needed
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101622
interpreted = N
texte = Hey Terry, The removal of the [foundiems] tag actually did the trick. All is converted now. It took no time. [foundtems] tags actually delayed the unction significantly. 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:
Hey Terry, The removal of the [foundiems] tag actually did the trick. All is converted now. It took no time. [foundtems] tags actually delayed the unction significantly. 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:
Math Context (2001)
Quotes about Computer Languages (2004)
Upgrading old WebCat Database Files (1997)
WebCatalog Features (1997)
Download Question (1997)
[WebDNA] Setting Content-Type within [returnraw] - not working on (2010)
Pre-parse hell (2008)
2.0 Info (1997)
auction system w/ Web Cat (1999)
Support suggestions - Response (2000)
can we get string variables? (1998)
[WebDNA] On click show hidden include (2009)
WebCat2b12--[searchstring] bug (1997)
categorys (1998)
sort problems....bug or brain fart? (1997)
WebDNA on Intel Mac? (2006)
New NT beta available (1997)
multiple skus (2000)
Applying discounts as more items are added... (1997)
all records returned. (1997)