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:
WebCat2 - [format thousands] (1997)
Listfiles (1998)
WebCatalog and Filemaker (1996)
detecting if var is blank? (2007)
[math] with first letter in field? (1997)
Fedora Core 3 and WebDNA (2005)
WebDNA on Windows questions (2007)
[delete] problem (1997)
Setting up WebCatalog with Retail Pro data (1996)
Databases going to sleep (1998)
2.0 Beta (1997)
Help! WebCat2 bug (1997)
[WebDNA] Just drop the Server version (2015)
WCS Newbie question (1997)
Webmerchant -> MacAuthorize ... please retry ? (1997)
Bug Report, maybe (1997)
includes and cart numbers (1997)
Help (1999)
Random ads (1998)
Not really WebCat (1997)