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
