I have a database 40GB, a table Name is T1 with 70 columns and 1000000 records,
I run isql command:
connect database 'localhost:/db/db.fdb' user 'sysdba' password 'masterkey';
update set T1 set Column1=0;
the 2nd Statement run with IBExpert is ok, waste time 2 minute. In this case,
after 2 minute(and more time), isql can't get back to SQL> prompt.
I change 1st Statement to "connect database '/db/db.fdb' user 'sysdba' password
'masterkey';" everything is ok. I test the db without automatic garbage
collection, this problem same: gfix -sweep /db/db.fdb
gfix -h 0 /db/db.fdb isql SQL>connect database 'localhost:/db/db.fdb' user
'sysdba' password 'masterkey'; SQL>update set T1 set Column1=0; then can't back
to "SQL>"
