Drop Table faster of DeleteAllRecords ?

[Ruslan Zasukhin]

On 1/6/06 11:24 AM, "Dave Addey" <support at dj1800.com> wrote:

> ...to drop the tables (using the code from 1 above) takes 0.005 sec for
> PlaylistTracks, 0.22 sec for Tracks, and 0.13 sec for Playlists.
> ...to DeleteAllRecords (using the code from 4 above) takes 0.04 sec for
> PlaylistTracks, 1.61 sec for Tracks, and 0.06 sec for Playlists.
> 
> So, dropping is actually faster!  But maybe this is because of the bug?

DropTable is faster, because when you delete record by record, engine must
check constraints and links to delete may be linked records.

DropTable simply delete table, and I think do fast operation to zero links.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]