[firebird-support] Re: split or not split a table with long rows ?

2012-03-22 Thread nathanelrick
Thanks Dmitry, Memory is cheap, just buy it. i was speaking of more than 128GB of memory :) About splitting table I have an opinion: if some rows are being accessed more than other, than split table. This will - make row size less for most reading rows - make less pages for most reading

Re: [firebird-support] Assign Double Precision value to a varchar field in Stored Procedure

2012-03-22 Thread Milan Babuskov
Ivy wrote: 1) I have a double precision variable ( e.g. myMoney ) which after some calculation, it ends up with figure -0.0199868555. 2) When I want to assign this value to a varchar field ( e.g. MoneyInStr) , I do the below statement :- MoneyInStr = myMoney; What are the types of

[firebird-support] fb_inet_server.exe -h switch?

2012-03-22 Thread Kjell Rilbe
Hi, In Task manager I see multiple instances of fb_inet_server.exe, as expected (classic server). What I'm wondering is what the command line switches mean. I see all of them have -i except the default instance. What does it mean? More importantly I see they have -h N, where N is for instance

[firebird-support] fb_inet_server hangs?

2012-03-22 Thread Kjell Rilbe
Hi, On occasion, it seems that one of the fb_inet_server processes hangs. Are there any known issues that would cause a hang? Classic 2.1.3.18185 64 bit on Windows Server 2008 64 bit web edition. This is an ASP.Net application and I connect using the Firebird .Net provider version 2.6.5.

Re: [firebird-support] fb_inet_server.exe -h switch?

2012-03-22 Thread Kjell Rilbe
Thomas Steinmaurer skriver: In Task manager I see multiple instances of fb_inet_server.exe, as expected (classic server). What I'm wondering is what the command line switches mean. [snip] More importantly I see they have -h N, where N is for instance 484 and 492. What does -h and

Re: [firebird-support] fb_inet_server hangs?

2012-03-22 Thread Thomas Steinmaurer
Hello Kjell, On occasion, it seems that one of the fb_inet_server processes hangs. Are there any known issues that would cause a hang? Yes, that can happen from time to time. As you are on 2.1.3, e.g. the list of fixed bugs in 2.1.4 show some evidence that things do improve with each

Re: [SPAM 4] Re: [firebird-support] fb_inet_server hangs?

2012-03-22 Thread Helen Borrie
At 04:02 AM 23/03/2012, Kjell Rilbe wrote: Thomas Steinmaurer skriver: Hello Kjell, On occasion, it seems that one of the fb_inet_server processes hangs. Are there any known issues that would cause a hang? Yes, that can happen from time to time. As you are on 2.1.3, e.g. the list of

Re: [firebird-support] fb_inet_server hangs?

2012-03-22 Thread Kjell Rilbe
Helen Borrie skriver: At 04:02 AM 23/03/2012, Kjell Rilbe wrote: Thomas Steinmaurer skriver: On occasion, it seems that one of the fb_inet_server processes hangs. Are there any known issues that would cause a hang? Yes, that can happen from time to time. As you are on 2.1.3, e.g.

Re: [SPAM 4] Re: [firebird-support] fb_inet_server hangs?

2012-03-22 Thread Thomas Steinmaurer
Thomas Steinmaurer skriver: Hello Kjell, On occasion, it seems that one of the fb_inet_server processes hangs. Are there any known issues that would cause a hang? Yes, that can happen from time to time. As you are on 2.1.3, e.g. the list of fixed bugs in 2.1.4 show some evidence that

Re: [firebird-support] fb_inet_server hangs?

2012-03-22 Thread Helen Borrie
At 07:57 AM 23/03/2012, Kjell Rilbe wrote: Helen Borrie skriver: At 04:02 AM 23/03/2012, Kjell Rilbe wrote: Thomas Steinmaurer skriver: On occasion, it seems that one of the fb_inet_server processes hangs. Are there any known issues that would cause a hang? Yes, that can happen from

Re: [firebird-support] fb_inet_server hangs?

2012-03-22 Thread Kjell Rilbe
Helen Borrie skriver: The Guardian should not be installed at all for Classic.[snip long informative text] Many thanks Helen! And here I was, thinking I knew what the guardian was all about... :-) Kjell -- -- Kjell Rilbe DataDIA AB E-post:

Re: [firebird-support] Garbage collection performance issues ????

2012-03-22 Thread Michael Ludwig
Robert martin schrieb am 21.03.2012 um 15:18 (+1300): We have noticed performance issues on a machine running a web service connected to a FB 2.5 database. On a brand new machine (to rule out computer problems) everything worked fine for the first few hours, however after deleting a large

Re: [firebird-support] Garbage collection performance issues ????

2012-03-22 Thread Robert martin
Wow. Thanks for your extensive reply. My code if very transaction centric in this particular app. All transactions are manual and as short as possible so I hadn't really considered that to be the issue. I have just checked the database which has been running for the last couple of days and

Re: [firebird-support] Assign Double Precision value to a varchar field in Stored Procedure

2012-03-22 Thread Ivy
Hi, The DECLARE VARIABLE statements are shown below :- 1) DECLARE VARIABLE Double Precision; 2) DECLARE VARIABLE MoneyInStr Varchar(50); ivy. - Original Message - From: Milan Babuskov To: firebird-support@yahoogroups.com Sent: Thursday, March 22, 2012 7:00 PM Subject:

Re: [firebird-support] Assign Double Precision value to a varchar field in Stored Procedure

2012-03-22 Thread Ivy
Hi, The DECLARE VARIABLE statements are shown below :- 1) DECLARE VARIABLE myMoney Double Precision; 2) DECLARE VARIABLE MoneyInStr Varchar(50); ivy. - Original Message - From: Ivy To: firebird-support@yahoogroups.com Sent: Friday, March 23, 2012 11:18 AM Subject: Re:

[firebird-support] Re: fb_inet_server.exe -h switch?

2012-03-22 Thread Dmitry Yemanov
23.03.2012 8:28, Dmitry Yemanov wrote: Yes, it's expected to be unique. If it's duplicated, this could mean a zombie process for an already closed port that has its socket handle reused for another connection. Just a guess. Or you restarted the listener and some processes launched by the