Subject | Re: [firebird-support] Stored procedures vs. indexes |
---|---|
Author | Martijn Tonies |
Post date | 2009-11-27T09:04:44Z |
Hello Pepak,
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
>>> Hmm, strange, as disconnecting all sessions should unload the database,Ah, that's good to know :-)
>>> 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.
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