changed the universe:> I went next door, and was talking to a programmer over there, and he said,> why not just find the unique values, and write them to a new database? A> simple rename, and poof! completed. I am going to try this next, but I am> wondering if there is a better way to do it inside the same database. I was> thinking of finding every record, sorting by email address, then comparing> the current record with the next record and if they match, deleting one of> them. I just don't know how to code that. Deleting records while stepping through a selection is not a good idea anyway. Better run through the selection and mark duplicates for later removal. But even comparing strings is nearly impossible without string variables unless you convert your email addresses to numerical values...The idea of your programmer is marvellous - finding unique values is a fast built-in function of WebCat! You have just to find out what is faster: adding the unique records to a new database or writing them with [appendfile] to the disk. First guess: adding via WebCat happens in memory, so it should be faster. But you'll have to find out, it depends on the current load on your server, which tasks are currently performed and so on...Again - string variables would be very helpful. For [appendfile] one could collect bunches of data and write them to disk at once. That makes some sort of finetuning possible, balancing cpu-load and disk-access...Peter__________________________________________Peter Ostry - po@ostry.com - www.ostry.comOstry & Partner - Ostry Internet SolutionsAuhofstrasse 29 A-1130 Vienna Austriafon ++43-1-8777454 fax ++43-1-8777454-21
Peter Ostry
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:
searchable list archive (1997)
[delete] problem (1997)
[WebDNA] Ubuntu and WebDNA (2019)
Crash Log Question (2006)
Some Advise needed (1997)
How true is this? (1999)
Using Currencies other than Dollars (1997)
email code (1998)
Protect (1997)
File Uploads: WebCat/SiteEdit (1998)
Date/Time format problems (1997)
Not really WebCat (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Wow .. (2003)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
WebCatalog and WebMerchant reviewed by InfoWorld (1997)
Upgrading old WebCat Database Files (1997)
Emailer pref's won't save (2005)
test (2000)
wierd crashes for multi-sendmails on NT (1997)