Subject Re: [firebird-support] Stored procedures vs. indexes
Author Martijn Tonies
Hello Pepak,

>>> Hmm, strange, as disconnecting all sessions should unload the database,
>>> unless it's busy with some kind of "sweep" or something, I'm not sure
>>> what
>>> it does then.
>>>
>>> It would be nice if you could check somehow, if you're the only one.
>>>
>>>
>> Easily done: The Firebird Server is blocked on the firewall so I know no
>> other computer than mine is connected to it remotely. I can't get local
>> connections to work on my Vista without using TCP/IP, so presumably
>> noone is connected through local protocol. "Nestat -an" shows that there
>> are no TCP/IP connections to Firebird port except for two in TIME_WAIT
>> state. I will see what happens when these two connections die complete -
>> maybe I am just too quick in running my application after an update.
>>
> Yep. I was too quick. When I let the connections die, the metadata got
> cleared. Problem solved.

Ah, that's good to know :-)


Glad I could help.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com