maverickthunder wrote:

> Also, I downloaded Firebird Maestro to try it and it has an option to
> run queries in a separate thread. If that option is enabled, queries
> takes too much time. E.g. deleting all records from a table (about
> 5,000) using DELETE without a where clause, in main thread version it
> lasts 5 seconds... in the separate thread version, it took 20
> minutes!!

Maybe it's a bug in Maestro (doesn't use a separate connection for each
thread, doesn't set the appropriate isolation so maybe it deadlocks many
times, who knows...).

Any other tool that I know has multi-threading is Database Workbench
(www.upscene.com). Maybe you should try with that to see whether this is
really an issue with Firebird or with the tool you're using.

HTH

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com