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:
Addlineitems ... grrr (2004)
Order not created error (never mind) (1997)
.. more on sliding discounts... (1997)
Site Builder & IE Mac (2004)
[WebDNA] PDF creation (2013)
New WebDNA Solutions ... (1997)
[WebDNA] a major shift in strategy? (2008)
Fw: html pages not working (2003)
Bit off subject -- Faxing orders (1997)
Support ?? (1997)
Cart Number Propagation (1997)
Mac: LModelDirector bug fix (1997)
calculating tax rates, mail order solutions and version 2 (1997)
Displaying raw values (long) (1998)
WC 4.02rc2/WebStar (2001)
2.0 Beta (1997)
a little help w/ this .debug error (2000)
search engine friendly URLS (Mac) and Lycos! (1998)
TCPCONNECT (2004)
[WebDNA] total (2010)