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:
variables in template (2000)
RE: problem with applets embedded in tpl files (1997)
Triggers (1999)
Getting Emailer to send mail (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
Wanted: Broader string manipulation functions (1997)
WC2b15 File Corruption (1997)
Not really WebCat (1997)
Separate SSL Server (1997)
duplicate items in cart (1998)
Showing Results Alphabetically in Columns (top to bottom) (2002)
lookups (2000)
real beginner stumped (2000)
[WebDNA] Quick test (2008)
Practice runs ? (1997)
search form problem.. (1997)
Discount solution? (1998)
Date search bug (1998)
How to show via drop down menu? (2000)
ANother SHOWIF problem (1997)