Re: [firebird-support] Database design. Simple question!
Tahnks Sent from Yahoo Mail. Get the app On Monday, July 25, 2016 11:48 PM, "Aldo Caruso aldo.car...@argencasas.com [firebird-support]" wrote: My advice is to create that field in the invoices table. You will always have this field at hand without resorting to an outer join with another table that only has two fields ( the invoice ID and this field ) each time you need to inspect it. Aldo El 25/07/16 a las 18:51, shg_siste...@yahoo.com.ar [firebird-support] escribió: Hello! I have a FB 2.5 database with a tabla "invoices". I need to add a field in that table which will be null most of the times. Lefts say, that 90% of the records will have this new field in null. What is your advice? To create a new table with a FK to "invoices" and save the needed field in a separate table (only when the value is not null of course) of just create the new field in the main "invoices" table? I think I read somewhere that null fields use very little space in the database. Is that true? Thanks for any input!!! Sergio #yiv8088435033 #yiv8088435033 -- #yiv8088435033ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8088435033 #yiv8088435033ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8088435033 #yiv8088435033ygrp-mkp #yiv8088435033hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8088435033 #yiv8088435033ygrp-mkp #yiv8088435033ads {margin-bottom:10px;}#yiv8088435033 #yiv8088435033ygrp-mkp .yiv8088435033ad {padding:0 0;}#yiv8088435033 #yiv8088435033ygrp-mkp .yiv8088435033ad p {margin:0;}#yiv8088435033 #yiv8088435033ygrp-mkp .yiv8088435033ad a {color:#ff;text-decoration:none;}#yiv8088435033 #yiv8088435033ygrp-sponsor #yiv8088435033ygrp-lc {font-family:Arial;}#yiv8088435033 #yiv8088435033ygrp-sponsor #yiv8088435033ygrp-lc #yiv8088435033hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8088435033 #yiv8088435033ygrp-sponsor #yiv8088435033ygrp-lc .yiv8088435033ad {margin-bottom:10px;padding:0 0;}#yiv8088435033 #yiv8088435033actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8088435033 #yiv8088435033activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8088435033 #yiv8088435033activity span {font-weight:700;}#yiv8088435033 #yiv8088435033activity span:first-child {text-transform:uppercase;}#yiv8088435033 #yiv8088435033activity span a {color:#5085b6;text-decoration:none;}#yiv8088435033 #yiv8088435033activity span span {color:#ff7900;}#yiv8088435033 #yiv8088435033activity span .yiv8088435033underline {text-decoration:underline;}#yiv8088435033 .yiv8088435033attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8088435033 .yiv8088435033attach div a {text-decoration:none;}#yiv8088435033 .yiv8088435033attach img {border:none;padding-right:5px;}#yiv8088435033 .yiv8088435033attach label {display:block;margin-bottom:5px;}#yiv8088435033 .yiv8088435033attach label a {text-decoration:none;}#yiv8088435033 blockquote {margin:0 0 0 4px;}#yiv8088435033 .yiv8088435033bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8088435033 .yiv8088435033bold a {text-decoration:none;}#yiv8088435033 dd.yiv8088435033last p a {font-family:Verdana;font-weight:700;}#yiv8088435033 dd.yiv8088435033last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8088435033 dd.yiv8088435033last p span.yiv8088435033yshortcuts {margin-right:0;}#yiv8088435033 div.yiv8088435033attach-table div div a {text-decoration:none;}#yiv8088435033 div.yiv8088435033attach-table {width:400px;}#yiv8088435033 div.yiv8088435033file-title a, #yiv8088435033 div.yiv8088435033file-title a:active, #yiv8088435033 div.yiv8088435033file-title a:hover, #yiv8088435033 div.yiv8088435033file-title a:visited {text-decoration:none;}#yiv8088435033 div.yiv8088435033photo-title a, #yiv8088435033 div.yiv8088435033photo-title a:active, #yiv8088435033 div.yiv8088435033photo-title a:hover, #yiv8088435033 div.yiv8088435033photo-title a:visited {text-decoration:none;}#yiv8088435033 div#yiv8088435033ygrp-mlmsg #yiv8088435033ygrp-msg p a span.yiv8088435033yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8088435033 .yiv8088435033green {color:#628c2a;}#yiv8088435033 .yiv8088435033MsoNormal {margin:0 0 0 0;}#yiv8088435033 o {font-size:0;}#yiv8088435033 #yiv8088435033photos div {float:left;width:72px;}#yiv8088435033 #yiv8088435033photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv8088435033 #yiv8088435033photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8088435033 #yiv8088435033reco-category {font-size:77%;}#yiv8088435033 #yiv8088435033reco-desc {font-size:77%;}#yiv8088435033 .yiv8088435033replbq {margin:4px;}#yiv8088435033 #yiv8088435033ygrp-actbar div a:first-child {margin-right:
Re: [firebird-support] from FB 2.5.2 to 2.5.6 and C application
Perfect Sent from Yahoo Mail. Get the app On Wednesday, July 27, 2016 8:28 AM, "ehmmm.fireb...@seznam.cz [firebird-support]" wrote: Adding some notes: Examples stat3.e and stat5.e from /opt/firebird/examples/stat/ don't work, while stat2.e works. I'm getting the same -901 "request synchronization error". Steps to reproduce: Extract somewhere FirebirdCS-2.5.6.27020-0.i686.tar.gz "su" to be root. Run install.sh, creates backup, ask for password. Replace /opt/firebird/security2.fdb with symlink to reallife security2.fdb. Get /etc/init.d/firebird from somewhere. service firebird start cd /opt/firebird/examples/stat cp ../include/example.h . /opt/firebird/bin/gpre -d employee.fdb stat2.e export ISC_USER=sysdba export ISC_PASSWORD=... export ISC_DATABASE=employee.fdb cc -lfbclient stat2.c -o stat2 ./stat2 (Same for stat3.e and stat5.e) Like I said, in FB 2.5.6 stat3 and stat5 throw error. If I do the same with FB 2.5.5 then these examples work. -- Původní zpráva -- Od: ehmmm.fireb...@seznam.cz [firebird-support] Komu: firebird-support@yahoogroups.com Datum: 26. 7. 2016 20:46:58 Předmět: [firebird-support] from FB 2.5.2 to 2.5.6 and C application Hi, we have server with Debian 6.0 squeeze and there we have Firebird 2.5.2 (superclassic) which sometimes hangs and I don't know why. So my idea was to install there FB 2.5.6. I downloaded FB 2.5.6 superclassic i686 (debian is amd64 but previous firebird seems to be i686 so I decided to continue using i686) tar.gz, extracted it and executed install.sh. I think I was quite successful. I didn't make backups of *.fdb files, I only copied older security2.fdb into /opt/firebird and copied some init script from /opet/firebird/misc into /etc/init.d My PHP webapges work well, my Python apps work well, FlameRobin works well. The only problem I have with some old C programs running on the same server, precompiled via GPRE utility. These C apps fail for example on then line (just example) EXEC SQL FETCH cur_al...: int i, id, status; EXEC SQL CONNECT DB USER '...' PASSWORD '...'; EXEC SQL SET TRANSACTION READ WRITE WAIT ISOLATION LEVEL READ COMMITTED; EXEC SQL DECLARE cur_al CURSOR FOR SELECT id_blabla, status FROM blabla; EXEC SQL OPEN cur_al; while(SQLCODE == 0) { EXEC SQL FETCH cur_al INTO :id, :status; if (SQLCODE == 0) { ... } } EXEC SQL CLOSE cur_al; ... It throws error -901 and messages "Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements" and "request synchronization error". I'm not author of these C apps and I'm not very skilled in C on linux, I only found some Makefile so I tried run "make". But it didn't help. What should I try? Should I look somewhere for some libraries? The most interesting for me is that when I download and install FB 2.5.5 or 2.5.4 (I must admit that upgrading/downgrading firebird inside 2.5.x is quite easy) then these C apps seems to work correctly. (?) Is there any explanation for this? = = #yiv5635814332 #yiv5635814332 -- #yiv5635814332ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5635814332 #yiv5635814332ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5635814332 #yiv5635814332ygrp-mkp #yiv5635814332hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5635814332 #yiv5635814332ygrp-mkp #yiv5635814332ads {margin-bottom:10px;}#yiv5635814332 #yiv5635814332ygrp-mkp .yiv5635814332ad {padding:0 0;}#yiv5635814332 #yiv5635814332ygrp-mkp .yiv5635814332ad p {margin:0;}#yiv5635814332 #yiv5635814332ygrp-mkp .yiv5635814332ad a {color:#ff;text-decoration:none;}#yiv5635814332 #yiv5635814332ygrp-sponsor #yiv5635814332ygrp-lc {font-family:Arial;}#yiv5635814332 #yiv5635814332ygrp-sponsor #yiv5635814332ygrp-lc #yiv5635814332hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5635814332 #yiv5635814332ygrp-sponsor #yiv5635814332ygrp-lc .yiv5635814332ad {margin-bottom:10px;padding:0 0;}#yiv5635814332 #yiv5635814332actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5635814332 #yiv5635814332activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5635814332 #yiv5635814332activity span {font-weight:700;}#yiv5635814332 #yiv5635814332activity span:first-child {text-transform:uppercase;}#yiv5635814332 #yiv5635814332activity span a {color:#5085b6;text-decoration:none;}#yiv5635814332 #yiv5635814332activity span span {color:#ff7900;}#yiv5635814332 #yiv5635814332activity span .yiv5635814332underline {text-decoration:underline;}#yiv5635814332 .yiv5635814332attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5635814332 .yiv5635814332attach div a {text-decoration:none;}#yiv5635814332 .yiv5635814332attach img {border:none;padding-right:5px;}#yiv5635814332 .yiv5635814332attach label {display:block;margin-bottom:5px;}#yiv56358143
Re: [firebird-support] Getting INET/inet_error: read errno = 10054
Great, Thanks! Sent from Yahoo Mail. Get the app On Saturday, August 27, 2016 7:45 AM, "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" wrote: On 26-8-2016 22:27, Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support] wrote: > We are running fb 2.5.6 and are getting the INET erorr regularily. > The error has been there before as well with earlier versions of fb. > > Is this something I should be conserned about and what can I do about it? Error 10054 is "Connection reset by peer", which means that the server tried to do something with the network connection from a client, and it was already closed. This can happen due to network problems, or the application was terminated abruptly. However the usual main cause is that connections aren't properly closed, either by your applications (eg you never close connections, and they are eventually terminated by the garbage collector), or maybe by the driver you use (eg because its implementation of a connection close is wrong). > Another issue is that when I list transactions I have a transaction that > is "stuck" back in time but that has no attachemnt associated with it. > Is this normal? > > This is the row from the MON$TRANSACTIONS that have no corresponding > MON$ATTACHMENTS row: > 648583083 84322 0 26.08.2016, 19:11:47.489 648583083 648563078 649285961 > 2 -1 1 0 1 26 0023:0004 Assuming the normal order of columns in MON$ATTACHMENTS: This is transaction 648583083 of attachment 84322, in state 0 (active), it has READ_COMMITTED_VERSION isolation, wait without timeout (AFAIK), read-only, no autocommit, with autoundo. Maybe the associated attachment got terminated abruptly and Firebird hasn't yet detected this and rolled back the transaction (or in this case as it is read only: committed it). If you want to speed it up: a restart of the Firebird server process would mark it as such IIRC. Mark -- Mark Rotteveel #yiv0999123258 #yiv0999123258 -- #yiv0999123258ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0999123258 #yiv0999123258ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0999123258 #yiv0999123258ygrp-mkp #yiv0999123258hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0999123258 #yiv0999123258ygrp-mkp #yiv0999123258ads {margin-bottom:10px;}#yiv0999123258 #yiv0999123258ygrp-mkp .yiv0999123258ad {padding:0 0;}#yiv0999123258 #yiv0999123258ygrp-mkp .yiv0999123258ad p {margin:0;}#yiv0999123258 #yiv0999123258ygrp-mkp .yiv0999123258ad a {color:#ff;text-decoration:none;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ygrp-lc {font-family:Arial;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ygrp-lc #yiv0999123258hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ygrp-lc .yiv0999123258ad {margin-bottom:10px;padding:0 0;}#yiv0999123258 #yiv0999123258actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0999123258 #yiv0999123258activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0999123258 #yiv0999123258activity span {font-weight:700;}#yiv0999123258 #yiv0999123258activity span:first-child {text-transform:uppercase;}#yiv0999123258 #yiv0999123258activity span a {color:#5085b6;text-decoration:none;}#yiv0999123258 #yiv0999123258activity span span {color:#ff7900;}#yiv0999123258 #yiv0999123258activity span .yiv0999123258underline {text-decoration:underline;}#yiv0999123258 .yiv0999123258attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0999123258 .yiv0999123258attach div a {text-decoration:none;}#yiv0999123258 .yiv0999123258attach img {border:none;padding-right:5px;}#yiv0999123258 .yiv0999123258attach label {display:block;margin-bottom:5px;}#yiv0999123258 .yiv0999123258attach label a {text-decoration:none;}#yiv0999123258 blockquote {margin:0 0 0 4px;}#yiv0999123258 .yiv0999123258bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0999123258 .yiv0999123258bold a {text-decoration:none;}#yiv0999123258 dd.yiv0999123258last p a {font-family:Verdana;font-weight:700;}#yiv0999123258 dd.yiv0999123258last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0999123258 dd.yiv0999123258last p span.yiv0999123258yshortcuts {margin-right:0;}#yiv0999123258 div.yiv0999123258attach-table div div a {text-decoration:none;}#yiv0999123258 div.yiv0999123258attach-table {width:400px;}#yiv0999123258 div.yiv0999123258file-title a, #yiv0999123258 div.yiv0999123258file-title a:active, #yiv0999123258 div.yiv0999123258file-title a:hover, #yiv0999123258 div.yiv0999123258file-title a:visited {text-decoration:none;}#yiv0999123258 div.yiv0999123258photo-title a, #yiv0999123258 div.yiv0999123258photo-title a:active, #yiv0999123258 div.yiv0999123258photo-title a:hover, #yiv0999123258 div.yiv0999123258photo-title a:visited {text
Re: [firebird-support] gbak error
Hello Sent from Yahoo Mail. Get the app On Wednesday, August 31, 2016 6:02 PM, "Nick Upson n...@telensa.com [firebird-support]" wrote: it either happens on creation or a file is started and then removed very quickly Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct+44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 On 31 August 2016 at 16:57, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: Does the error happen on file creation or after some data has been written? On Aug 30, 2016, at 4:36 PM, Nick Upson n...@telensa.com [firebird-support] wrote: no, not a file name collision and plenty of disk space this just started happening, no change to installed s/w Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct+44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 On 30 August 2016 at 21:14, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: Hello Nick, > I'm running fb2.1 on centos5, recently a system has started > throwing this error when asked to do a backup, the gbak parameters > are unchanged, permissions all seem ok, any suggestions what I might check > gbak: ERROR:Unexpected I/O error while writing to backup file > gbak:Exiting before completion due to errors "gbak parameters are unchanged." Could be you already have a file in that location with the same name. HB #yiv7008999817 #yiv7008999817 -- #yiv7008999817ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7008999817 #yiv7008999817ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7008999817 #yiv7008999817ygrp-mkp #yiv7008999817hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7008999817 #yiv7008999817ygrp-mkp #yiv7008999817ads {margin-bottom:10px;}#yiv7008999817 #yiv7008999817ygrp-mkp .yiv7008999817ad {padding:0 0;}#yiv7008999817 #yiv7008999817ygrp-mkp .yiv7008999817ad p {margin:0;}#yiv7008999817 #yiv7008999817ygrp-mkp .yiv7008999817ad a {color:#ff;text-decoration:none;}#yiv7008999817 #yiv7008999817ygrp-sponsor #yiv7008999817ygrp-lc {font-family:Arial;}#yiv7008999817 #yiv7008999817ygrp-sponsor #yiv7008999817ygrp-lc #yiv7008999817hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7008999817 #yiv7008999817ygrp-sponsor #yiv7008999817ygrp-lc .yiv7008999817ad {margin-bottom:10px;padding:0 0;}#yiv7008999817 #yiv7008999817actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7008999817 #yiv7008999817activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7008999817 #yiv7008999817activity span {font-weight:700;}#yiv7008999817 #yiv7008999817activity span:first-child {text-transform:uppercase;}#yiv7008999817 #yiv7008999817activity span a {color:#5085b6;text-decoration:none;}#yiv7008999817 #yiv7008999817activity span span {color:#ff7900;}#yiv7008999817 #yiv7008999817activity span .yiv7008999817underline {text-decoration:underline;}#yiv7008999817 .yiv7008999817attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7008999817 .yiv7008999817attach div a {text-decoration:none;}#yiv7008999817 .yiv7008999817attach img {border:none;padding-right:5px;}#yiv7008999817 .yiv7008999817attach label {display:block;margin-bottom:5px;}#yiv7008999817 .yiv7008999817attach label a {text-decoration:none;}#yiv7008999817 blockquote {margin:0 0 0 4px;}#yiv7008999817 .yiv7008999817bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7008999817 .yiv7008999817bold a {text-decoration:none;}#yiv7008999817 dd.yiv7008999817last p a {font-family:Verdana;font-weight:700;}#yiv7008999817 dd.yiv7008999817last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7008999817 dd.yiv7008999817last p span.yiv7008999817yshortcuts {margin-right:0;}#yiv7008999817 div.yiv7008999817attach-table div div a {text-decoration:none;}#yiv7008999817 div.yiv7008999817attach-table {width:400px;}#yiv7008999817 div.yiv7008999817file-title a, #yiv7008999817 div.yiv7008999817file-title a:active, #yiv7008999817 div.yiv7008999817file-title a:hover, #yiv7008999817 div.yiv7008999817file-title a:visited {text-decoration:none;}#yiv7008999817 div.yiv7008999817photo-title a, #yiv7008999817 div.yiv7008999817photo-title a:active, #yiv7008999817 div.yiv7008999817photo-title a:hover, #yiv7008999817 div.yiv7008999817photo-title a:visited {text-decoration:none;}#yiv7008999817 div#yiv7008999817ygrp-mlmsg #yiv7008999817ygrp-msg p a span.yiv7008999817yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7008999817 .yiv7008999817green {color:#628c2a;}#yiv7008999817 .yiv7008999817MsoNormal {margin:0 0 0 0;}#yiv7008999817 o {font-size:0;}#yiv7008999817 #yiv7008999817photos div {float:left;width:72px;}#yiv7008999817 #yiv7008999817photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv7008999817 #yiv7008999817photos div label
Re: [firebird-support] How to install Firebird 3.0 on Linux?
Perfect Sent from Yahoo Mail. Get the app On Friday, September 2, 2016 5:54 AM, "Martin Schreiber mse00...@gmail.com [firebird-support]" wrote: Hi, What is the recommended way to install Firebird 3.0 on OpenSUSE 13.1 X86? The script "install.sh" from https://sourceforge.net/projects/firebird/files/firebird-linux-i386/3.0-Release/Firebird-3.0.0.32483-0.i686.tar.gz/download stops with the errormessage: " unable to open database Could not find acceptable ICU library " Thanks, Martin #yiv9853204975 #yiv9853204975 -- #yiv9853204975ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9853204975 #yiv9853204975ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9853204975 #yiv9853204975ygrp-mkp #yiv9853204975hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9853204975 #yiv9853204975ygrp-mkp #yiv9853204975ads {margin-bottom:10px;}#yiv9853204975 #yiv9853204975ygrp-mkp .yiv9853204975ad {padding:0 0;}#yiv9853204975 #yiv9853204975ygrp-mkp .yiv9853204975ad p {margin:0;}#yiv9853204975 #yiv9853204975ygrp-mkp .yiv9853204975ad a {color:#ff;text-decoration:none;}#yiv9853204975 #yiv9853204975ygrp-sponsor #yiv9853204975ygrp-lc {font-family:Arial;}#yiv9853204975 #yiv9853204975ygrp-sponsor #yiv9853204975ygrp-lc #yiv9853204975hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9853204975 #yiv9853204975ygrp-sponsor #yiv9853204975ygrp-lc .yiv9853204975ad {margin-bottom:10px;padding:0 0;}#yiv9853204975 #yiv9853204975actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9853204975 #yiv9853204975activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9853204975 #yiv9853204975activity span {font-weight:700;}#yiv9853204975 #yiv9853204975activity span:first-child {text-transform:uppercase;}#yiv9853204975 #yiv9853204975activity span a {color:#5085b6;text-decoration:none;}#yiv9853204975 #yiv9853204975activity span span {color:#ff7900;}#yiv9853204975 #yiv9853204975activity span .yiv9853204975underline {text-decoration:underline;}#yiv9853204975 .yiv9853204975attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9853204975 .yiv9853204975attach div a {text-decoration:none;}#yiv9853204975 .yiv9853204975attach img {border:none;padding-right:5px;}#yiv9853204975 .yiv9853204975attach label {display:block;margin-bottom:5px;}#yiv9853204975 .yiv9853204975attach label a {text-decoration:none;}#yiv9853204975 blockquote {margin:0 0 0 4px;}#yiv9853204975 .yiv9853204975bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9853204975 .yiv9853204975bold a {text-decoration:none;}#yiv9853204975 dd.yiv9853204975last p a {font-family:Verdana;font-weight:700;}#yiv9853204975 dd.yiv9853204975last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9853204975 dd.yiv9853204975last p span.yiv9853204975yshortcuts {margin-right:0;}#yiv9853204975 div.yiv9853204975attach-table div div a {text-decoration:none;}#yiv9853204975 div.yiv9853204975attach-table {width:400px;}#yiv9853204975 div.yiv9853204975file-title a, #yiv9853204975 div.yiv9853204975file-title a:active, #yiv9853204975 div.yiv9853204975file-title a:hover, #yiv9853204975 div.yiv9853204975file-title a:visited {text-decoration:none;}#yiv9853204975 div.yiv9853204975photo-title a, #yiv9853204975 div.yiv9853204975photo-title a:active, #yiv9853204975 div.yiv9853204975photo-title a:hover, #yiv9853204975 div.yiv9853204975photo-title a:visited {text-decoration:none;}#yiv9853204975 div#yiv9853204975ygrp-mlmsg #yiv9853204975ygrp-msg p a span.yiv9853204975yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9853204975 .yiv9853204975green {color:#628c2a;}#yiv9853204975 .yiv9853204975MsoNormal {margin:0 0 0 0;}#yiv9853204975 o {font-size:0;}#yiv9853204975 #yiv9853204975photos div {float:left;width:72px;}#yiv9853204975 #yiv9853204975photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv9853204975 #yiv9853204975photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9853204975 #yiv9853204975reco-category {font-size:77%;}#yiv9853204975 #yiv9853204975reco-desc {font-size:77%;}#yiv9853204975 .yiv9853204975replbq {margin:4px;}#yiv9853204975 #yiv9853204975ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9853204975 #yiv9853204975ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9853204975 #yiv9853204975ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9853204975 #yiv9853204975ygrp-mlmsg select, #yiv9853204975 input, #yiv9853204975 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9853204975 #yiv9853204975ygrp-mlmsg pre, #yiv9853204975 code {font:115% monospace;}#yiv9853204975 #yiv9853204975ygrp-mlmsg * {line-height:1.22em;}#yiv9853204975 #yiv9853204975ygrp-mlmsg #yiv9853204975lo
Re: [firebird-support] Re: Problems after FB3 upgrade
Thanks Sent from Yahoo Mail. Get the app On Wednesday, September 7, 2016 11:52 AM, "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" wrote: 07.09.2016 11:38, Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > I cannot find any info on doing a manual install to upgrade to the latest > snapshot of FB3 > on Windows. Just stop Firebird and unpack the archive over existing installation overwriting everything except configuration files and security database. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] Optimizer request
Thank you Sent from Yahoo Mail. Get the app On Saturday, September 10, 2016 10:04 PM, "'Djordje Radovanovic' softsis...@sbb.rs [firebird-support]" wrote: CREATE TABLE PARTNERS ( PARTID INTEGER NOT NULL, COUNTRY CHAR(20));ALTER TABLE PARTNERS ADD CONSTRAINT PK_PARTNERS PRIMARY KEY (PARTID);CREATE INDEX PARTNERS_IDX1 ON PARTNERS (COUNTRY); CREATE TABLE ORDERS ( ORDERNUM INTEGER NOT NULL, ORDERDATE DATE, AMOUNT DECIMAL(18,2), PARTID INTEGER); ALTER TABLE ORDERS ADD CONSTRAINT PK_ORDERS PRIMARY KEY (ORDERNUM);ALTER TABLE ORDERS ADD CONSTRAINT FK_ORDERS_PARTNERS FOREIGN KEY (PARTID) REFERENCES PARTNERS (PARTID) ON DELETE NO ACTION ON UPDATE NO ACTION; This is tables definitions. So, index exist and after all perfomance analyzer gives me same result.Perfomance analyzer was taken from IBExpert. Whatever I do (as others suggest) perfomance are the same. I still vote for changes in optimizer. Right side from WHERE clause needs to be evaluated before main query and it is simple and much better solution same as Oracle optimize query. Firebird is very kind to programmer and has easy to understand, efficient P/SQL and some improvements will give us significant efficiency..Djordje From: mailto:firebird-support@yahoogroups.com Sent: Friday, September 09, 2016 10:51 PMTo: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Optimizer request On Fri, Sep 9, 2016 at 8:30 AM, 'Djordje Radovanovic' softsis...@sbb.rs [firebird-support] wrote: I tried query with subquery in where clause and found big issue for this type of subquery. select * from orders where orders.partid in (select partners.partid from partners where partners.country = ‘Spain’) Perfomance Analysis returns me this partners 687660 non index reads orders 28657 index reads If you analyze this result you’ll find that there is 687659 unnecessary non index reads. If developer of optimizer accept that all queries on the left side of where clause has priority (and there is no way to be opposite) than we have big improvement in optimization. Is there an index on partners.country? What plans are generated for each query? If I were writing this query, I'd write select o.* from orders o inner join partners p where p.partid = o.opartid and p.country = 'Spain'; All that silliness about "select from (select from )" probably doesn't save anything inthis case - it does when the inner select is complicated, but not here. Firebird won'tcarry around unneeded fields from the partners table. What is the distribution of partners.country? Good luck, Ann __,_._,_ #yiv1810376193 #yiv1810376193 -- #yiv1810376193ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1810376193 #yiv1810376193ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1810376193 #yiv1810376193ygrp-mkp #yiv1810376193hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1810376193 #yiv1810376193ygrp-mkp #yiv1810376193ads {margin-bottom:10px;}#yiv1810376193 #yiv1810376193ygrp-mkp .yiv1810376193ad {padding:0 0;}#yiv1810376193 #yiv1810376193ygrp-mkp .yiv1810376193ad p {margin:0;}#yiv1810376193 #yiv1810376193ygrp-mkp .yiv1810376193ad a {color:#ff;text-decoration:none;}#yiv1810376193 #yiv1810376193ygrp-sponsor #yiv1810376193ygrp-lc {font-family:Arial;}#yiv1810376193 #yiv1810376193ygrp-sponsor #yiv1810376193ygrp-lc #yiv1810376193hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1810376193 #yiv1810376193ygrp-sponsor #yiv1810376193ygrp-lc .yiv1810376193ad {margin-bottom:10px;padding:0 0;}#yiv1810376193 #yiv1810376193actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1810376193 #yiv1810376193activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1810376193 #yiv1810376193activity span {font-weight:700;}#yiv1810376193 #yiv1810376193activity span:first-child {text-transform:uppercase;}#yiv1810376193 #yiv1810376193activity span a {color:#5085b6;text-decoration:none;}#yiv1810376193 #yiv1810376193activity span span {color:#ff7900;}#yiv1810376193 #yiv1810376193activity span .yiv1810376193underline {text-decoration:underline;}#yiv1810376193 .yiv1810376193attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1810376193 .yiv1810376193attach div a {text-decoration:none;}#yiv1810376193 .yiv1810376193attach img {border:none;padding-right:5px;}#yiv1810376193 .yiv1810376193attach label {display:block;margin-bottom:5px;}#yiv1810376193 .yiv1810376193attach label a {text-decoration:none;}#yiv1810376193 blockquote {margin:0 0 0 4px;}#yiv1810376193 .yiv1810376193bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1810376193 .yiv1810376193bold a {text-decoration:none;}#yiv1810376193 dd.yiv1810376193last p a {font-family:Verdana;font-weight:700;}#yiv1810376193 dd.
Re: [firebird-support] Gbak performance issues on FB3
Perfect Sent from Yahoo Mail. Get the app On Saturday, September 10, 2016 10:11 PM, "fabia...@itbizolutions.com.au [firebird-support]" wrote: I am running both gbak.exe and nbackup.exe on an FB3 server with Windows 2012 R2 64 bits, 24 processor, 192 GB ram, the nbackup.exe level zero is much faster than the gbak.exe (does not make any sense, it should take about the same time as gbak), both running locally but connecting using the super server (localhost:database_name); any ideas why gbak.exe is so slow? The test database size is 70GB, gbak takes 01:07:00 to complete,nbackup.exe level zero takes 13 minutes, that is 5 times faster than gbak... something is not right, any ideas #yiv6200868968 #yiv6200868968 -- #yiv6200868968ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6200868968 #yiv6200868968ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6200868968 #yiv6200868968ygrp-mkp #yiv6200868968hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6200868968 #yiv6200868968ygrp-mkp #yiv6200868968ads {margin-bottom:10px;}#yiv6200868968 #yiv6200868968ygrp-mkp .yiv6200868968ad {padding:0 0;}#yiv6200868968 #yiv6200868968ygrp-mkp .yiv6200868968ad p {margin:0;}#yiv6200868968 #yiv6200868968ygrp-mkp .yiv6200868968ad a {color:#ff;text-decoration:none;}#yiv6200868968 #yiv6200868968ygrp-sponsor #yiv6200868968ygrp-lc {font-family:Arial;}#yiv6200868968 #yiv6200868968ygrp-sponsor #yiv6200868968ygrp-lc #yiv6200868968hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6200868968 #yiv6200868968ygrp-sponsor #yiv6200868968ygrp-lc .yiv6200868968ad {margin-bottom:10px;padding:0 0;}#yiv6200868968 #yiv6200868968actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6200868968 #yiv6200868968activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6200868968 #yiv6200868968activity span {font-weight:700;}#yiv6200868968 #yiv6200868968activity span:first-child {text-transform:uppercase;}#yiv6200868968 #yiv6200868968activity span a {color:#5085b6;text-decoration:none;}#yiv6200868968 #yiv6200868968activity span span {color:#ff7900;}#yiv6200868968 #yiv6200868968activity span .yiv6200868968underline {text-decoration:underline;}#yiv6200868968 .yiv6200868968attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6200868968 .yiv6200868968attach div a {text-decoration:none;}#yiv6200868968 .yiv6200868968attach img {border:none;padding-right:5px;}#yiv6200868968 .yiv6200868968attach label {display:block;margin-bottom:5px;}#yiv6200868968 .yiv6200868968attach label a {text-decoration:none;}#yiv6200868968 blockquote {margin:0 0 0 4px;}#yiv6200868968 .yiv6200868968bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6200868968 .yiv6200868968bold a {text-decoration:none;}#yiv6200868968 dd.yiv6200868968last p a {font-family:Verdana;font-weight:700;}#yiv6200868968 dd.yiv6200868968last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6200868968 dd.yiv6200868968last p span.yiv6200868968yshortcuts {margin-right:0;}#yiv6200868968 div.yiv6200868968attach-table div div a {text-decoration:none;}#yiv6200868968 div.yiv6200868968attach-table {width:400px;}#yiv6200868968 div.yiv6200868968file-title a, #yiv6200868968 div.yiv6200868968file-title a:active, #yiv6200868968 div.yiv6200868968file-title a:hover, #yiv6200868968 div.yiv6200868968file-title a:visited {text-decoration:none;}#yiv6200868968 div.yiv6200868968photo-title a, #yiv6200868968 div.yiv6200868968photo-title a:active, #yiv6200868968 div.yiv6200868968photo-title a:hover, #yiv6200868968 div.yiv6200868968photo-title a:visited {text-decoration:none;}#yiv6200868968 div#yiv6200868968ygrp-mlmsg #yiv6200868968ygrp-msg p a span.yiv6200868968yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6200868968 .yiv6200868968green {color:#628c2a;}#yiv6200868968 .yiv6200868968MsoNormal {margin:0 0 0 0;}#yiv6200868968 o {font-size:0;}#yiv6200868968 #yiv6200868968photos div {float:left;width:72px;}#yiv6200868968 #yiv6200868968photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv6200868968 #yiv6200868968photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6200868968 #yiv6200868968reco-category {font-size:77%;}#yiv6200868968 #yiv6200868968reco-desc {font-size:77%;}#yiv6200868968 .yiv6200868968replbq {margin:4px;}#yiv6200868968 #yiv6200868968ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6200868968 #yiv6200868968ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6200868968 #yiv6200868968ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6200868968 #yiv6200868968ygrp-mlmsg select, #yiv6200868968 input, #yiv6200868968 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#
Re: [firebird-support] Problem querying MON$STATEMENTS table
Hello Sent from Yahoo Mail. Get the app On Friday, September 16, 2016 3:47 AM, "Helen Borrie hele...@iinet.net.au [firebird-support]" wrote: Friday, September 16, 2016, 12:02:28 AM, Gregor Kobler wrote: > I have a problem when i querying the MON$STATEMENS table on Server 2.5.5 and > also 2.5.6 > > Do the follow steps: > > Open a connection to the database, then start a transaction an open > a table to show the content and keep it open/active Now run the > follow statement "SELECT * FROM MON$STATEMENS" > > The Row that should shows you the active query are not correct! Open output set <> active query. Once the SELECT statement has finished fetching, its state is no longer active...it becomes "idle". > > The column MON$STATE shows allways Zero Zero is the "idle" state. It will go to "active" (1) next time the cursor restarts. > and also the columns > MON$TRANSACTION_ID and MON$TIMESTAMP are also allways NULL!! Both of those fields will hold values only while the statement is active. A statement that is idle is not active. > > The Server 3.0.1 are not affected on this problem. > > The follow databases with charset are not working (tested) NONE, WIN1250, > ISO8859_1 > > A database with charset WIN1251 are working well. > > May this could be a bug. If you suspect a bug, please try to give a proper description of what you mean by "working well" and "not working" and post it, with your statements, to firebird-devel. Also give the build number of the snapshot that you refer to as "Server 3.0.1", as these snapshots are refreshed very regularly. The core devs have been working pretty solidly on Fb3 bugs over the past 3 months so you should be able to discover what kind of a problem (if any) you are actually observing and whether it is fixed. HB #yiv0145561509 #yiv0145561509 -- #yiv0145561509ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0145561509 #yiv0145561509ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0145561509 #yiv0145561509ygrp-mkp #yiv0145561509hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0145561509 #yiv0145561509ygrp-mkp #yiv0145561509ads {margin-bottom:10px;}#yiv0145561509 #yiv0145561509ygrp-mkp .yiv0145561509ad {padding:0 0;}#yiv0145561509 #yiv0145561509ygrp-mkp .yiv0145561509ad p {margin:0;}#yiv0145561509 #yiv0145561509ygrp-mkp .yiv0145561509ad a {color:#ff;text-decoration:none;}#yiv0145561509 #yiv0145561509ygrp-sponsor #yiv0145561509ygrp-lc {font-family:Arial;}#yiv0145561509 #yiv0145561509ygrp-sponsor #yiv0145561509ygrp-lc #yiv0145561509hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0145561509 #yiv0145561509ygrp-sponsor #yiv0145561509ygrp-lc .yiv0145561509ad {margin-bottom:10px;padding:0 0;}#yiv0145561509 #yiv0145561509actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0145561509 #yiv0145561509activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0145561509 #yiv0145561509activity span {font-weight:700;}#yiv0145561509 #yiv0145561509activity span:first-child {text-transform:uppercase;}#yiv0145561509 #yiv0145561509activity span a {color:#5085b6;text-decoration:none;}#yiv0145561509 #yiv0145561509activity span span {color:#ff7900;}#yiv0145561509 #yiv0145561509activity span .yiv0145561509underline {text-decoration:underline;}#yiv0145561509 .yiv0145561509attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0145561509 .yiv0145561509attach div a {text-decoration:none;}#yiv0145561509 .yiv0145561509attach img {border:none;padding-right:5px;}#yiv0145561509 .yiv0145561509attach label {display:block;margin-bottom:5px;}#yiv0145561509 .yiv0145561509attach label a {text-decoration:none;}#yiv0145561509 blockquote {margin:0 0 0 4px;}#yiv0145561509 .yiv0145561509bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0145561509 .yiv0145561509bold a {text-decoration:none;}#yiv0145561509 dd.yiv0145561509last p a {font-family:Verdana;font-weight:700;}#yiv0145561509 dd.yiv0145561509last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0145561509 dd.yiv0145561509last p span.yiv0145561509yshortcuts {margin-right:0;}#yiv0145561509 div.yiv0145561509attach-table div div a {text-decoration:none;}#yiv0145561509 div.yiv0145561509attach-table {width:400px;}#yiv0145561509 div.yiv0145561509file-title a, #yiv0145561509 div.yiv0145561509file-title a:active, #yiv0145561509 div.yiv0145561509file-title a:hover, #yiv0145561509 div.yiv0145561509file-title a:visited {text-decoration:none;}#yiv0145561509 div.yiv0145561509photo-title a, #yiv0145561509 div.yiv0145561509photo-title a:active, #yiv0145561509 div.yiv0145561509photo-title a:hover, #yiv0145561509 div.yiv0145561509photo-title a:visited {text-decoration:none;}#yiv0145561509 div#yiv0145561509ygrp-mlmsg #yiv0145561509ygrp-msg p a span.yiv0145561509yshortcuts {font-family:Verdana;font-
Re: Re: [firebird-support] Is it possible to insert Image via sql stament?
Hello Sent from Yahoo Mail. Get the app On Tuesday, September 27, 2016 9:36 AM, "liviuslivius liviusliv...@poczta.onet.pl [firebird-support]" wrote: W dniu 2016-09-27 08:06:13 użytkownik Mike Ro miker...@gmail.com [firebird-support] napisał: On 27/09/2016 04:22, trsk...@yahoo.com [firebird-support] wrote: Is it possible to insert image into FB database directly via sql stament using isql or flamerobin? Hi, yes it is possible with FlameRobin. - Insert a new record in the normal way (for example, right click on the table, select "Browse data" and Grid->Insert row). - Now in the "Data" area of the window you will have a "[null]" in the column containing your blob field. - Right click on this [null] and there will be an option "Import BLOB from file". - Pick the image file you want to insert and the "[null]" will change to "[BINARY]". - Commit the insert and the image should be in your database. Note: If you want to view the image, right click on the "[BINARY]" text and choose "Save BLOB to file..." Hope this helps. Hi, by clear SQL it is also possible for smaller images using hex notationhttp://www.firebirdsql.org/refdocs/langrefupd25-hexbinstrings.html in FB3 command can by at 10MB length regards,Karol Bieniaszewski #yiv9911299187 #yiv9911299187 -- #yiv9911299187ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9911299187 #yiv9911299187ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9911299187 #yiv9911299187ygrp-mkp #yiv9911299187hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9911299187 #yiv9911299187ygrp-mkp #yiv9911299187ads {margin-bottom:10px;}#yiv9911299187 #yiv9911299187ygrp-mkp .yiv9911299187ad {padding:0 0;}#yiv9911299187 #yiv9911299187ygrp-mkp .yiv9911299187ad p {margin:0;}#yiv9911299187 #yiv9911299187ygrp-mkp .yiv9911299187ad a {color:#ff;text-decoration:none;}#yiv9911299187 #yiv9911299187ygrp-sponsor #yiv9911299187ygrp-lc {font-family:Arial;}#yiv9911299187 #yiv9911299187ygrp-sponsor #yiv9911299187ygrp-lc #yiv9911299187hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9911299187 #yiv9911299187ygrp-sponsor #yiv9911299187ygrp-lc .yiv9911299187ad {margin-bottom:10px;padding:0 0;}#yiv9911299187 #yiv9911299187actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9911299187 #yiv9911299187activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9911299187 #yiv9911299187activity span {font-weight:700;}#yiv9911299187 #yiv9911299187activity span:first-child {text-transform:uppercase;}#yiv9911299187 #yiv9911299187activity span a {color:#5085b6;text-decoration:none;}#yiv9911299187 #yiv9911299187activity span span {color:#ff7900;}#yiv9911299187 #yiv9911299187activity span .yiv9911299187underline {text-decoration:underline;}#yiv9911299187 .yiv9911299187attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9911299187 .yiv9911299187attach div a {text-decoration:none;}#yiv9911299187 .yiv9911299187attach img {border:none;padding-right:5px;}#yiv9911299187 .yiv9911299187attach label {display:block;margin-bottom:5px;}#yiv9911299187 .yiv9911299187attach label a {text-decoration:none;}#yiv9911299187 blockquote {margin:0 0 0 4px;}#yiv9911299187 .yiv9911299187bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9911299187 .yiv9911299187bold a {text-decoration:none;}#yiv9911299187 dd.yiv9911299187last p a {font-family:Verdana;font-weight:700;}#yiv9911299187 dd.yiv9911299187last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9911299187 dd.yiv9911299187last p span.yiv9911299187yshortcuts {margin-right:0;}#yiv9911299187 div.yiv9911299187attach-table div div a {text-decoration:none;}#yiv9911299187 div.yiv9911299187attach-table {width:400px;}#yiv9911299187 div.yiv9911299187file-title a, #yiv9911299187 div.yiv9911299187file-title a:active, #yiv9911299187 div.yiv9911299187file-title a:hover, #yiv9911299187 div.yiv9911299187file-title a:visited {text-decoration:none;}#yiv9911299187 div.yiv9911299187photo-title a, #yiv9911299187 div.yiv9911299187photo-title a:active, #yiv9911299187 div.yiv9911299187photo-title a:hover, #yiv9911299187 div.yiv9911299187photo-title a:visited {text-decoration:none;}#yiv9911299187 div#yiv9911299187ygrp-mlmsg #yiv9911299187ygrp-msg p a span.yiv9911299187yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9911299187 .yiv9911299187green {color:#628c2a;}#yiv9911299187 .yiv9911299187MsoNormal {margin:0 0 0 0;}#yiv9911299187 o {font-size:0;}#yiv9911299187 #yiv9911299187photos div {float:left;width:72px;}#yiv9911299187 #yiv9911299187photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv9911299187 #yiv9911299187photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv99
Re: [firebird-support] Is it possible to insert Image via sql stament?
Great, Thanks! Sent from Yahoo Mail. Get the app On Tuesday, September 27, 2016 10:10 AM, "Scott Morgan bl...@blueyonder.co.uk [firebird-support]" wrote: On 27/09/16 04:22, trsk...@yahoo.com [firebird-support] wrote: > Is it possible to insert image into FB database directly via sql stament > using isql or flamerobin? There's a utility, FSQL, that behaves like ISQL and extends some of the SQL syntax, including directly referencing files in an INSERT command: INSERT INTO tab(id, blobfield) VALUES (1, @'c:\f.txt'); Sadly it's getting a bit old now, and it's Windows only. http://mujweb.cz/iprenosil/interbase/fsql.htm Scott #yiv5317166311 #yiv5317166311 -- #yiv5317166311ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5317166311 #yiv5317166311ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5317166311 #yiv5317166311ygrp-mkp #yiv5317166311hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5317166311 #yiv5317166311ygrp-mkp #yiv5317166311ads {margin-bottom:10px;}#yiv5317166311 #yiv5317166311ygrp-mkp .yiv5317166311ad {padding:0 0;}#yiv5317166311 #yiv5317166311ygrp-mkp .yiv5317166311ad p {margin:0;}#yiv5317166311 #yiv5317166311ygrp-mkp .yiv5317166311ad a {color:#ff;text-decoration:none;}#yiv5317166311 #yiv5317166311ygrp-sponsor #yiv5317166311ygrp-lc {font-family:Arial;}#yiv5317166311 #yiv5317166311ygrp-sponsor #yiv5317166311ygrp-lc #yiv5317166311hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5317166311 #yiv5317166311ygrp-sponsor #yiv5317166311ygrp-lc .yiv5317166311ad {margin-bottom:10px;padding:0 0;}#yiv5317166311 #yiv5317166311actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5317166311 #yiv5317166311activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5317166311 #yiv5317166311activity span {font-weight:700;}#yiv5317166311 #yiv5317166311activity span:first-child {text-transform:uppercase;}#yiv5317166311 #yiv5317166311activity span a {color:#5085b6;text-decoration:none;}#yiv5317166311 #yiv5317166311activity span span {color:#ff7900;}#yiv5317166311 #yiv5317166311activity span .yiv5317166311underline {text-decoration:underline;}#yiv5317166311 .yiv5317166311attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5317166311 .yiv5317166311attach div a {text-decoration:none;}#yiv5317166311 .yiv5317166311attach img {border:none;padding-right:5px;}#yiv5317166311 .yiv5317166311attach label {display:block;margin-bottom:5px;}#yiv5317166311 .yiv5317166311attach label a {text-decoration:none;}#yiv5317166311 blockquote {margin:0 0 0 4px;}#yiv5317166311 .yiv5317166311bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5317166311 .yiv5317166311bold a {text-decoration:none;}#yiv5317166311 dd.yiv5317166311last p a {font-family:Verdana;font-weight:700;}#yiv5317166311 dd.yiv5317166311last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5317166311 dd.yiv5317166311last p span.yiv5317166311yshortcuts {margin-right:0;}#yiv5317166311 div.yiv5317166311attach-table div div a {text-decoration:none;}#yiv5317166311 div.yiv5317166311attach-table {width:400px;}#yiv5317166311 div.yiv5317166311file-title a, #yiv5317166311 div.yiv5317166311file-title a:active, #yiv5317166311 div.yiv5317166311file-title a:hover, #yiv5317166311 div.yiv5317166311file-title a:visited {text-decoration:none;}#yiv5317166311 div.yiv5317166311photo-title a, #yiv5317166311 div.yiv5317166311photo-title a:active, #yiv5317166311 div.yiv5317166311photo-title a:hover, #yiv5317166311 div.yiv5317166311photo-title a:visited {text-decoration:none;}#yiv5317166311 div#yiv5317166311ygrp-mlmsg #yiv5317166311ygrp-msg p a span.yiv5317166311yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5317166311 .yiv5317166311green {color:#628c2a;}#yiv5317166311 .yiv5317166311MsoNormal {margin:0 0 0 0;}#yiv5317166311 o {font-size:0;}#yiv5317166311 #yiv5317166311photos div {float:left;width:72px;}#yiv5317166311 #yiv5317166311photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv5317166311 #yiv5317166311photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5317166311 #yiv5317166311reco-category {font-size:77%;}#yiv5317166311 #yiv5317166311reco-desc {font-size:77%;}#yiv5317166311 .yiv5317166311replbq {margin:4px;}#yiv5317166311 #yiv5317166311ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5317166311 #yiv5317166311ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5317166311 #yiv5317166311ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5317166311 #yiv5317166311ygrp-mlmsg select, #yiv5317166311 input, #yiv5317166311 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5317166311 #yiv5317166311ygrp-mlmsg pre, #yiv5317166311
Re: AW: [firebird-support] High number of NULL attachments
Great, Thanks! Sent from Yahoo Mail. Get the app On Tuesday, October 4, 2016 1:04 PM, "'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]" wrote: > fbclient.dll is bundled with the client application. If I remember correctly, you need a client library 2.1+ to get that information popping up in MON$ATTACHMENTS -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > > -Tom > > On Tue, October 4, 2016 10:14 am, 'Gregor Kobler' g...@gksoft.ch > [firebird-support] wrote: >> Does the Client uses the right fbclient.dll or GDS32.dll? >> >> >> >> >> >> Best Regards >> >> >> Gregor >> >> >> >> >> >> Von: firebird-support@yahoogroups.com >> [mailto:firebird-support@yahoogroups.com] >> Gesendet: Dienstag, 4. Oktober 2016 08:41 >> An: firebird-support@yahoogroups.com >> Betreff: [firebird-support] High number of NULL attachments >> >> >> >> >> >> >> >> >> Hi all. >> >> >> I am running a FB 2.5.3 server to which a delphi application connects. We >> usually have 20-30 concurrent connections. >> I have inspected the MON$ATTACHMENTS table and noticed many of the records >> have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in >> MON$REMOTE_ADDRESS. >> >> >> Does that mean that the connection to the server is still open even if the >> application isn't? How can I mitigate that? >> Thanks. >> >> >> -Tom >> >> >> >> >> >> >> > > > > > > Posted by: "Tom" > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > > ++ > > > Yahoo Groups Links > > > #yiv2603786793 #yiv2603786793 -- #yiv2603786793ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2603786793 #yiv2603786793ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2603786793 #yiv2603786793ygrp-mkp #yiv2603786793hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2603786793 #yiv2603786793ygrp-mkp #yiv2603786793ads {margin-bottom:10px;}#yiv2603786793 #yiv2603786793ygrp-mkp .yiv2603786793ad {padding:0 0;}#yiv2603786793 #yiv2603786793ygrp-mkp .yiv2603786793ad p {margin:0;}#yiv2603786793 #yiv2603786793ygrp-mkp .yiv2603786793ad a {color:#ff;text-decoration:none;}#yiv2603786793 #yiv2603786793ygrp-sponsor #yiv2603786793ygrp-lc {font-family:Arial;}#yiv2603786793 #yiv2603786793ygrp-sponsor #yiv2603786793ygrp-lc #yiv2603786793hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2603786793 #yiv2603786793ygrp-sponsor #yiv2603786793ygrp-lc .yiv2603786793ad {margin-bottom:10px;padding:0 0;}#yiv2603786793 #yiv2603786793actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2603786793 #yiv2603786793activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2603786793 #yiv2603786793activity span {font-weight:700;}#yiv2603786793 #yiv2603786793activity span:first-child {text-transform:uppercase;}#yiv2603786793 #yiv2603786793activity span a {color:#5085b6;text-decoration:none;}#yiv2603786793 #yiv2603786793activity span span {color:#ff7900;}#yiv2603786793 #yiv2603786793activity span .yiv2603786793underline {text-decoration:underline;}#yiv2603786793 .yiv2603786793attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2603786793 .yiv2603786793attach div a {text-decoration:none;}#yiv2603786793 .yiv2603786793attach img {border:none;padding-right:5px;}#yiv2603786793 .yiv2603786793attach label {display:block;margin-bottom:5px;}#yiv2603786793 .yiv2603786793attach label a {text-decoration:none;}#yiv2603786793 blockquote {margin:0 0 0 4px;}#yiv2603786793 .yiv2603786793bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2603786793 .yiv2603786793bold a {text-decoration:none;}#yiv2603786793 dd.yiv2603786793last p a {font-family:Verdana;font-weight:700;}#yiv2603786793 dd.yiv2603786793last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2603786793 dd.yiv2603786793last p span.yiv2603786793yshortcuts {margin-right:0;}#yiv2603786793 div.yiv2603786793attach-table div div a {text-decoration:none;}#yiv2603786793 div.yiv2603786793attach-table {width:400px;}#yiv2603786793 div.yiv2603786793file-title a, #yiv2603786793 div.yiv2603786793file-title a:active, #yiv2603786793 div.yiv2603786793file-title a:hover, #yiv2603786793 div.yiv2603786793file-title a:visited {text-decoration:none;}#yiv2603786793 div.yiv2603786793photo-title a, #yiv2603786793 div.yiv2603786793photo-title a
Re: [firebird-support] Re: internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239)
Thank you Sent from Yahoo Mail. Get the app On Tuesday, October 4, 2016 1:17 PM, "n6auei4hz6ypittow3d2xkak432y2oszb2gth...@yahoo.com [firebird-support]" wrote: We shouldn't do. Just single big file in the first case, and a fairly small 500MB one in the second. #yiv2669714009 #yiv2669714009 -- #yiv2669714009ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2669714009 #yiv2669714009ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2669714009 #yiv2669714009ygrp-mkp #yiv2669714009hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2669714009 #yiv2669714009ygrp-mkp #yiv2669714009ads {margin-bottom:10px;}#yiv2669714009 #yiv2669714009ygrp-mkp .yiv2669714009ad {padding:0 0;}#yiv2669714009 #yiv2669714009ygrp-mkp .yiv2669714009ad p {margin:0;}#yiv2669714009 #yiv2669714009ygrp-mkp .yiv2669714009ad a {color:#ff;text-decoration:none;}#yiv2669714009 #yiv2669714009ygrp-sponsor #yiv2669714009ygrp-lc {font-family:Arial;}#yiv2669714009 #yiv2669714009ygrp-sponsor #yiv2669714009ygrp-lc #yiv2669714009hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2669714009 #yiv2669714009ygrp-sponsor #yiv2669714009ygrp-lc .yiv2669714009ad {margin-bottom:10px;padding:0 0;}#yiv2669714009 #yiv2669714009actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2669714009 #yiv2669714009activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2669714009 #yiv2669714009activity span {font-weight:700;}#yiv2669714009 #yiv2669714009activity span:first-child {text-transform:uppercase;}#yiv2669714009 #yiv2669714009activity span a {color:#5085b6;text-decoration:none;}#yiv2669714009 #yiv2669714009activity span span {color:#ff7900;}#yiv2669714009 #yiv2669714009activity span .yiv2669714009underline {text-decoration:underline;}#yiv2669714009 .yiv2669714009attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2669714009 .yiv2669714009attach div a {text-decoration:none;}#yiv2669714009 .yiv2669714009attach img {border:none;padding-right:5px;}#yiv2669714009 .yiv2669714009attach label {display:block;margin-bottom:5px;}#yiv2669714009 .yiv2669714009attach label a {text-decoration:none;}#yiv2669714009 blockquote {margin:0 0 0 4px;}#yiv2669714009 .yiv2669714009bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2669714009 .yiv2669714009bold a {text-decoration:none;}#yiv2669714009 dd.yiv2669714009last p a {font-family:Verdana;font-weight:700;}#yiv2669714009 dd.yiv2669714009last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2669714009 dd.yiv2669714009last p span.yiv2669714009yshortcuts {margin-right:0;}#yiv2669714009 div.yiv2669714009attach-table div div a {text-decoration:none;}#yiv2669714009 div.yiv2669714009attach-table {width:400px;}#yiv2669714009 div.yiv2669714009file-title a, #yiv2669714009 div.yiv2669714009file-title a:active, #yiv2669714009 div.yiv2669714009file-title a:hover, #yiv2669714009 div.yiv2669714009file-title a:visited {text-decoration:none;}#yiv2669714009 div.yiv2669714009photo-title a, #yiv2669714009 div.yiv2669714009photo-title a:active, #yiv2669714009 div.yiv2669714009photo-title a:hover, #yiv2669714009 div.yiv2669714009photo-title a:visited {text-decoration:none;}#yiv2669714009 div#yiv2669714009ygrp-mlmsg #yiv2669714009ygrp-msg p a span.yiv2669714009yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2669714009 .yiv2669714009green {color:#628c2a;}#yiv2669714009 .yiv2669714009MsoNormal {margin:0 0 0 0;}#yiv2669714009 o {font-size:0;}#yiv2669714009 #yiv2669714009photos div {float:left;width:72px;}#yiv2669714009 #yiv2669714009photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv2669714009 #yiv2669714009photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2669714009 #yiv2669714009reco-category {font-size:77%;}#yiv2669714009 #yiv2669714009reco-desc {font-size:77%;}#yiv2669714009 .yiv2669714009replbq {margin:4px;}#yiv2669714009 #yiv2669714009ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2669714009 #yiv2669714009ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2669714009 #yiv2669714009ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2669714009 #yiv2669714009ygrp-mlmsg select, #yiv2669714009 input, #yiv2669714009 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2669714009 #yiv2669714009ygrp-mlmsg pre, #yiv2669714009 code {font:115% monospace;}#yiv2669714009 #yiv2669714009ygrp-mlmsg * {line-height:1.22em;}#yiv2669714009 #yiv2669714009ygrp-mlmsg #yiv2669714009logo {padding-bottom:10px;}#yiv2669714009 #yiv2669714009ygrp-msg p a {font-family:Verdana;}#yiv2669714009 #yiv2669714009ygrp-msg p#yiv2669714009attach-count span {color:#1E66AE;font-weight:700;}#yiv2669714009 #yiv2669714009
Re: AW: AW: [firebird-support] High number of NULL attachments
Perfect Sent from Yahoo Mail. Get the app On Tuesday, October 4, 2016 8:26 PM, "'Gregor Kobler' g...@gksoft.ch [firebird-support]" wrote: OK, but are the version of the bundled (client) dll compared to the dll comes with FB2.5.3 are the same? Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Dienstag, 4. Oktober 2016 11:39 An: firebird-support@yahoogroups.com Betreff: Re: AW: [firebird-support] High number of NULL attachments fbclient.dll is bundled with the client application. -Tom On Tue, October 4, 2016 10:14 am, 'Gregor Kobler' g...@gksoft.ch [firebird-support] wrote: > Does the Client uses the right fbclient.dll or GDS32.dll? > > > > > > Best Regards > > > Gregor > > > > > > Von: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Gesendet: Dienstag, 4. Oktober 2016 08:41 > An: firebird-support@yahoogroups.com > Betreff: [firebird-support] High number of NULL attachments > > > > > > > > > Hi all. > > > I am running a FB 2.5.3 server to which a delphi application connects. We > usually have 20-30 concurrent connections. > I have inspected the MON$ATTACHMENTS table and noticed many of the records > have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in > MON$REMOTE_ADDRESS. > > > Does that mean that the connection to the server is still open even if the > application isn't? How can I mitigate that? > Thanks. > > > -Tom > > > > > > > #yiv4816030198 #yiv4816030198 -- #yiv4816030198ygrp-mkp {border:1px solid > #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4816030198 > #yiv4816030198ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4816030198 > #yiv4816030198ygrp-mkp #yiv4816030198hd > {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px > 0;}#yiv4816030198 #yiv4816030198ygrp-mkp #yiv4816030198ads > {margin-bottom:10px;}#yiv4816030198 #yiv4816030198ygrp-mkp .yiv4816030198ad > {padding:0 0;}#yiv4816030198 #yiv4816030198ygrp-mkp .yiv4816030198ad p > {margin:0;}#yiv4816030198 #yiv4816030198ygrp-mkp .yiv4816030198ad a > {color:#ff;text-decoration:none;}#yiv4816030198 > #yiv4816030198ygrp-sponsor #yiv4816030198ygrp-lc > {font-family:Arial;}#yiv4816030198 #yiv4816030198ygrp-sponsor > #yiv4816030198ygrp-lc #yiv4816030198hd {margin:10px > 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4816030198 > #yiv4816030198ygrp-sponsor #yiv4816030198ygrp-lc .yiv4816030198ad > {margin-bottom:10px;padding:0 0;}#yiv4816030198 #yiv4816030198actions > {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4816030198 > #yiv4816030198activity > {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4816030198 > #yiv4816030198activity span {font-weight:700;}#yiv4816030198 > #yiv4816030198activity span:first-child > {text-transform:uppercase;}#yiv4816030198 #yiv4816030198activity span a > {color:#5085b6;text-decoration:none;}#yiv4816030198 #yiv4816030198activity > span span {color:#ff7900;}#yiv4816030198 #yiv4816030198activity span > .yiv4816030198underline {text-decoration:underline;}#yiv4816030198 > .yiv4816030198attach > {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px > 0;width:400px;}#yiv4816030198 .yiv4816030198attach div a > {text-decoration:none;}#yiv4816030198 .yiv4816030198attach img > {border:none;padding-right:5px;}#yiv4816030198 .yiv4816030198attach label > {display:block;margin-bottom:5px;}#yiv4816030198 .yiv4816030198attach label a > {text-decoration:none;}#yiv4816030198 blockquote {margin:0 0 0 > 4px;}#yiv4816030198 .yiv4816030198bold > {font-family:Arial;font-size:13px;font-weight:700;}#yiv4816030198 > .yiv4816030198bold a {text-decoration:none;}#yiv4816030198 > dd.yiv4816030198last p a {font-family:Verdana;font-weight:700;}#yiv4816030198 > dd.yiv4816030198last p span > {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4816030198 > dd.yiv4816030198last p span.yiv4816030198yshortcuts > {margin-right:0;}#yiv4816030198 div.yiv4816030198attach-table div div a > {text-decoration:none;}#yiv4816030198 div.yiv4816030198attach-table > {width:400px;}#yiv4816030198 div.yiv4816030198file-title a, #yiv4816030198 > div.yiv4816030198file-title a:active, #yiv4816030198 > div.yiv4816030198file-title a:hover, #yiv4816030198 > div.yiv4816030198file-title a:visited {text-decoration:none;}#yiv4816030198 > div.yiv4816030198photo-title a, #yiv4816030198 div.yiv4816030198photo-title > a:active, #yiv4816030198 div.yiv4816030198photo-title a:hover, #yiv4816030198 > div.yiv4816030198photo-title a:visited {text-decoration:none;}#yiv4816030198 > div#yiv4816030198ygrp-mlmsg #yiv4816030198ygrp-msg p a > span.yiv4816030198yshortcuts > {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4816030198 > .yiv4816030198green {color:#628c2a;}#yiv4816030198 .yiv4816030198MsoNormal > {margin:0 0 0 0;}#yiv4816030198 o {font-size:0;}#yiv4816030198 > #yiv4816030198photos div {float:left;
Re: AW: AW: [firebird-support] High number of NULL attachments
Great, Thanks! Sent from Yahoo Mail. Get the app On Wednesday, October 5, 2016 4:18 AM, "monteropetronila...@yahoo.com [firebird-support]" wrote: Perfect Sent from Yahoo Mail. Get the app On Tuesday, October 4, 2016 8:26 PM, "'Gregor Kobler' g...@gksoft.ch [firebird-support]" wrote: OK, but are the version of the bundled (client) dll compared to the dll comes with FB2.5.3 are the same? Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Dienstag, 4. Oktober 2016 11:39 An: firebird-support@yahoogroups.com Betreff: Re: AW: [firebird-support] High number of NULL attachments fbclient.dll is bundled with the client application. -Tom On Tue, October 4, 2016 10:14 am, 'Gregor Kobler' g...@gksoft.ch [firebird-support] wrote: > Does the Client uses the right fbclient.dll or GDS32.dll? > > > > > > Best Regards > > > Gregor > > > > > > Von: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Gesendet: Dienstag, 4. Oktober 2016 08:41 > An: firebird-support@yahoogroups.com > Betreff: [firebird-support] High number of NULL attachments > > > > > > > > > Hi all. > > > I am running a FB 2.5.3 server to which a delphi application connects. We > usually have 20-30 concurrent connections. > I have inspected the MON$ATTACHMENTS table and noticed many of the records > have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in > MON$REMOTE_ADDRESS. > > > Does that mean that the connection to the server is still open even if the > application isn't? How can I mitigate that? > Thanks. > > > -Tom > > > > > > > #yiv7816251684 #yiv7816251684 -- #yiv7816251684ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7816251684 #yiv7816251684ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7816251684 #yiv7816251684ygrp-mkp #yiv7816251684hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7816251684 #yiv7816251684ygrp-mkp #yiv7816251684ads {margin-bottom:10px;}#yiv7816251684 #yiv7816251684ygrp-mkp .yiv7816251684ad {padding:0 0;}#yiv7816251684 #yiv7816251684ygrp-mkp .yiv7816251684ad p {margin:0;}#yiv7816251684 #yiv7816251684ygrp-mkp .yiv7816251684ad a {color:#ff;text-decoration:none;}#yiv7816251684 #yiv7816251684ygrp-sponsor #yiv7816251684ygrp-lc {font-family:Arial;}#yiv7816251684 #yiv7816251684ygrp-sponsor #yiv7816251684ygrp-lc #yiv7816251684hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7816251684 #yiv7816251684ygrp-sponsor #yiv7816251684ygrp-lc .yiv7816251684ad {margin-bottom:10px;padding:0 0;}#yiv7816251684 #yiv7816251684actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7816251684 #yiv7816251684activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7816251684 #yiv7816251684activity span {font-weight:700;}#yiv7816251684 #yiv7816251684activity span:first-child {text-transform:uppercase;}#yiv7816251684 #yiv7816251684activity span a {color:#5085b6;text-decoration:none;}#yiv7816251684 #yiv7816251684activity span span {color:#ff7900;}#yiv7816251684 #yiv7816251684activity span .yiv7816251684underline {text-decoration:underline;}#yiv7816251684 .yiv7816251684attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7816251684 .yiv7816251684attach div a {text-decoration:none;}#yiv7816251684 .yiv7816251684attach img {border:none;padding-right:5px;}#yiv7816251684 .yiv7816251684attach label {display:block;margin-bottom:5px;}#yiv7816251684 .yiv7816251684attach label a {text-decoration:none;}#yiv7816251684 blockquote {margin:0 0 0 4px;}#yiv7816251684 .yiv7816251684bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7816251684 .yiv7816251684bold a {text-decoration:none;}#yiv7816251684 dd.yiv7816251684last p a {font-family:Verdana;font-weight:700;}#yiv7816251684 dd.yiv7816251684last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7816251684 dd.yiv7816251684last p span.yiv7816251684yshortcuts {margin-right:0;}#yiv7816251684 div.yiv7816251684attach-table div div a {text-decoration:none;}#yiv7816251684 div.yiv7816251684attach-table {width:400px;}#yiv7816251684 div.yiv7816251684file-title a, #yiv7816251684 div.yiv7816251684file-title a:active, #yiv7816251684 div.yiv7816251684file-title a:hover, #yiv7816251684 div.yiv7816251684file-title a:visited {text-decoration:none;}#yiv7816251684 div.yiv7816251684photo-title a, #yiv7816251684 div.yiv7816251684photo-title a:active, #yiv7816251684 div.yiv7816251684photo-title a:hover, #yiv7816251684 div.yiv7816251684photo-title a:visited {text-decoration:none;}#yiv7816251684 div#yiv7816251684ygrp-mlmsg #yiv7816251684ygrp-msg p a span.yiv78162