[D. Richard Hipp wrote:] >But that gives me an idea. If you need to delete an >entire table quickly, why not put that one table in a >separate database and ATTACH it. Then when you want >to erase it all, DETACH the separate database, delete >the file, then reinitialize the database and re-ATTACH >it.
Yes, this is what I was thinking of doing. In my design, I've already spread the tables across several files for multithreading and performance reasons, and attach as needed, so this should work nicely. Thanks again. -Randy
