Subject | Re: Firebird in Windows XP |
---|---|
Author | xpmikes <mike@computersurgery.com> |
Post date | 2003-01-23T16:37:20Z |
Hi Jason
Thanks for your input. I checked and see the same behaviour: as long
as there is another connection to the same DB, the disconnect is
instantaneous, but there's about a 1.5 sec delay introduced on the
connection :-(
However, since we're recreating the DB from scratch each time our
unit tests run, it's not possible to have a permanent connection to
it.
The only alternative would be to drop every non-system object in the
DB and then run our create script, instead of deleting the DB file.
Do you know if there exists such a sample script, that would drop
all constraints, indexes, tables, domains, etc. and leave the DB
completely empty, apart from system tables?
Cheers,
Mike.
Thanks for your input. I checked and see the same behaviour: as long
as there is another connection to the same DB, the disconnect is
instantaneous, but there's about a 1.5 sec delay introduced on the
connection :-(
However, since we're recreating the DB from scratch each time our
unit tests run, it's not possible to have a permanent connection to
it.
The only alternative would be to drop every non-system object in the
DB and then run our create script, instead of deleting the DB file.
Do you know if there exists such a sample script, that would drop
all constraints, indexes, tables, domains, etc. and leave the DB
completely empty, apart from system tables?
Cheers,
Mike.