[firebird-support] Re: Firebird for a web application

[mirco.malag...@ingeniaonline.it [firebird-support]]

Thank you, Szilveszter. 

 Mirco
 

Re: [firebird-support] Re: Firebird for a web application

[Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support]]

Hi,
i don't know what you want to monitor. There are MON$ tables for monitoring 
FB.We are using IBExpert for handling databases, which also has monitoring 
options (it actually requests data from MON$ tables).There also is performance 
analysis function and a lot more.
What we really do is: create the domains/tables. We write Stored Procedures 
(SP) for every single action (list, edit, delete, ...) and we never let direct 
acces to tables. Communiaction is all done through SPs.After the project is 
finished we analyse every SP (with IBExpert) to see they are performing well 
(there is a nice graph in IBExpert for this).Then we launch it in production.
If new features are developed later, we do them on the development server and 
after testing we synchronize database structure to production server (IBExpert 
can also do this)
About monitoring, we only monitor database health by an automatic 
backup-restore procedure (run from cron script)
As troubleshooting, if something goes wrong usually the daily backup is the key 
point...but we had database corruption only once. Then i bought a IBSurgeon's 
FBfirstAID license for 200 EUR and problem was solved easily.

That's all in short.




 


On Wednesday, November 25, 2015 12:34 PM, "mirco.malag...@ingeniaonline.it 
[firebird-support]"  wrote:
 

     Hello Szilveszter,what is your experience about monitoring, analysis and 
troubleshooting?
Thanks a lot,Mirco
  #yiv9798980123 #yiv9798980123 -- #yiv9798980123ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9798980123 
#yiv9798980123ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9798980123 
#yiv9798980123ygrp-mkp #yiv9798980123hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv9798980123 #yiv9798980123ygrp-mkp #yiv9798980123ads 
{margin-bottom:10px;}#yiv9798980123 #yiv9798980123ygrp-mkp .yiv9798980123ad 
{padding:0 0;}#yiv9798980123 #yiv9798980123ygrp-mkp .yiv9798980123ad p 
{margin:0;}#yiv9798980123 #yiv9798980123ygrp-mkp .yiv9798980123ad a 
{color:#ff;text-decoration:none;}#yiv9798980123 #yiv9798980123ygrp-sponsor 
#yiv9798980123ygrp-lc {font-family:Arial;}#yiv9798980123 
#yiv9798980123ygrp-sponsor #yiv9798980123ygrp-lc #yiv9798980123hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9798980123 
#yiv9798980123ygrp-sponsor #yiv9798980123ygrp-lc .yiv9798980123ad 
{margin-bottom:10px;padding:0 0;}#yiv9798980123 #yiv9798980123actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9798980123 
#yiv9798980123activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9798980123
 #yiv9798980123activity span {font-weight:700;}#yiv9798980123 
#yiv9798980123activity span:first-child 
{text-transform:uppercase;}#yiv9798980123 #yiv9798980123activity span a 
{color:#5085b6;text-decoration:none;}#yiv9798980123 #yiv9798980123activity span 
span {color:#ff7900;}#yiv9798980123 #yiv9798980123activity span 
.yiv9798980123underline {text-decoration:underline;}#yiv9798980123 
.yiv9798980123attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv9798980123 .yiv9798980123attach div a 
{text-decoration:none;}#yiv9798980123 .yiv9798980123attach img 
{border:none;padding-right:5px;}#yiv9798980123 .yiv9798980123attach label 
{display:block;margin-bottom:5px;}#yiv9798980123 .yiv9798980123attach label a 
{text-decoration:none;}#yiv9798980123 blockquote {margin:0 0 0 
4px;}#yiv9798980123 .yiv9798980123bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9798980123 
.yiv9798980123bold a {text-decoration:none;}#yiv9798980123 dd.yiv9798980123last 
p a {font-family:Verdana;font-weight:700;}#yiv9798980123 dd.yiv9798980123last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9798980123 
dd.yiv9798980123last p span.yiv9798980123yshortcuts 
{margin-right:0;}#yiv9798980123 div.yiv9798980123attach-table div div a 
{text-decoration:none;}#yiv9798980123 div.yiv9798980123attach-table 
{width:400px;}#yiv9798980123 div.yiv9798980123file-title a, #yiv9798980123 
div.yiv9798980123file-title a:active, #yiv9798980123 
div.yiv9798980123file-title a:hover, #yiv9798980123 div.yiv9798980123file-title 
a:visited {text-decoration:none;}#yiv9798980123 div.yiv9798980123photo-title a, 
#yiv9798980123 div.yiv9798980123photo-title a:active, #yiv9798980123 
div.yiv9798980123photo-title a:hover, #yiv9798980123 
div.yiv9798980123photo-title a:visited {text-decoration:none;}#yiv9798980123 
div#yiv9798980123ygrp-mlmsg #yiv9798980123ygrp-msg p a 
span.yiv9798980123yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9798980123 
.yiv9798980123green {color:#628c2a;}#yiv9798980123 .yiv9798980123MsoNormal 
{margin:0 0 0 0;}#yiv9798980123 o {font-size:0;}#yiv9798980123 
#yiv9798980123photos div {float:left;width:72px;}#yiv9798980123 
#yiv9798980123photos div div {border:1px solid 

[firebird-support] Re: Firebird for a web application

[mirco.malag...@ingeniaonline.it [firebird-support]]

Hello Szilveszter, what is your experience about monitoring, analysis and 
troubleshooting?
 

 Thanks a lot,
 Mirco
 

[firebird-support] Re: Firebird for a web application

[mirco.malag...@ingeniaonline.it [firebird-support]]

Hi Steve, thank you for sharing. 

 We planned to make the application available in september 2016.
 This would allow us to consider Firebird 3 which surely have more power, but 
less proven.
 

 Break a leg!
 

 Mirco