Hi Thomas,

>You did not mention if the data found in the example allows switching over to checking for the first blank.
>If the stuff/at combo is faster than strtran(), depending on the possible values of vorname this should
>give you another few millisecs.

I'm not sure what exactly you're talking of here.


> But for another small speedup skip indexing to cdx and instead use an old compressed idx.

I tried INDEX ON...TO (idx_file) COMPACT UNIQUE. While theoretically this could be faster the difference is not measurable.


>One thing to try out is to rearrange the fields used to create the unique index putting Hausnummer and PLZ first

0.1 seconds (of about 17 seconds for this command) less than before. You see that removing the duplicates is still by far the most time consuming task.


>The question is IMHO to find a way to skip writing table1a while still utilizing the unique index.

I don't think that's the point. The creation of Table1a takes about 0.5 seconds, the creation of Table2 takes even less (about 0.2 seconds). ;-)


BTW, while rearranging the fields in the INDEX ON command one more idea came to my mind. I checked the maximum length of the different strings in the CSV file and adjusted the field lengths of Table1. This helped the INDEX ON run faster. It cut down overall execution time by another 6 seconds. Resulting execution time is about 15 seconds :-))) (with 11 seconds used up by INDEX ON).

CREATE TABLE _FOLDER_ + "Table1" FREE ( ;
  Vorname C(11), ;
  Name C(11), ;
  Strasse C(21), ;
  HausNr C(3), ;
  PLZ C(7), ;
  Ort C(18), ;
  eMail C(38) )

Markus