>>Hi all,
>>Every 2-3 weeks I load 0.5-1.5 million rec into server table and delete "expired" records. I delete records from server table using BCP+Fox solution (DROP INDEX for all of them, BCP the whole table (3-5 mln rec) out, APPEND FROM tblOld.txt FOR myConditions to Fox table, COPY TO tblNew.txt, TRUNCATE server table, BCP in, CREATE INDEX ).
>>It works good enough and using BCP+Fox I avoid transaction log nightmare that kills all SQL Server solutions I tried, but I am still interested in "Server only" solution and wondering how others deal with such problem.
>>TIA and Happy New Year!
>>Oleg
>
>Have you tried SQL Passthru?
>nhandle = sqlconnect("mydatasource")
>? sqlexec(nhandle, "Delete from mytable where expired")
>? sqldisconn(nhandle)
>
>I have no idea what the performance will be like, but it works pretty fast on SQL Anywhere.


It is acceptable if you delete 100,000, but for 1,000,000 takes forever plus transaction log headaches.
Thanks,
Oleg