Re: Duplicates

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17760
interpreted = N
texte = Brian B. Burton 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.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] prevent database duplicates (Stephen Braun 2019)
  2. Re: [WebDNA] prevent database duplicates (Stuart Tremain 2019)
  3. Re: [WebDNA] prevent database duplicates (Alex Mccombie 2019)
  4. [WebDNA] prevent database duplicates (Stephen Braun 2019)
  5. Re: [WebDNA] [sendmail] random duplicates (Donovan Brooke 2010)
  6. Re: [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
  7. Re: [WebDNA] [sendmail] random duplicates (Tom Duke 2010)
  8. Re: [WebDNA] [sendmail] random duplicates (Stuart Tremain 2010)
  9. Re: [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
  10. Re: [WebDNA] [sendmail] random duplicates (Tom Duke 2010)
  11. [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
  12. Re: Find Duplicates in Cart (John Peacock 2001)
  13. Re: Find Duplicates in Cart (Clint Davis 2001)
  14. Re: Find Duplicates in Cart (John Peacock 2001)
  15. Find Duplicates in Cart (Clint Davis 2001)
  16. How to find duplicates - With code samples (Brian B. Burton 2000)
  17. Re: Deleting duplicates from a db (Matt Helbing 2000)
  18. Re: Deleting duplicates from a db (Michael O Shea 2000)
  19. Deleting duplicates from a db (Will Starck 2000)
  20. Re: WHY SO MANY DUPLICATES? (Martin Bech 1999)
  21. WHY SO MANY DUPLICATES? (The Mooseman 1999)
  22. WHY SO MANY DUPLICATES? (The Mooseman 1999)
  23. Re: Duplicates (Kenneth Grome 1998)
  24. Re: Duplicates (Brian B. Burton 1998)
  25. Re: Duplicates (Dave MacLeay 1998)
  26. Re: Duplicates (Brian B. Burton 1998)
  27. Re: Duplicates (Kenneth Grome 1998)
  28. Re: Duplicates (Peter Ostry 1998)
  29. Re: Duplicates (Brian B. Burton 1998)
  30. Re: Duplicates (Kenneth Grome 1998)
  31. Duplicates (Brian B. Burton 1998)
Brian B. Burton 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.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++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)