Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

On Fri, 04 May 2018 14:10:40 -0400 blackfalconsoftw...@outlook.com [firebird-support] firebird-support@yahoogroups.com wrote I am hoping to begin writing a technical article soon that will introduce database application developers to these idiosyncrasies who are new to Firebird,

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

On 2018-05-04 20:10, blackfalconsoftw...@outlook.com [firebird-support] wrote: > I must admit that I have spent many years working with various > database engines, with SQL Server being the engine where the large > majority of my professional development had been emphasized. > Nonetheless, I have

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

04.05.2018 20:10, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Nonetheless, I have worked with Oracle, Sybase, MySQL, and a little > PostgreSQL and SQLite. I can't believe that you never looked at Oracle's FOR LOOP syntax in pipelined functions which difference from Firebird

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

Thank you, Mark, for clearing up my misunderstanding.  When I found some sample code on StackOverflow that demonstrated the use of the "FOR-DO" construct, I realized what I had misunderstood. I believe I sent you an email that suggested my correction to my understanding of this

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

On 2018-05-04 18:56, blackfalconsoftw...@outlook.com [firebird-support] wrote: > I am not sure if I understand your explanation here... > > 1... > Why would I test the input parameter, "PI_KEY_IN" for each row? I am > only doing this to ensure that the client never sends an input value > of

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

I am not sure if I understand your explanation here... 1... Why would I test the input parameter, "PI_KEY_IN" for each row? I am only doing this to ensure that the client never sends an input value of zero(0). 2... In the other email you sent you stated that... "A FOR .. DO is a loop

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

On 4-5-2018 18:31, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > How so?  The "SUSPEND" statement is the last statement in the procedure > or are you referring to the fact that it is continued as a result of the > previous "DO" statement? A FOR .. DO is a loop

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

How so? The "SUSPEND" statement is the last statement in the procedure or are you referring to the fact that it is continued as a result of the previous "DO" statement? Steve From: firebird-support@yahoogroups.com on

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

04.05.2018 18:13, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > If you look at my procedure below, you will note that there is only a single > "SUSPEND" > statement. If you look a little more, you'll see that it is called in a loop. -- WBR, SD.

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

On 4-5-2018 18:13, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > However, I am not sure about the multiple "SUSPEND" statements on a > per-record basis. > > If you look at my procedure below, you will note that there is only a single > "SUSPEND" statement. Yet,

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

Dimitry ... Thank you for your reply...  However, I am not sure about the multiple "SUSPEND" statements on a per-record basis. If you look at my procedure below, you will note that there is only a single "SUSPEND" statement. Yet, all of the rows for the entered date that is used to

Re: [firebird-support] What regular maintenance actions does Firebird need in order to function properly?

What I mean is this: I want to know if a need to increment the page cache buffer of Firebird. And If was thinking of having some metric to measure it.  This metric would be very convinient If I need for example to justify buying more memory for the server. Thanks in advance. 

Re: [firebird-support] Create a table from Query

04.05.2018 14:04, antoedinchar...@gmail.com [firebird-support] wrote: > Is there any way we could create a table in Firebird using the query? No. Firebird cursors (implicit and explicit) are more powerful than MS SQL's ones and let developers avoid local temporary tables completely. --

[firebird-support] Create a table from Query

Hello, Is there any way we could create a table in Firebird using the query? Ex:- create table temptable as select * from tempquerytable t1, tempquery t2 where t1.slno = t2.slno; this creates a table temptable with the structure of both t1 Thanks and Regards

Re: [firebird-support] [FB3 CS] Server stops accepting new connections - lock denied

Hallo Franco, I had quite similar problem around 5th December 2017, try to search "lock denied" around that date. In my case it helped to switch to SuperServer mode. (It required to change some SW to use the "TCP/IP" mode instead of the "file" access.) I remember that I promised that I would

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

04.05.2018 11:42, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote: > the single badly designed query with many page fetches can "improve" this > parameter a lot, > without any real improvement in the performance, of course. The question was about cache effectiveness which is always

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

I am totally agree with Mark. Ratio of page reads/page fetches for all queries has a little sense. For example, the single badly designed query with many page fetches can "improve" this parameter a lot, without any real improvement in the performance, of course. Regards, Alexey Kovyazin

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

On 3-5-2018 15:52, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > > > Thank you very much! You shouldn't focus purely on this metric, greater page caches may lead to more pages returned from memory, but also increase memory consumption and overhead from things like cache

Re: [firebird-support] What regular maintenance actions does Firebird need in order to function properly?

04.05.2018 4:55, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > what other regular maintenance actions does Firebird need in order to > function properly? It may be a good idea to recalculate index statistics from time to time. -- WBR, SD.

Re: [firebird-support] What regular maintenance actions does Firebird need in order to function properly?

Hello, We recommend perform at least everyday sweep - with disconnect of long running active writeable transactions before it. Can you please clarify what do you mean by > measuring the effectiveness of the page cache ? Regards, Alexey Kovyazin IBSurgeon www.ib-aid.com On 04.05.2018