[firebird-support] Doubts regarding statistics of indexes and tables...

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2

In firebird, how do you calculate statistics to feed the query optimizer? 

Note: I know that the command: 'set statistics index ;' calculate 
statistics for indexes, but what about tables for example?

And my second question:
is there any way to backup the statistics before recalculate them?
Note: This backup can be very useful if the new statistics create a performance 
problem
Thanks in advance for your help

Re: [firebird-support] Article for experienced developers looking learn the Firebird Database

[blackfalconsoftw...@outlook.com [firebird-support]]

Thank you, Karol...
 

 I'll take your information and update the article's section on views...
 

 With warm regards,
 Steve

Re: [firebird-support] Article for experienced developers looking learn the Firebird Database

['livius' liviusliv...@poczta.onet.pl [firebird-support]]

One more words:

about views – this is not true that this is redundant to SP.
Views are totally different objects. 
Views can be optimized by Firebird if you join with it with other tables or 
other views 
(with one exception if view contain order by).
Stored procedure work in the different way.
Also you can have trigers on views to make it editable or take different actions
look here:
https://firebirdsql.org/refdocs/langrefupd21-ddl-view.html

Also it is simple then to manage privileges.
Other difference – stored procedures are executed as LATERAL JOIN if you join 
table with procedure.

regards,
Karol Bieniaszewski



From: 'livius' liviusliv...@poczta.onet.pl [firebird-support] 
Sent: Friday, May 11, 2018 5:47 PM
To: firebird-support@yahoogroups.com 
Subject: Re: [firebird-support] Article for experienced developers looking 
learn the Firebird Database

  

Hi,

article is quite good but the title is something like someone should not try to 
read it..

regards,
Karol Bieniaszewski

From: blackfalconsoftw...@outlook.com [firebird-support] 
Sent: Friday, May 11, 2018 4:52 PM
To: firebird-support@yahoogroups.com 
Subject: [firebird-support] Article for experienced developers looking learn 
the Firebird Database

  

For many years I have been tracking the development of the Firebird Database 
Engine and have watched it move from its 1.5 version to its most recent 
release, version 3.0.3.





On a number of occasions I have attempted to work with this database engine..  
And though I have many years of extensive database application development with 
quite a few database engines, Firebird always seem to allude my attempts at 
mastering it.  





>From major to minor "gotchas" from a lack of good introductory documentation 
>regarding the many differences between this database engine and its many 
>contemporaries, which more or less towed a standardized SQL line, even with 
>the many enhancements made to any one engine, Firebird frustrated my efforts 
>to the point on these occasions where I decided the efforts in learning it 
>were simply not justified .





Nonetheless, Firebird still beckoned as mastering it was an accomplishment I 
still wanted to achieve.  As a result, seeing the mostly negative aspects of 
using Microsoft's SQL Server LocalDB for a desktop application I have been 
developing, I decided to "bite the bullet" and somehow find a way to teach 
myself Firebird in order take advantage of its excellent embedded engine also 
known as the Firebird Embedded Server.





The result of this endeavor, which has been very successful so far, is a 
detailed article that attempts to make it much easier for experienced 
professionals to learn Firebird who also, like I, have many years of 
development experience with other database engines.  The article points out the 
many differences when using this engine for scripting within query and action 
screen s in a db-manager or creating database modules with Firebird PSQL that 
can drive even experienced professionals to the point of distraction.  
Hopefully, my experiences will help such professionals who want to master 
Firebird as well a much easier learning experience.





The article can be found at the following link for everyone's review...




https://blackfalconsoftware.wordpress.com/2018/05/11/the-firebird-database-engine-the-frustrations-of-the-long-distance-database-application-developer/




Admittedly, there may be some mistakes in this piece since it was developed 
around my own learning experiences with this database engine. p; As a 
result, if anyone has any comments, corrections, or suggestions please let me 
know at my email address...  blackfalconsoftw...@outlook.com




In addition, if anyone would like a PDF copy of this piece, please let me know 
as well and I will prepare one and send it out...

Re: [firebird-support] Article for experienced developers looking learn the Firebird Database

['livius' liviusliv...@poczta.onet.pl [firebird-support]]

Hi,

article is quite good but the title is something like someone should not try to 
read it..

regards,
Karol Bieniaszewski

From: blackfalconsoftw...@outlook.com [firebird-support] 
Sent: Friday, May 11, 2018 4:52 PM
To: firebird-support@yahoogroups.com 
Subject: [firebird-support] Article for experienced developers looking learn 
the Firebird Database

  

For many years I have been tracking the development of the Firebird Database 
Engine and have watched it move from its 1.5 version to its most recent 
release, version 3.0.3.





On a number of occasions I have attempted to work with this database engine..  
And though I have many years of extensive database application development with 
quite a few database engines, Firebird always seem to allude my attempts at 
mastering it.  





>From major to minor "gotchas" from a lack of good introductory documentation 
>regarding the many differences between this database engine and its many 
>contemporaries, which more or less towed a standardized SQL line, even with 
>the many enhancements made to any one engine, Firebird frustrated my efforts 
>to the point on these occasions where I decided the efforts in learning it 
>were simply not justified .





Nonetheless, Firebird still beckoned as mastering it was an accomplishment I 
still wanted to achieve.  As a result, seeing the mostly negative aspects of 
using Microsoft's SQL Server LocalDB for a desktop application I have been 
developing, I decided to "bite the bullet" and somehow find a way to teach 
myself Firebird in order take advantage of its excellent embedded engine also 
known as the Firebird Embedded Server.





The result of this endeavor, which has been very successful so far, is a 
detailed article that attempts to make it much easier for experienced 
professionals to learn Firebird who also, like I, have many years of 
development experience with other database engines.  The article points out the 
many differences when using this engine for scripting within query and action 
screen s in a db-manager or creating database modules with Firebird PSQL that 
can drive even experienced professionals to the point of distraction.  
Hopefully, my experiences will help such professionals who want to master 
Firebird as well a much easier learning experience.





The article can be found at the following link for everyone's review...




https://blackfalconsoftware.wordpress.com/2018/05/11/the-firebird-database-engine-the-frustrations-of-the-long-distance-database-application-developer/




Admittedly, there may be some mistakes in this piece since it was developed 
around my own learning experiences with this database engine. p; As a 
result, if anyone has any comments, corrections, or suggestions please let me 
know at my email address...  blackfalconsoftw...@outlook.com




In addition, if anyone would like a PDF copy of this piece, please let me know 
as well and I will prepare one and send it out...

RE: [firebird-support] Article for experienced developers looking learn the Firebird Database

['Live.com Email' emendez...@nc.rr.com [firebird-support]]

Thank you. I am always looking for additional Firebird information. 

 

-Edward Mendez

 

From: firebird-support@yahoogroups.com  
Sent: Friday, May 11, 2018 10:53 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Article for experienced developers looking learn 
the Firebird Database

 

  

For many years I have been tracking the development of the Firebird Database 
Engine and have watched it move from its 1.5 version to its most recent 
release, version 3.0.3.

 

On a number of occasions I have attempted to work with this database engine..  
And though I have many years of extensive database application development with 
quite a few database engines, Firebird always seem to allude my attempts at 
mastering it.  

 

>From major to minor "gotchas" from a lack of good introductory documentation 
>regarding the many differences between this database engine and its many 
>contemporaries, which more or less towed a standardized SQL line, even with 
>the many enhancements made to any one engine, Firebird frustrated my efforts 
>to the point on these occasions where I decided the efforts in learning it 
>were simply not justified.

 

Nonetheless, Firebird still beckoned as mastering it was an accomplishment I 
still wanted to achieve.  As a result, seeing the mostly negative aspects of 
using Microsoft's SQL Server LocalDB for a desktop application I have been 
developing, I decided to "bite the bullet" and somehow find a way to teach 
myself Firebird in order take advantage of its excellent embedded engine also 
known as the Firebird Embedded Server.

 

The result of this endeavor, which has been very successful so far, is a 
detailed article that attempts to make it much easier for experienced 
professionals to learn Firebird who also, like I, have many years of 
development experience with other database engines.  The article points out the 
many differences when using this engine for scripting within query and action 
screens in a db-manager or creating database modules with Firebird PSQL that 
can drive even experienced professionals to the point of distraction.  
Hopefully, my experiences will help such professionals who want to master 
Firebird as well a much easier learning experience.

 

The article can be found at the following link for everyone's review...

 

https://blackfalconsoftware.wordpress.com/2018/05/11/the-firebird-database-engine-the-frustrations-of-the-long-distance-database-application-developer/

 

Admittedly, there may be some mistakes in this piece since it was developed 
around my own learning experiences with this database engine.  As a result, if 
anyone has any comments, corrections, or suggestions please let me know at my 
email address...  blackfalconsoftw...@outlook.com 
 

 

In addition, if anyone would like a PDF copy of this piece, please let me know 
as well and I will prepare one and send it out...

[firebird-support] Article for experienced developers looking learn the Firebird Database

[blackfalconsoftw...@outlook.com [firebird-support]]

For many years I have been tracking the development of the Firebird Database 
Engine and have watched it move from its 1.5 version to its most recent 
release, version 3.0.3.

 

 On a number of occasions I have attempted to work with this database engine.  
And though I have many years of extensive database application development with 
quite a few database engines, Firebird always seem to allude my attempts at 
mastering it.  

 

 From major to minor "gotchas" from a lack of good introductory documentation 
regarding the many differences between this database engine and its many 
contemporaries, which more or less towed a standardized SQL line, even with the 
many enhancements made to any one engine, Firebird frustrated my efforts to the 
point on these occasions where I decided the efforts in learning it were simply 
not justified.

 

 Nonetheless, Firebird still beckoned as mastering it was an accomplishment I 
still wanted to achieve.  As a result, seeing the mostly negative aspects of 
using Microsoft's SQL Server LocalDB for a desktop application I have been 
developing, I decided to "bite the bullet" and somehow find a way to teach 
myself Firebird in order take advantage of its excellent embedded engine also 
known as the Firebird Embedded Server.

 

 The result of this endeavor, which has been very successful so far, is a 
detailed article that attempts to make it much easier for experienced 
professionals to learn Firebird who also, like I, have many years of 
development experience with other database engines.  The article points out the 
many differences when using this engine for scripting within query and action 
screens in a db-manager or creating database modules with Firebird PSQL that 
can drive even experienced professionals to the point of distraction.  
Hopefully, my experiences will help such professionals who want to master 
Firebird as well a much easier learning experience.

 

 The article can be found at the following link for everyone's review...
 

 
https://blackfalconsoftware.wordpress.com/2018/05/11/the-firebird-database-engine-the-frustrations-of-the-long-distance-database-application-developer/
 
https://blackfalconsoftware.wordpress.com/2018/05/11/the-firebird-database-engine-the-frustrations-of-the-long-distance-database-application-developer/

 

 Admittedly, there may be some mistakes in this piece since it was developed 
around my own learning experiences with this database engine.  As a result, if 
anyone has any comments, corrections, or suggestions please let me know at my 
email address...  blackfalconsoftw...@outlook.com
 

 In addition, if anyone would like a PDF copy of this piece, please let me know 
as well and I will prepare one and send it out...

Re: [firebird-support] Diagnosing CPU usage

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

Hello Rudi,

Usually,  queries with the dozens of millions of index operations are 
responsible for high CPU usage.
You can find them with HQbird MonLogger: get snapshot during the high 
CPU peak, open it, open tab Statements (disable check "Link to selected 
attachment"), and sort on record_idx_reads.

If there are many records - Remove prepared
The queries with the highest numbers of record_idx_reads are those which 
responsible for high CPU usage.


Regards,
Alexey Kovyazin
IBSurgeon




On 10.05.2018 16:12, Rudi Feijó rudi.fe...@multidadosti.com.br 
[firebird-support] wrote:


Hello

I have a situation which is hard to debug. We are running about 50 
databases

(firebird 3.0.3) on a single server, all of them connected to different
applications.

CPU usage is normaly low, but sporadically it will peak at 100% and cause
problems for all the connections.

We have no way of debugging every single one of the applications being 
run,

and there is no single obvious operation that could justify this high cpu
usage.

Is there a way to monitor queries not only for the time they take, but for
the CPU they use?

A few years ago I tried FBScanner, but as far as I remember it didn’t 
gauge

cpu usage.

Atenciosamente,

Rudi Feijó

Multidados Informática Ltda.
* (11) 2579-8789

*  
rudi.fe...@multidadosti..com.br


*  www.multidadosti.com.br
*  www.whatsappmailing.com.br

[Non-text portions of this message have been removed]