Execution of individual tests takes too long

[darrencomeau]

Each test execution will take ~ 1 second in one project.

This is too long, can the performance be improved?

[darrencomeau]

Found a significant speed improvement by removing the ClearTable method from a test framework hook script. (previous 4min execution takes 20 seconds)

Used the ExecuteStatementWithoutResult method and a simple delete statement instead.

Profiler showed some excessive queries against metadata

[darrencomeau]

Updated the method to remove object existence checking and metadata check for foreign key constraint, instead attempting a truncate and reverting to a delete if an error is raised.