Re: [firebird-support] 2 firebird versions in parallel ?

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 Hi,I don't know if that works on Linux but on Windows we are using v2.5 and 
3,you need to specify another port and instance name,maybe this will help 
you:How to install Firebird 3 as the second instance in 5 minutes


| 
| 
| 
|  |  |

 |

 |
| 
|  | 
How to install Firebird 3 as the second instance in 5 minutes

If you want to install Firebird 3 as the second instance (and keep existing 
installation of Firebird 2.5 intact)...
 |

 |

 |







On Friday, March 6, 2020, 12:48:02 PM GMT+2, Pro Turm protu...@mailbox.org 
[firebird-support]  wrote:  
 
     
 
 Hi, 
   I need for testing to run on Linux firebird3.0 and the firebird4.0beta in 
parallel. 
   
   Do you have any manual how this could be done? 
   
   Thanks! 
 

[firebird-support] avoid query subselect

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

HiI have a performance issue on a query where I need all parent record and from 
child table I only want a flag if there is any child record matching a 
condition,so I write something like that:

SELECT P.ID,IIF(SUB.ID IS NULL,0,1) AS ISDATA  FROM PARENT P   LEFT JOIN
    (SELECT FIRST 1 PA.ID FROM PARENT PA INNER JOIN CHILD C     ON 
C.ID_PARENT=PA.ID WHERE C.MYFIELD=3) SUB ON SUB.ID=A.ID
INNER JOIN TABLE3 T3 ON P.ID=T3.
INNER JOIN TABLE3 T4 ON P.ID=T4.
...

I can't use direct left join because for a parent could be more than one record

is there any way to replace subselect with something more efficient?
thanks

Re: [firebird-support] Help creating expression index

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 great solutionthanks!

On Wednesday, July 17, 2019, 06:59:44 PM GMT+3, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  wrote: 
 
 
 17.07.2019 17:54, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I want to create a index to improve a query like that:
>      SELECT * FROM MYTABLE WHERE EXTRACT(YEAR FROM datein)=2019  AND 
>EXTRACT(MONTH FROM 
> datein)=1

  Rewrite it as

SELECT * FROM MYTABLE WHERE datein between date '2019-01-01' and date 
'2019-02-01'

  Then you can create an ordinary index for datein.


-- 
  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



  

[firebird-support] Help creating expression index

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

HiI want to create a index to improve a query like that:    SELECT * FROM 
MYTABLE  WHERE EXTRACT(YEAR FROM datein)=2019  AND EXTRACT(MONTH FROM datein)=1

I can create this index:   CREATE DESCENDING MYINDEX ON MYTABLE  COMPUTED BY 
(EXTRACT(YEAR FROM datein) || EXTRACT(MONTH FROM datein) )
 and change the query:
   SELECT * FROM MYTABLE  WHERE EXTRACT(YEAR FROM datein)|| EXTRACT(MONTH FROM 
datein)='20191'

index is used,but don't think this is the solution


thanks for any help

Re: [firebird-support] query Integer overflow

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 thanks for the tip Dimitry

On Sunday, June 23, 2019, 11:38:04 AM GMT+3, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  wrote: 
 
 
 23.06.2019 5:41, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> The calculation is on a SP code and I need it there

  Then get rid of IIF and decide at which moment you need round intermediate 
values. Then 
cast the values to types with smaller precision.


-- 
  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] query Integer overflow

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 it is workingthanks

On Sunday, June 23, 2019, 10:00:20 AM GMT+3, Mark Rotteveel 
m...@lawinegevaar.nl [firebird-support]  
wrote:  
 
     
On 23-6-2019 05:59, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> 
> 
> the error is gone if I cast one of the values as integer (at this moment 
> there is no decimal needed for that field):
> 
> 
>   CAST (b.P_TV_E AS INTEGER)
> instead of
>  b.P_TV_E
> 
> 
>  SELECT   b.cant*  IIF(b.PR_EAT_T<>0, b.PR_EAT_T-b.PR_EAT_T *  CAST 
> (b.P_TV_E AS IN TEGER)   /(100+ CAST (b.P_TV_E AS INTEGER) ), b.PR_I)
>                  FROM GS_FIED a INNER JOIN GS_FIEP b on a.id=b.id_doc

You can also cast intermediate results to the desired (or sufficient) scale

b.PR_EAT_T-b.PR_EAT_T* cast(b.P_TV_E /(100+b.P_TV_E) as numeric(18,2))

etc...

-- 
Mark Rotteveel

Re: [firebird-support] query Integer overflow

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 the error is gone if I cast one of the values as integer (at this moment there 
is no decimal needed for that field):

   CAST (b.P_TV_E AS INTEGER)  
instead of  b.P_TV_E

 
 SELECT   b.cant*  IIF(b.PR_EAT_T<>0, b.PR_EAT_T-b.PR_EAT_T   *  CAST (b.P_TV_E 
AS INTEGER)   /(100+   CAST (b.P_TV_E AS INTEGER)    ), b.PR_I)                 
FROM GS_FIED a INNER JOIN GS_FIEP b on a.id=b.id_doc




On Sunday, June 23, 2019, 12:42:42 AM GMT+3, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  wrote: 
 
 
 22.06.2019 21:47, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I'm facing with this error on FB 2.5.8(latest stable version)/ W10 x64

  My advice is "never perform calculations (especially multiplication and 
division) in SQL".
  Your expression has result of type NUMERIC(18,14) and result of calculation 
is bigger 
than .


-- 
  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] query Integer overflow

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 The calculation is on a SP code and I need it there,worked for couple 
years..until that valuesthanks



On Sunday, June 23, 2019, 12:42:42 AM GMT+3, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  wrote: 
 
 
 22.06.2019 21:47, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I'm facing with this error on FB 2.5.8(latest stable version)/ W10 x64

  My advice is "never perform calculations (especially multiplication and 
division) in SQL".
  Your expression has result of type NUMERIC(18,14) and result of calculation 
is bigger 
than .


-- 
  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



  

[firebird-support] query Integer overflow

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

HiI'm facing with this error on FB 2.5.8(latest stable version)/ W10 x64:
Unsuccessful execution caused by system error that does not preclude successful 
execution of subsequent statements.Integer overflow.  The result of an integer 
operation caused the most significant bit of the result to carry.
on this query
      SELECT   b.cant*  IIF(b.PR_EAT_T<>0, b.PR_EAT_T-b.PR_EAT_T* b.P_TV_E 
/(100+b.P_TV_E), b.PR_I)                 FROM GS_FIED a INNER JOIN GS_FIEP b on 
a.id=b.id_doc
cant NUMERIC(15,4)
 PR_EAT_T NUMERIC(16,4)
P_TV_E  NUMERIC (9,2)
 PR_I NUMERIC(16,4)

I have 2 records with same values:
cant =5993.3160 PR_EAT_T=0.
P_TV_E=0.00 PR_I=  1580.3472

thanks

Re: [firebird-support] Re: Unsuccessful execution on delete FB 3 SP source code

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 no error now
thanks


On Thursday, June 13, 2019, 4:41:12 PM GMT+3, Dmitry Yemanov 
dim...@users.sourceforge.net [firebird-support] 
 wrote:  
 
     
13.06.2019 13:43, 'Mr. John' mr_joh...@yahoo.com wrote:

> Using FB 3.0.4/Windows 10x64 ,I'm trying to delete SP source code as 
> worked in 2.5:
>       UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL WHERE 
> RDB$SYSTEM_FLAG IS NULL  OR RDB$SYSTEM_FLAG=0;
> 
> bun now on FB 3 tried:
> 
> update RDB$PROCEDURES set rdb$procedure_source = NULL where 
> rdb$procedure_name
> STARTING WITH 'MYPR_'
> 
> and got
> Unsuccessful execution caused by a system error that precludes 
> successful execution of subsequent statement s.
> UPDATE operation is not allowed for system table RDB$PROCEDURES.

Try adding one more condition to your WHERE clause:

(...) and RDB$PROCEDURE_SOURCE is not null

Dmitry

[firebird-support] Unsuccessful execution on delete FB 3 SP source code

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Using FB 3.0.4/Windows 10x64 ,I'm trying to delete SP source code as worked in 
2.5:      UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL WHERE 
RDB$SYSTEM_FLAG IS NULL  OR RDB$SYSTEM_FLAG=0;
bun now on FB 3 tried:
update RDB$PROCEDURES set rdb$procedure_source = NULL where 
rdb$procedure_nameSTARTING WITH 'MYPR_'
and got Unsuccessful execution caused by a system error that precludes 
successful execution of subsequent statements.UPDATE operation is not allowed 
for system table RDB$PROCEDURES.
that seems to be fixed:  [#CORE-4507] Unable delete procedure source on 
Firebird 3.0 Alpha 2.0 - Firebird RDBMS Issue Tracker

| 
| 
| 
|  |  |

 |

 |
| 
|  | 
[#CORE-4507] Unable delete procedure source on Firebird 3.0 Alpha 2.0 - ...


 |

 |

 |



Dmitry Yemanov 
"The ability to explicitly set the source code to NULL is restored. All other 
kinds of direct modifications are still prohibited"

but not workingthanks for any help

Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 solved with something like thatthanks

On Wednesday, June 12, 2019, 5:50:52 PM GMT+3, Michel LE CLEZIO 
mlcvi...@yahoo.fr [firebird-support]  wrote:  
 
     

 Hello,
May be you build an empty Fb2.5 database with the same structure (Tables, 
Generators…)Export the FB3 datas into SQL...Adapt the sql.. and execute them 
into FB2.5...
With best regards,Mikey
Le mercredi 12 juin 2019 à 12:57:08 UTC+2, 'Mr.. John' mr_joh...@yahoo.com 
[firebird-support]  a écrit :  
 
     

 I've extracted db into a script,but when restoring got almost the same error: 
 Invalid token.Dynamic SQL Error.SQL error code = -104.Token unknown - line 1, 
column 36.START.
error is on every generator code:
 CREATE GENERATOR GEN_HT_MENT_ID START WITH 0 INCREMENT BY 1;
  SET GENERATOR GEN_HT_MENT_ID TO 1;
in my app I have no such code,for generators I used this:
CREATE GENERATOR GEN_HT_MENT_ID;SET GENERATOR GEN_HT_MENT_ID TO 1;

thanks




thanks
On Wednesday, June 12, 2019, 1:25:40 PM GMT+3, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  wrote: 
 
 
 12.06.2019 12:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> what other way I could use?

  Create database from scratch, pump data.


-- 
  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] invalid request BLR at offset 27, on restore FB 3 database to 2.5

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 I've extracted db into a script,but when restoring got almost the same error: 
 Invalid token.Dynamic SQL Error.SQL error code = -104.Token unknown - line 1, 
column 36.START.
error is on every generator code:
 CREATE GENERATOR GEN_HT_MENT_ID START WITH 0 INCREMENT BY 1;
  SET GENERATOR GEN_HT_MENT_ID TO 1;
in my app I have no such code,for generators I used this:
CREATE GENERATOR GEN_HT_MENT_ID;SET GENERATOR GEN_HT_MENT_ID TO 1;

thanks




thanks
On Wednesday, June 12, 2019, 1:25:40 PM GMT+3, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  wrote: 
 
 
 12.06.2019 12:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> what other way I could use?

  Create database from scratch, pump data.


-- 
  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] invalid request BLR at offset 27, on restore FB 3 database to 2.5

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 Hibased application is written for 2.5,just some test are done for Fb 3,in 
case something goes wrong, must go back to 2.5 until a fix is done,so that 
restore is need.thanks



On Wednesday, June 12, 2019, 1:00:33 PM GMT+3, Michel LE CLEZIO 
mlcvi...@yahoo.fr [firebird-support]  wrote:  
 
     

 Hello,
I know that FB2.5 to F3.0 is possible :First do backup under FB2.5 and after 
restore under FB3...
But I may not understand your problem : do you want to do an FB3 -> FB2.5 
restore ?IF yes I may presume this is impossible… I'm right ?
With best Regards,Mickey
Le mercredi 12 juin 2019 à 11:50:55 UTC+2, 'Mr.. John' mr_joh...@yahoo.com 
[firebird-support]  a écrit :  
 
     

HiI'm trying to restore a FB 3 database to 2.5Before fb3 backup,I copy from 2.5 
gbak.exe to gbak2.exe into FB3 folderthen run 
gbak2.exe -v -b "d:\db3.fdb" "d:\dbbk.gbk"  -user SYSDBA -pass "mypass"

backup is done with no erorrs
I can restore it again to fb3 with no error but when I restore it to Fb2.5 I 
got this: 
 Starting restore. Current time: 12:25:06 PM Invalid token.     invalid request 
BLR at offset 27.     BLR syntax error: expected valid BLR code at offset 28, 
encountered 210.     Exiting before completion due to errors.   Restore 
completed. Current time: 12:25:08 PM. Elapsed time: 00:00:01



restore is done from IBExpert 
thanks

Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 hi the based application is written for 2.5 and then compiled for fb3,no new 
fb 3 field type or code,the only thing done is that new SP code  
protection/remove: 
 update RDB$PROCEDURES set rdb$procedure_source = NULL where rdb$procedure_name 
STARTING WITH 

instead of 2.5
    UPDATE RDB$TRIGGERS SET RDB$TRIGGER_SOURCE = NULL WHERE RDB$SYSTEM_FLAG IS 
NULL  OR RDB$SYSTEM_FLAG=0;    UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = 
NULL WHERE RDB$SYSTEM_FLAG IS NULL   OR RDB$SYSTEM_FLAG=0;

what other way I could use?
thanks




On Wednesday, June 12, 2019, 12:55:20 PM GMT+3, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  wrote: 
 
 
 12.06.2019 11:38, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
>   Invalid token.
>       invalid request BLR at offset 27.
>       BLR syntax error: expected valid BLR code at offset 28, encou ntered 
>210.

  This database obviously used some new features of Firebird 3 in stored code. 
It cannot 
be downgraded by backup-restore. Use other ways.


-- 
  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



  

[firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

HiI'm trying to restore a FB 3 database to 2.5Before fb3 backup,I copy from 2.5 
gbak.exe to gbak2.exe into FB3 folderthen run 
gbak2.exe -v -b "d:\db3.fdb" "d:\dbbk.gbk"  -user SYSDBA -pass "mypass"

backup is done with no erorrs
I can restore it again to fb3 with no error but when I restore it to Fb2.5 I 
got this: 
 Starting restore. Current time: 12:25:06 PM Invalid token.     invalid request 
BLR at offset 27.     BLR syntax error: expected valid BLR code at offset 28, 
encountered 210.     Exiting before completion due to errors.   Restore 
completed. Current time: 12:25:08 PM. Elapsed time: 00:00:01



restore is done from IBExpert 
thanks

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 the vps is only for test,no extra connection to dbCPU is 0%,memory 60%

If need I can give access to databases/vps
thanks

On Monday, March 4, 2019, 7:32:21 PM GMT+2, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  wrote: 
 
 
 04.03.2019 18:11, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
>  > In this case you must done something really wrong.
> 
> Claiming some must have done something really wrong without clear
> evidence is not really constructive.

  Yes, but without real data it is impossible to say what's wrong. My crystal 
ball is not 
good enough for that.
  May be increasing of network buffer size was an error, may be RAM was 
exhausted by 
already run PG and MySQL, may be ICU library is missing or may be client-side 
tool used 
for query execution is not suitable for high-latency network. Too much variants.
  I already suggested to use system monitoring tools but it is perhaps too 
complex for 
the author.


-- 
  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: ODP: [firebird-support] Turn on WireCompression on Firebird 3

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 that's the change done: I've installed Firebird 3.0.4 x64, changes made in 
firebird.conf:    TcpRemoteBufferSize = 32767 WireCompression = true + restart 
firebird service



On Monday, March 4, 2019, 7:03:06 PM GMT+2, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  wrote: 
 
 
 04.03.2019 17:57, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> yes

  In this case you must done something really wrong.


-- 
  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: ODP: [firebird-support] Turn on WireCompression on Firebird 3

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 yes
On Monday, March 4, 2019, 6:55:12 PM GMT+2, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  wrote: 
 
 
 04.03.2019 17:39, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> As I mentioned in my first post I run that query for 15 times for each sever 
> FB,PG,mysql.

  Are all of them installed and run on the same virtual host?


-- 
  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: ODP: [firebird-support] Turn on WireCompression on Firebird 3

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 Hi
where have you  run and got 0.078s?As I mentioned in my first post I run that 
query for 15 times for each sever FB,PG,mysql.tested from 2 different 
computers/internet connectionswhy PG and mysql works fine? PG is almost x40 
times faster?



On Monday, March 4, 2019, 6:06:17 PM GMT+2, Karol Bieniaszewski 
liviusliv...@poczta.onet.pl [firebird-support] 
 wrote:  
 
     


Hi.

  

This is not Firebird issue. 

You must look into something between.

For me first run is:

Total execution time: 0.078s

Second buffered is:

Total execution time: 0.000s

  

3 seconds is really long time. There must be something involved between.

3 seconds on even 1RPM HDD is also long..

  

Regards,

Karol Bieniaszewski

Re: [firebird-support] Turn on WireCompression on Firebird 3

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 got "WI-V3.0.4.33054 Firebird 3.0/tcp (WIN-CNVKF3V883H)/P13:Z",so compression 
is enabled
there other server tweaks to improve the performance for my case?
thanks

On Monday, March 4, 2019, 11:12:45 AM GMT+2, Mark Rotteveel 
m...@lawinegevaar.nl [firebird-support]  
wrote:  
 
     
On 4-3-2019 10:06, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I'm using latest version 6.5.0
> found no isc_database_info item isc_info_firebird_version; 
> in FbConnection.ServerVersion.

That is not what I meant... The request to Firebird server is done using 
the isc_database_info operation, requesting information item 
isc_info_firebird_version. This is done behind the surface by the 
Firebird ADO.net provider when it opens a connection. The value is 
returned from the property ServerVersion of your connection.

For example the code on my machine prints "WI-V3.0.4.33054 Firebird 
3.0/tcp (Ramona)/P13:Z" which means compression is enabled:

var connectionString = new FbConnectionStringBuilder
{
 Database = @"D:\data\db\fb3\fb3testdatabase.fdb",
 UserID = "sysdba",
 Password = "masterkey",
 Compression = true
}.ToString();

using (var connection = new FbConnection(connectionString))
{
 connection.Open();
 Console.WriteLine(connection.ServerVersion);
}

Mark

-- 
Mark Rotteveel

Re: [firebird-support] Turn on WireCompression on Firebird 3

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 HiI'm using latest version 6.5.0 found no isc_database_info item 
isc_info_firebird_version; in FbConnection.ServerVersion.
thanks

On Monday, March 4, 2019, 10:52:43 AM GMT+2, Mark Rotteveel 
m...@lawinegevaar.nl [firebird-support]  
wrote:  
 
     
On 4-3-2019 08:13, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
>  I've installed Firebird 3.0.4 x64 on VPS,and got slow performance with 
> our app
>  changes made in firebird.conf:
>     TcpRemoteBufferSize = 32767
> WireCompression = true
> + restart firebird service

The WireCompression setting does nothing for the server. It is a 
fbclient-only setting, and generally clients do not read the 
firebird.conf of the server.

> in client connection (.NET connector): I put
>    Compression=True
> I have zlib1.dll in app folder

Firebird's zlib1.dll is not used by the Firebird ADO.net provider, it 
has the compression built-in.

Also, which Firebird ado.net provider version? Support was introduced in 
5.5.0 IIRC. In any case, your question might be more suitable for the 
firebird-net-provider Google group.

> I've installed also mysql 8 and postgres 11(with default configuration 
> ),and setup a simple table with 10 records for each
> 
> 
> CREATE TABLE city (
>   ID bigint NOT NULL,
>   Name CHAR(35) NOT NULL,
>   PRIMARY KEY (ID)
> );
> 
> INSERT INTO city VALUES (1,'Kabul');
> INSERT INTO city VALUES (2,'Qandahar');
> INSERT INTO city VALUES (3,'Herat');
> INSERT INTO city VALUES (4,'Mazar-e-Sharif');
> INSERT INTO city VALUES (5,'Amsterdam');
> INSERT INTO city VALUES (6,'Rotterdam');
> INSERT INTO city VALUES (7,'Haag');

Unrelated to your problem, but if this is meant to be the Dutch city 
that is the seat of government, then it is Den Haag (or 's-Gravenhage if 
you prefer the old-fashioned name).

> INSERT INTO city VALUES (8,'Utrecht');
> INSERT INTO city VALUES (9,'Eindhoven');
> INSERT INTO city VALUES (10,'Tilburg');
> 
> I've run this query for 15 times on every server:
> SELECT first 1 name from city where id=5 (fb)
> select name from city where id=5 limit 1 (mysql+pg)
> 
>  and got this result:
> 
> firebird:    3.082 2 sec
> postgres : 0.0754 sec
> mysql:      0.0874 sec
> as seen fb is much slower,with or without WireCompression I see no 
> change the result is identical,seems to me that WireCompression is not 
> turned on
> 
> any help there?

I'm not sure this can be taken as an indication that wire compression is 
enabled or not. In Firebird 3, to determine this you can check the 
isc_database_info item isc_info_firebird_version; which is exposed in 
Firebird ado.net on FbConnection.ServerVersion.

For example, when compression is not enabled, it will return:

WI-V3.0.4.33054 Firebird 3.0/tcp (Ramona)/P13

When it is enabled, it will return:

WI-V3.0.4.33054 Firebird 3.0/tcp (Ramona)/P13:Z

(Z for zlib)

Mark
-- 
Mark Rotteveel

[firebird-support] Turn on WireCompression on Firebird 3

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi. I've installed Firebird 3.0.4 x64 on VPS,and got slow performance with our 
app changes made in firebird.conf:    TcpRemoteBufferSize = 32767 
WireCompression = true + restart firebird service  in client connection (.NET 
connector): I put     Compression=True I have zlib1.dll in app folder   
I've installed also mysql 8 and postgres 11(with default configuration ),and 
setup a simple table with 10 records for each

CREATE TABLE city (  ID bigint NOT NULL,  Name CHAR(35) NOT NULL,  PRIMARY KEY 
(ID)); 
INSERT INTO city VALUES (1,'Kabul');INSERT INTO city VALUES 
(2,'Qandahar');INSERT INTO city VALUES (3,'Herat');INSERT INTO city VALUES 
(4,'Mazar-e-Sharif');INSERT INTO city VALUES (5,'Amsterdam');INSERT INTO city 
VALUES (6,'Rotterdam');INSERT INTO city VALUES (7,'Haag');INSERT INTO city 
VALUES (8,'Utrecht');INSERT INTO city VALUES (9,'Eindhoven');INSERT INTO city 
VALUES (10,'Tilburg');
I've run this query for 15 times on every server:SELECT first 1 name from city 
where id=5 (fb)
select name from city where id=5 limit 1 (mysql+pg)

 and got this result:
firebird:    3.0822 secpostgres : 0.0754 secmysql:      0.0874 sec as seen fb 
is much slower,with or without WireCompression I see no change the result is 
identical,seems to me that WireCompression is not turned on
any help there?thanks 

Re: [firebird-support] Deactivate triggers inside EXECUTE BLOCK

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

 thanks
On Monday, May 7, 2018, 12:43:40 PM GMT+3, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: 
 
 
 07.05.2018 7:43, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I'm looking for a way to run a simple update on couple tables without calling 
> triggers

  Modify your trigger to check some context variable and skip actions. Then do 
something 
like that:

EXECUTE BLOCK AS
declare variable dummy integer;
BEGIN
  dummy = RDB$SET_CONTEXT('USER_TRANSACTION', 'DO_NOT_FIRE_TRIGGERS', 'YES');
  UPDATE TABLE1 set FIELD1=0 WHERE FIELD1=1;
  dummy = RDB$SET_CONTEXT('USER_TRANSACTION', 'DO_NOT_FIRE_TRIGGERS', 'NO');
END


-- 
  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



  

[firebird-support] Deactivate triggers inside EXECUTE BLOCK

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi.I'm looking for a way to run a simple update on couple tables without 
calling triggers,something like this:
EXECUTE BLOCK ASBEGIN EXECUTE STATEMENT 'update RDB$TRIGGERS set 
rdb$trigger_inactive=1 where RDB$RELATION_NAME=''TABLE1'' ';   UPDATE TABLE1 
set FIELD1=0 WHERE FIELD1=1; EXECUTE STATEMENT 'update RDB$TRIGGERS set 
rdb$trigger_inactive=0 where RDB$RELATION_NAME=''TABLE1'' ';END

but doesn't workthanks

Re: [firebird-support] Firebird shows previous timezone after that was changed

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Restarting fb service seems to solve this

On Monday, June 12, 2017, 10:53:46 AM GMT+3, 'Mr. John' mr_joh...@yahoo.com 
[firebird-support] <firebird-support@yahoogroups.com> wrote:

    

Hi on a Windows 10 x64 server timezone was changed 24 hours ago,but firebird 
(2.5.7) still shows date and time from older  timezone when running: select 
current_date, current_timestamp from rdb$database;
how to make it give current values?
thanks  
  

[firebird-support] Firebird shows previous timezone after that was changed

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi on a Windows 10 x64 server timezone was changed 24 hours ago,but firebird 
(2.5.7) still shows date and time from older  timezone when running: select 
current_date, current_timestamp from rdb$database;
how to make it give current values?
thanks  

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

hiwhen I've installed the server it was checked the option to copy client 
library to system folder

in FB 3select * from MYTABLE where id=200 
takes 6 seconds

select rdb$get_context('SYSTEM','ENGINE_VERSION') from rdb$database

result: 3.0.2
for  'select * from Mon$Attachments' iused flamerobin to export result as csv:
MON$ATTACHMENT_ID;MON$SERVER_PID;MON$STATE;MON$ATTACHMENT_NAME;MON$USER;MON$ROLE;MON$REMOTE_PROTOCOL;MON$REMOTE_ADDRESS;MON$REMOTE_PID;MON$CHARACTER_SET_ID;MON$TIMESTAMP;MON$GARBAGE_COLLECTION;MON$REMOTE_PROCESS;MON$STAT_ID;MON$CLIENT_VERSION;MON$REMOTE_VERSION;MON$REMOTE_HOST;MON$REMOTE_OS_USER;MON$AUTH_METHOD;MON$SYSTEM_FLAG39;1788;0;C:\DATA\MYDB.FDB;Cache
 Writer                   ;NULL;NULL;NULL;NULL;0;15.04.2017, 
04:06:34.502;1;NULL;22;NULL;NULL;NULL;NULL;NULL;140;1788;0;C:\DATA\MYDB.FDB;Garbage
 Collector              ;NULL;NULL;NULL;NULL;0;15.04.2017, 
04:06:34.502;1;NULL;23;NULL;NULL;NULL;NULL;NULL;141;1788;1;C:\DATA\MYDB.FDB;SYSDBA
                         ;NONE                           
;TCPv4;5.14.8.63/2277;5680;0;15.04.2017, 04:06:34.399;1;C:\Program 
Files\FlameRobin (x64)\flamerobin.exe;24;WI-V3.0.2.32703 Firebird 
3.0;P15;desktop-udep1s6;user;Srp;0

thanks

  From: "Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]" 
<firebird-support@yahoogroups.com>
 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 11:22 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
    And did you update client library as well?

please run this sql in isql and post here result:

select * from Mon$Attachments

and for sure

select rdb$get_context('SYSTEM','ENGINE_VERSION') from rdb$database

Slavek

Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
--
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
--
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopa...@elektlabs.cz
http://www.elektlabs.cz

On 14.4.2017 22:05, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I've done tests with fb3 (only by flamerobin) but the same results as 2.5
>
> From: "Alexey Kovyazin a...@ib-aid.com [firebird-support]" 
> <firebird-support@yahoogroups.com>
> To: firebird-support@yahoogroups.com
> Sent: Friday, April 14, 2017 11:01 PM
> Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
> 2012 VPS
> 
> Hi,
> 
> Migrate to Firebird 3 - it has protocol improvements for high latency 
> networks.
> With 2.5 you will never reach such good results as with FB3.
> 
> Regards,
> Alexey Kovyazin
> IBSurgeon www.ib-aid.com
> 
> 
> 
> 
> 
> 
> Hi. I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPS From 
> tests,remote access database works slow,a simple query on a small table with 
> about 500 records
> select * from MYTABLE where id=200
> takes Total execution time: 5.388s
> PLAN (MYTABLE INDEX (PK_MYTABLE))
> the same query executed local on the server(same db,server) takes 0.065s
> queries are done with Flamerobin,from IBExpert the same results
> How can I improve remote speed? Thanks
> 
> 
> #yiv7322016214 #yiv7322016214 -- #yiv7322016214ygrp-mkp {border:1px solid 
> #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7322016214 
> #yiv7322016214ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7322016214 
> #yiv7322016214ygrp-mkp #yiv7322016214hd 
> {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
> 0;}#yiv7322016214 #yiv7322016214ygrp-mkp #yiv7322016214ads 
> {margin-bottom:10px;}#yiv7322016214 #yiv7322016214ygrp-mkp .yiv7322016214ad 
> {padding:0 0;}#yiv7322016214 #yiv7322016214ygrp-mkp .yiv7322016214ad p 
> {margin:0;}#yiv7322016214 #yiv7322016214ygrp-mkp .yiv7322016214ad a 
> {color:#ff;text-decoration:none;}#yiv7322016214 
> #yiv7322016214ygrp-sponsor #yiv7322016214ygrp-lc 
> {font-family:Arial;}#yiv7322016214 #yiv7322016214ygrp-sponsor 
> #yiv7322016214ygrp-lc #yiv7322016214hd {margin:10px 
> 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7322016214 
> #yiv7322016214ygrp-sponsor #yiv7322016214ygrp-lc .yiv7322016214ad 
> {margin-bottom:10px;padding:0 0;}#yiv7322016214 #yiv7322016214actions 
> {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7322016214 
> #yiv7322016214activity 
> {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7322016214
>  #yiv7322016214activity span {font-weight:700;}#yiv7322016214 
> #yiv7322016214activity span:first-child 
> {text-transform:uppercase;}#yiv7322016214 #yiv7322016214activity span a 
> {color:#50

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

thanks for the info but now it is not an option for me since the license 
requires to pay on every month


  From: "Jack Engleman jack_engle...@yahoo.com [firebird-support]" 
<firebird-support@yahoogroups.com>
 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:08 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
    To improve speed on a Windows based system use the RDP protocol to Remote 
Desktop connection on the server.  The Server will run the query and your speed 
will be greatly enhanced.  You have to purchase RPD licenses for you server and 
that increases the cost of implementation. I have a server that has 30 firebird 
databases running on it. I have up to 80 users  at a time on my server and all 
customers are very happy with the speed of the server.
Best Regards
Jack Engleman


  From: "'Mr. John' mr_joh...@yahoo.com [firebird-support]" 
<firebird-support@yahoogroups.com>
 To: Firebird-support <firebird-support@yahoogroups.com> 
 Sent: Friday, April 14, 2017 12:22 AM
 Subject: [firebird-support] Improve remote query speed on Windows Server 2012 
VPS
  
    Hi.I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPSFrom 
tests,remote access database works slow,a simple query on a small table with 
about 500 records
select * from MYTABLE where id=200 
takes    Total execution time: 5.388s
   PLAN (MYTABLE INDEX (PK_MYTABLE))
  the same query executed local on the server(same db,server) takes  0.065s
queries are done with Flamerobin,from IBExpert the same results
How can I improve remote speed?Thanks
  

 #yiv8551892718 #yiv8551892718 -- #yiv8551892718ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8551892718 
#yiv8551892718ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8551892718 
#yiv8551892718ygrp-mkp #yiv8551892718hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8551892718 #yiv8551892718ygrp-mkp #yiv8551892718ads 
{margin-bottom:10px;}#yiv8551892718 #yiv8551892718ygrp-mkp .yiv8551892718ad 
{padding:0 0;}#yiv8551892718 #yiv8551892718ygrp-mkp .yiv8551892718ad p 
{margin:0;}#yiv8551892718 #yiv8551892718ygrp-mkp .yiv8551892718ad a 
{color:#ff;text-decoration:none;}#yiv8551892718 #yiv8551892718ygrp-sponsor 
#yiv8551892718ygrp-lc {font-family:Arial;}#yiv8551892718 
#yiv8551892718ygrp-sponsor #yiv8551892718ygrp-lc #yiv8551892718hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8551892718 
#yiv8551892718ygrp-sponsor #yiv8551892718ygrp-lc .yiv8551892718ad 
{margin-bottom:10px;padding:0 0;}#yiv8551892718 #yiv8551892718actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8551892718 
#yiv8551892718activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8551892718
 #yiv8551892718activity span {font-weight:700;}#yiv8551892718 
#yiv8551892718activity span:first-child 
{text-transform:uppercase;}#yiv8551892718 #yiv8551892718activity span a 
{color:#5085b6;text-decoration:none;}#yiv8551892718 #yiv8551892718activity span 
span {color:#ff7900;}#yiv8551892718 #yiv8551892718activity span 
.yiv8551892718underline {text-decoration:underline;}#yiv8551892718 
.yiv8551892718attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv8551892718 .yiv8551892718attach div a 
{text-decoration:none;}#yiv8551892718 .yiv8551892718attach img 
{border:none;padding-right:5px;}#yiv8551892718 .yiv8551892718attach label 
{display:block;margin-bottom:5px;}#yiv8551892718 .yiv8551892718attach label a 
{text-decoration:none;}#yiv8551892718 blockquote {margin:0 0 0 
4px;}#yiv8551892718 .yiv8551892718bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8551892718 
.yiv8551892718bold a {text-decoration:none;}#yiv8551892718 dd.yiv8551892718last 
p a {font-family:Verdana;font-weight:700;}#yiv8551892718 dd.yiv8551892718last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8551892718 
dd.yiv8551892718last p span.yiv8551892718yshortcuts 
{margin-right:0;}#yiv8551892718 div.yiv8551892718attach-table div div a 
{text-decoration:none;}#yiv8551892718 div.yiv8551892718attach-table 
{width:400px;}#yiv8551892718 div.yiv8551892718file-title a, #yiv8551892718 
div.yiv8551892718file-title a:active, #yiv8551892718 
div.yiv8551892718file-title a:hover, #yiv8551892718 div.yiv8551892718file-title 
a:visited {text-decoration:none;}#yiv8551892718 div.yiv8551892718photo-title a, 
#yiv8551892718 div.yiv8551892718photo-title a:active, #yiv8551892718 
div.yiv8551892718photo-title a:hover, #yiv8551892718 
div.yiv8551892718photo-title a:visited {text-decoration:none;}#yiv8551892718 
div#yiv8551892718ygrp-mlmsg #yiv8551892718ygrp-msg p a 
span.yiv8551892718yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8551892718 
.yiv8551892718green {color:#628c2a;}#yiv8551892718 .yiv8551892718MsoNormal 
{margin:

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

I've done tests with fb3 (only by flamerobin)  but the same results as 2.5

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

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 11:01 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
 Hi,
 
 Migrate to Firebird 3 - it has protocol improvements for high latency networks.
 With 2.5 you will never reach such good results as with FB3.
 
 Regards,
 Alexey Kovyazin
 IBSurgeon www.ib-aid.com
 
 
 
 
 
  
     Hi. I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPS From 
tests,remote access database works slow,a simple query on a small table with 
about 500 records 
  select * from MYTABLE where id=200  
  takes     Total execution time: 5.388s
     PLAN (MYTABLE INDEX (PK_MYTABLE)) 
    the same query executed local on the server(same db,server) takes  0.065s 
  queries are done with Flamerobin,from IBExpert the same results 
  How can I improve remote speed? Thanks 

 
  #yiv7322016214 #yiv7322016214 -- #yiv7322016214ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7322016214 
#yiv7322016214ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7322016214 
#yiv7322016214ygrp-mkp #yiv7322016214hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7322016214 #yiv7322016214ygrp-mkp #yiv7322016214ads 
{margin-bottom:10px;}#yiv7322016214 #yiv7322016214ygrp-mkp .yiv7322016214ad 
{padding:0 0;}#yiv7322016214 #yiv7322016214ygrp-mkp .yiv7322016214ad p 
{margin:0;}#yiv7322016214 #yiv7322016214ygrp-mkp .yiv7322016214ad a 
{color:#ff;text-decoration:none;}#yiv7322016214 #yiv7322016214ygrp-sponsor 
#yiv7322016214ygrp-lc {font-family:Arial;}#yiv7322016214 
#yiv7322016214ygrp-sponsor #yiv7322016214ygrp-lc #yiv7322016214hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7322016214 
#yiv7322016214ygrp-sponsor #yiv7322016214ygrp-lc .yiv7322016214ad 
{margin-bottom:10px;padding:0 0;}#yiv7322016214 #yiv7322016214actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7322016214 
#yiv7322016214activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7322016214
 #yiv7322016214activity span {font-weight:700;}#yiv7322016214 
#yiv7322016214activity span:first-child 
{text-transform:uppercase;}#yiv7322016214 #yiv7322016214activity span a 
{color:#5085b6;text-decoration:none;}#yiv7322016214 #yiv7322016214activity span 
span {color:#ff7900;}#yiv7322016214 #yiv7322016214activity span 
.yiv7322016214underline {text-decoration:underline;}#yiv7322016214 
.yiv7322016214attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7322016214 .yiv7322016214attach div a 
{text-decoration:none;}#yiv7322016214 .yiv7322016214attach img 
{border:none;padding-right:5px;}#yiv7322016214 .yiv7322016214attach label 
{display:block;margin-bottom:5px;}#yiv7322016214 .yiv7322016214attach label a 
{text-decoration:none;}#yiv7322016214 blockquote {margin:0 0 0 
4px;}#yiv7322016214 .yiv7322016214bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7322016214 
.yiv7322016214bold a {text-decoration:none;}#yiv7322016214 dd.yiv7322016214last 
p a {font-family:Verdana;font-weight:700;}#yiv7322016214 dd.yiv7322016214last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7322016214 
dd.yiv7322016214last p span.yiv7322016214yshortcuts 
{margin-right:0;}#yiv7322016214 div.yiv7322016214attach-table div div a 
{text-decoration:none;}#yiv7322016214 div.yiv7322016214attach-table 
{width:400px;}#yiv7322016214 div.yiv7322016214file-title a, #yiv7322016214 
div.yiv7322016214file-title a:active, #yiv7322016214 
div.yiv7322016214file-title a:hover, #yiv7322016214 div.yiv7322016214file-title 
a:visited {text-decoration:none;}#yiv7322016214 div.yiv7322016214photo-title a, 
#yiv7322016214 div.yiv7322016214photo-title a:active, #yiv7322016214 
div.yiv7322016214photo-title a:hover, #yiv7322016214 
div.yiv7322016214photo-title a:visited {text-decoration:none;}#yiv7322016214 
div#yiv7322016214ygrp-mlmsg #yiv7322016214ygrp-msg p a 
span.yiv7322016214yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7322016214 
.yiv7322016214green {color:#628c2a;}#yiv7322016214 .yiv7322016214MsoNormal 
{margin:0 0 0 0;}#yiv7322016214 o {font-size:0;}#yiv7322016214 
#yiv7322016214photos div {float:left;width:72px;}#yiv7322016214 
#yiv7322016214photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv7322016214 
#yiv7322016214photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7322016214
 #yiv7322016214reco-category {font-size:77%;}#yiv7322016214 
#yiv7322016214reco-desc {font-size:77%;}#yiv7322016214 .yiv7322016214replbq 
{margin:4px;}#yiv7322016214 #yiv7322016214ygrp-actbar div a:first-child 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

this is just firebird specific?

  From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 
<firebird-support@yahoogroups.com>
 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:54 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
14.04.2017 21:40, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> indeed is faster

  Working with Firebird via high latency network require very careful 
application design 
and development. You, literally, must count every round trip to server and 
every received 
byte.


-- 
  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] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

indeed with orbada    247ms instead of 5-6 seconds...also ibeExpert is slow and 
my app too

  From: "Michal Kurczabinski michk...@gmail.com [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:33 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
    With isql is same issue?

I have with flamerobin on remote machine big delay, while with eg. orbada 
database manager there is no additional delay.


-- 
Regards, 
Michał Kurczabiński  #yiv2479821658 #yiv2479821658 -- #yiv2479821658ygrp-mkp 
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 
10px;}#yiv2479821658 #yiv2479821658ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv2479821658 #yiv2479821658ygrp-mkp #yiv2479821658hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2479821658 #yiv2479821658ygrp-mkp #yiv2479821658ads 
{margin-bottom:10px;}#yiv2479821658 #yiv2479821658ygrp-mkp .yiv2479821658ad 
{padding:0 0;}#yiv2479821658 #yiv2479821658ygrp-mkp .yiv2479821658ad p 
{margin:0;}#yiv2479821658 #yiv2479821658ygrp-mkp .yiv2479821658ad a 
{color:#ff;text-decoration:none;}#yiv2479821658 #yiv2479821658ygrp-sponsor 
#yiv2479821658ygrp-lc {font-family:Arial;}#yiv2479821658 
#yiv2479821658ygrp-sponsor #yiv2479821658ygrp-lc #yiv2479821658hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2479821658 
#yiv2479821658ygrp-sponsor #yiv2479821658ygrp-lc .yiv2479821658ad 
{margin-bottom:10px;padding:0 0;}#yiv2479821658 #yiv2479821658actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2479821658 
#yiv2479821658activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2479821658
 #yiv2479821658activity span {font-weight:700;}#yiv2479821658 
#yiv2479821658activity span:first-child 
{text-transform:uppercase;}#yiv2479821658 #yiv2479821658activity span a 
{color:#5085b6;text-decoration:none;}#yiv2479821658 #yiv2479821658activity span 
span {color:#ff7900;}#yiv2479821658 #yiv2479821658activity span 
.yiv2479821658underline {text-decoration:underline;}#yiv2479821658 
.yiv2479821658attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2479821658 .yiv2479821658attach div a 
{text-decoration:none;}#yiv2479821658 .yiv2479821658attach img 
{border:none;padding-right:5px;}#yiv2479821658 .yiv2479821658attach label 
{display:block;margin-bottom:5px;}#yiv2479821658 .yiv2479821658attach label a 
{text-decoration:none;}#yiv2479821658 blockquote {margin:0 0 0 
4px;}#yiv2479821658 .yiv2479821658bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2479821658 
.yiv2479821658bold a {text-decoration:none;}#yiv2479821658 dd.yiv2479821658last 
p a {font-family:Verdana;font-weight:700;}#yiv2479821658 dd.yiv2479821658last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2479821658 
dd.yiv2479821658last p span.yiv2479821658yshortcuts 
{margin-right:0;}#yiv2479821658 div.yiv2479821658attach-table div div a 
{text-decoration:none;}#yiv2479821658 div.yiv2479821658attach-table 
{width:400px;}#yiv2479821658 div.yiv2479821658file-title a, #yiv2479821658 
div.yiv2479821658file-title a:active, #yiv2479821658 
div.yiv2479821658file-title a:hover, #yiv2479821658 div.yiv2479821658file-title 
a:visited {text-decoration:none;}#yiv2479821658 div.yiv2479821658photo-title a, 
#yiv2479821658 div.yiv2479821658photo-title a:active, #yiv2479821658 
div.yiv2479821658photo-title a:hover, #yiv2479821658 
div.yiv2479821658photo-title a:visited {text-decoration:none;}#yiv2479821658 
div#yiv2479821658ygrp-mlmsg #yiv2479821658ygrp-msg p a 
span.yiv2479821658yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2479821658 
.yiv2479821658green {color:#628c2a;}#yiv2479821658 .yiv2479821658MsoNormal 
{margin:0 0 0 0;}#yiv2479821658 o {font-size:0;}#yiv2479821658 
#yiv2479821658photos div {float:left;width:72px;}#yiv2479821658 
#yiv2479821658photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv2479821658 
#yiv2479821658photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2479821658
 #yiv2479821658reco-category {font-size:77%;}#yiv2479821658 
#yiv2479821658reco-desc {font-size:77%;}#yiv2479821658 .yiv2479821658replbq 
{margin:4px;}#yiv2479821658 #yiv2479821658ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv2479821658 #yiv2479821658ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2479821658 
#yiv2479821658ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2479821658 
#yiv2479821658ygrp-mlmsg select, #yiv2479821658 input, #yiv2479821658 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2479821658 
#yiv2479821658ygrp-mlmsg pre, #yiv2479821658 code {font:115% 
monospace;}#yiv2479821658 #yiv2479821658ygrp-mlmsg * 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

indeed is faster

  From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 
<firebird-support@yahoogroups.com>
 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:29 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
14.04.2017 21:27, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I don't think

  Just try.


-- 
  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] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

I don't think,I have an application that runs slow too on that db/connection

  From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 
<firebird-support@yahoogroups.com>
 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:26 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
14.04.2017 21:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> select count(*)  remote  is fast
> Total execution time: 0.386s

  If you use isql instead of Flame Robin/IBExpert does it make any difference?


-- 
  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] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

select count(*)  remote   is fast Total execution time: 0.386s

executed on the server  querys are fast  select * from MYTABLE where id=200   
takes  0.065s


  From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 
<firebird-support@yahoogroups.com>
 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:08 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
14.04.2017 20:50, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> on another table,same db, with 7 records and  12 columns takes * 2.362s*

  Is result the same if query is executed from server or if count(*) is 
requested instead 
of whole data set?


-- 
  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] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

no blob field.thanks


  From: "Thomas Kragh t...@uvdata.dk [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:06 PM
 Subject: RE: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
    Does MYTABLE contain any blob columns with data that might be fetched?    
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Friday, April 14, 2017 17:20
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS       

> select * from MYTABLE where id=200 
> 
> takes 
>    Total execution time: 5.388s 
>    PLAN (MYTABLE INDEX (PK_MYTABLE)) 
> 
>   the same query executed local on the server(same db,server) takes  0.065s 
> 
> queries are done with Flamerobin,from IBExpert the same results 
> 
> How can I improve remote speed? 

SELECT the columns that you actually need. 

SELECT * is fine for debugging, but IMO a slackers approach for production 
code. 


Sean 

P.S. What is the latency/PING time of your connection to the remote server?   
Venlig hilsen

Thomas Kragh, Udvikler


A part of KMD 

Stigsborgvej 60, 9400 Nørresundby
e-mai...@uvdata.dk  Web www.uvdata.dk
Telefon +45 72287030

 Vi gør opmærksom på, at denne e-mail kan indeholde fortrolig information. Hvis 
du ved en fejltagelse modtager e-mailen, beder vi dig venligst informere 
afsender om fejlen ved at bruge svarfunktionen. Samtidig beder vi dig slette 
e-mailen i dit system uden at videresende eller kopiere den. Selvom e-mailen og 
ethvert vedhæftet bilag efter vores overbevisning er fri for virus og andre 
fejl, som kan påvirke computeren eller it-systemet, hvori den modtages og 
læses, åbnes den på modtagerens eget ansvar. Vi påtager os ikke noget ansvar 
for tab og skade, som er opstået i forbindelse med at modtage og bruge 
e-mailen.Please note that this message may contain confidential information. If 
you have received this message by mistake, please inform the sender of the 
mistake by sending a reply, then delete the message from your system without 
making, distributing or retaining any copies of it. Although we believe that 
the message and any attachments are free from viruses and other errors that 
might affect the computer or it-system where it is received and read, the 
recipient opens the message at his or her own risk. We assume no responsibility 
for any loss or damage arising from the receipt or use of this message.  
#yiv9686157046 #yiv9686157046 -- #yiv9686157046ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9686157046 
#yiv9686157046ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9686157046 
#yiv9686157046ygrp-mkp #yiv9686157046hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv9686157046 #yiv9686157046ygrp-mkp #yiv9686157046ads 
{margin-bottom:10px;}#yiv9686157046 #yiv9686157046ygrp-mkp .yiv9686157046ad 
{padding:0 0;}#yiv9686157046 #yiv9686157046ygrp-mkp .yiv9686157046ad p 
{margin:0;}#yiv9686157046 #yiv9686157046ygrp-mkp .yiv9686157046ad a 
{color:#ff;text-decoration:none;}#yiv9686157046 #yiv9686157046ygrp-sponsor 
#yiv9686157046ygrp-lc {font-family:Arial;}#yiv9686157046 
#yiv9686157046ygrp-sponsor #yiv9686157046ygrp-lc #yiv9686157046hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9686157046 
#yiv9686157046ygrp-sponsor #yiv9686157046ygrp-lc .yiv9686157046ad 
{margin-bottom:10px;padding:0 0;}#yiv9686157046 #yiv9686157046actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9686157046 
#yiv9686157046activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9686157046
 #yiv9686157046activity span {font-weight:700;}#yiv9686157046 
#yiv9686157046activity span:first-child 
{text-transform:uppercase;}#yiv9686157046 #yiv9686157046activity span a 
{color:#5085b6;text-decoration:none;}#yiv9686157046 #yiv9686157046activity span 
span {color:#ff7900;}#yiv9686157046 #yiv9686157046activity span 
.yiv9686157046underline {text-decoration:underline;}#yiv9686157046 
.yiv9686157046attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv9686157046 .yiv9686157046attach div a 
{text-decoration:none;}#yiv9686157046 .yiv9686157046attach img 
{border:none;padding-right:5px;}#yiv9686157046 .yiv9686157046attach label 
{display:block;margin-bottom:5px;}#yiv9686157046 .yiv9686157046attach label a 
{text-decoration:none;}#yiv9686157046 blockquote {margin:0 0 0 
4px;}#yiv9686157046 .yiv9686157046bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9686157046 
.yiv9686157046bold a {text-decoration:none;}#yiv9686157046 dd.yiv9686157046last 
p a {font-family:Verdana;font-weight:700;}#yiv9686157046 dd.yiv9686157046last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9686157046 
dd.yiv9686157046last p span.yiv9686157046yshortcuts 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

on another table,same db, with 7 records and  12 columns takes  2.362s
select * from table2

Starting transaction...Preparing statement: ..Statement prepared (elapsed time: 
0.043s).
Executing statement...Statement executed (elapsed time: 0.000s).22475 fetches, 
6 marks, 1 reads, 6 writes.0 inserts, 0 updates, 0 deletes, 237 index, 10491 
seq.Delta memory: 37192 bytes.Total execution time: 2.362sScript execution 
finished.
I have a mysql hosting (on another provider) that support remote access don't 
know how is configured but every query is very fast,on manager or by an 
application ex:
 SELECT * FROM tabletest ORDER BY data desc 
 66 row(s) returned 0.063 sec
10 fields

thanks
  From: "'Mr. John' mr_joh...@yahoo.com [firebird-support]" 
<firebird-support@yahoogroups.com>
 To: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com> 
 Sent: Friday, April 14, 2017 9:29 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
    hi.I put only 2 columns but seems the same result


  From: "'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]" 
<firebird-support@yahoogroups.com>
 To: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com> 
 Sent: Friday, April 14, 2017 9:13 PM
 Subject: RE: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
  
      hi Min=37ms Max=37ms Avg=37ms     Does mean that but only 
selecting specific columns, your SQL executed faster?     Also, are using 
v2.5+ FBClient library on remote client?    thanks    From: "'Leyne, 
Sean's...@broadviewsoftware.com [firebird-support]" 
<firebird-support@yahoogroups.com>
To: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com>
Sent: Friday, April 14, 2017 6:20 PM
Subject: RE: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS      

> select * from MYTABLE where id=200 
> 
> takes 
>    Total execution time: 5.388s 
>    PLAN (MYTABLE INDEX (PK_MYTABLE)) 
> 
>   the same query executed local on the server(same db,server) takes  0.065s 
> 
> queries are done with Flamerobin,from IBExpert the same results 
> 
> How can I improve remote speed? 

SELECT the columns that you actually need. 

SELECT * is fine for debugging, but IMO a slackers approach for production 
code. 


Sean 

P.S. What is the latency/PING time of your connection to the remote server?     
  

 #yiv7401092028 #yiv7401092028 -- #yiv7401092028ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7401092028 
#yiv7401092028ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7401092028 
#yiv7401092028ygrp-mkp #yiv7401092028hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7401092028 #yiv7401092028ygrp-mkp #yiv7401092028ads 
{margin-bottom:10px;}#yiv7401092028 #yiv7401092028ygrp-mkp .yiv7401092028ad 
{padding:0 0;}#yiv7401092028 #yiv7401092028ygrp-mkp .yiv7401092028ad p 
{margin:0;}#yiv7401092028 #yiv7401092028ygrp-mkp .yiv7401092028ad a 
{color:#ff;text-decoration:none;}#yiv7401092028 #yiv7401092028ygrp-sponsor 
#yiv7401092028ygrp-lc {font-family:Arial;}#yiv7401092028 
#yiv7401092028ygrp-sponsor #yiv7401092028ygrp-lc #yiv7401092028hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7401092028 
#yiv7401092028ygrp-sponsor #yiv7401092028ygrp-lc .yiv7401092028ad 
{margin-bottom:10px;padding:0 0;}#yiv7401092028 #yiv7401092028actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7401092028 
#yiv7401092028activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7401092028
 #yiv7401092028activity span {font-weight:700;}#yiv7401092028 
#yiv7401092028activity span:first-child 
{text-transform:uppercase;}#yiv7401092028 #yiv7401092028activity span a 
{color:#5085b6;text-decoration:none;}#yiv7401092028 #yiv7401092028activity span 
span {color:#ff7900;}#yiv7401092028 #yiv7401092028activity span 
.yiv7401092028underline {text-decoration:underline;}#yiv7401092028 
.yiv7401092028attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7401092028 .yiv7401092028attach div a 
{text-decoration:none;}#yiv7401092028 .yiv7401092028attach img 
{border:none;padding-right:5px;}#yiv7401092028 .yiv7401092028attach label 
{display:block;margin-bottom:5px;}#yiv7401092028 .yiv7401092028attach label a 
{text-decoration:none;}#yiv7401092028 blockquote {margin:0 0 0 
4px;}#yiv7401092028 .yiv7401092028bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7401092028 
.yiv7401092028bold a {text-decoration:none;}#yiv7401092028 dd.yiv7401092028last 
p a {font-family:Verdana;font-weight:700;}#yiv7401092028 dd.yiv7401092028last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7401092028 
dd.yiv7401092028last p span.yiv740

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

hi.I put only 2 columns but seems the same result


  From: "'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]" 

 To: "firebird-support@yahoogroups.com"  
 Sent: Friday, April 14, 2017 9:13 PM
 Subject: RE: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
      hi Min=37ms Max=37ms Avg=37ms     Does mean that but only 
selecting specific columns, your SQL executed faster?     Also, are using 
v2.5+ FBClient library on remote client?    thanks    From: "'Leyne, 
Sean's...@broadviewsoftware.com [firebird-support]" 

To: "firebird-support@yahoogroups.com" 
Sent: Friday, April 14, 2017 6:20 PM
Subject: RE: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS      

> select * from MYTABLE where id=200 
> 
> takes 
>    Total execution time: 5.388s 
>    PLAN (MYTABLE INDEX (PK_MYTABLE)) 
> 
>   the same query executed local on the server(same db,server) takes  0.065s 
> 
> queries are done with Flamerobin,from IBExpert the same results 
> 
> How can I improve remote speed? 

SELECT the columns that you actually need. 

SELECT * is fine for debugging, but IMO a slackers approach for production 
code. 


Sean 

P.S. What is the latency/PING time of your connection to the remote server?     
  #yiv257666 #yiv257666 -- #yiv257666ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv257666 
#yiv257666ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv257666 
#yiv257666ygrp-mkp #yiv257666hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv257666 #yiv257666ygrp-mkp #yiv257666ads 
{margin-bottom:10px;}#yiv257666 #yiv257666ygrp-mkp .yiv257666ad 
{padding:0 0;}#yiv257666 #yiv257666ygrp-mkp .yiv257666ad p 
{margin:0;}#yiv257666 #yiv257666ygrp-mkp .yiv257666ad a 
{color:#ff;text-decoration:none;}#yiv257666 #yiv257666ygrp-sponsor 
#yiv257666ygrp-lc {font-family:Arial;}#yiv257666 
#yiv257666ygrp-sponsor #yiv257666ygrp-lc #yiv257666hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv257666 
#yiv257666ygrp-sponsor #yiv257666ygrp-lc .yiv257666ad 
{margin-bottom:10px;padding:0 0;}#yiv257666 #yiv257666actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv257666 
#yiv257666activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv257666
 #yiv257666activity span {font-weight:700;}#yiv257666 
#yiv257666activity span:first-child 
{text-transform:uppercase;}#yiv257666 #yiv257666activity span a 
{color:#5085b6;text-decoration:none;}#yiv257666 #yiv257666activity span 
span {color:#ff7900;}#yiv257666 #yiv257666activity span 
.yiv257666underline {text-decoration:underline;}#yiv257666 
.yiv257666attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv257666 .yiv257666attach div a 
{text-decoration:none;}#yiv257666 .yiv257666attach img 
{border:none;padding-right:5px;}#yiv257666 .yiv257666attach label 
{display:block;margin-bottom:5px;}#yiv257666 .yiv257666attach label a 
{text-decoration:none;}#yiv257666 blockquote {margin:0 0 0 
4px;}#yiv257666 .yiv257666bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv257666 
.yiv257666bold a {text-decoration:none;}#yiv257666 dd.yiv257666last 
p a {font-family:Verdana;font-weight:700;}#yiv257666 dd.yiv257666last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv257666 
dd.yiv257666last p span.yiv257666yshortcuts 
{margin-right:0;}#yiv257666 div.yiv257666attach-table div div a 
{text-decoration:none;}#yiv257666 div.yiv257666attach-table 
{width:400px;}#yiv257666 div.yiv257666file-title a, #yiv257666 
div.yiv257666file-title a:active, #yiv257666 
div.yiv257666file-title a:hover, #yiv257666 div.yiv257666file-title 
a:visited {text-decoration:none;}#yiv257666 div.yiv257666photo-title a, 
#yiv257666 div.yiv257666photo-title a:active, #yiv257666 
div.yiv257666photo-title a:hover, #yiv257666 
div.yiv257666photo-title a:visited {text-decoration:none;}#yiv257666 
div#yiv257666ygrp-mlmsg #yiv257666ygrp-msg p a 
span.yiv257666yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv257666 
.yiv257666green {color:#628c2a;}#yiv257666 .yiv257666MsoNormal 
{margin:0 0 0 0;}#yiv257666 o {font-size:0;}#yiv257666 
#yiv257666photos div {float:left;width:72px;}#yiv257666 
#yiv257666photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv257666 
#yiv257666photos div 

Re: [firebird-support] Re: Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

no,it doesn't
thanks


  From: "kragh.tho...@yahoo.com [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 9:02 PM
 Subject: [firebird-support] Re: Improve remote query speed on Windows Server 
2012 VPS
   
    Does MYTABLEcontain any blob columns with data that needs to be fetched?   
#yiv3094711705 #yiv3094711705 -- #yiv3094711705ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3094711705 
#yiv3094711705ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3094711705 
#yiv3094711705ygrp-mkp #yiv3094711705hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3094711705 #yiv3094711705ygrp-mkp #yiv3094711705ads 
{margin-bottom:10px;}#yiv3094711705 #yiv3094711705ygrp-mkp .yiv3094711705ad 
{padding:0 0;}#yiv3094711705 #yiv3094711705ygrp-mkp .yiv3094711705ad p 
{margin:0;}#yiv3094711705 #yiv3094711705ygrp-mkp .yiv3094711705ad a 
{color:#ff;text-decoration:none;}#yiv3094711705 #yiv3094711705ygrp-sponsor 
#yiv3094711705ygrp-lc {font-family:Arial;}#yiv3094711705 
#yiv3094711705ygrp-sponsor #yiv3094711705ygrp-lc #yiv3094711705hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3094711705 
#yiv3094711705ygrp-sponsor #yiv3094711705ygrp-lc .yiv3094711705ad 
{margin-bottom:10px;padding:0 0;}#yiv3094711705 #yiv3094711705actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3094711705 
#yiv3094711705activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3094711705
 #yiv3094711705activity span {font-weight:700;}#yiv3094711705 
#yiv3094711705activity span:first-child 
{text-transform:uppercase;}#yiv3094711705 #yiv3094711705activity span a 
{color:#5085b6;text-decoration:none;}#yiv3094711705 #yiv3094711705activity span 
span {color:#ff7900;}#yiv3094711705 #yiv3094711705activity span 
.yiv3094711705underline {text-decoration:underline;}#yiv3094711705 
.yiv3094711705attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3094711705 .yiv3094711705attach div a 
{text-decoration:none;}#yiv3094711705 .yiv3094711705attach img 
{border:none;padding-right:5px;}#yiv3094711705 .yiv3094711705attach label 
{display:block;margin-bottom:5px;}#yiv3094711705 .yiv3094711705attach label a 
{text-decoration:none;}#yiv3094711705 blockquote {margin:0 0 0 
4px;}#yiv3094711705 .yiv3094711705bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3094711705 
.yiv3094711705bold a {text-decoration:none;}#yiv3094711705 dd.yiv3094711705last 
p a {font-family:Verdana;font-weight:700;}#yiv3094711705 dd.yiv3094711705last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3094711705 
dd.yiv3094711705last p span.yiv3094711705yshortcuts 
{margin-right:0;}#yiv3094711705 div.yiv3094711705attach-table div div a 
{text-decoration:none;}#yiv3094711705 div.yiv3094711705attach-table 
{width:400px;}#yiv3094711705 div.yiv3094711705file-title a, #yiv3094711705 
div.yiv3094711705file-title a:active, #yiv3094711705 
div.yiv3094711705file-title a:hover, #yiv3094711705 div.yiv3094711705file-title 
a:visited {text-decoration:none;}#yiv3094711705 div.yiv3094711705photo-title a, 
#yiv3094711705 div.yiv3094711705photo-title a:active, #yiv3094711705 
div.yiv3094711705photo-title a:hover, #yiv3094711705 
div.yiv3094711705photo-title a:visited {text-decoration:none;}#yiv3094711705 
div#yiv3094711705ygrp-mlmsg #yiv3094711705ygrp-msg p a 
span.yiv3094711705yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3094711705 
.yiv3094711705green {color:#628c2a;}#yiv3094711705 .yiv3094711705MsoNormal 
{margin:0 0 0 0;}#yiv3094711705 o {font-size:0;}#yiv3094711705 
#yiv3094711705photos div {float:left;width:72px;}#yiv3094711705 
#yiv3094711705photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv3094711705 
#yiv3094711705photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3094711705
 #yiv3094711705reco-category {font-size:77%;}#yiv3094711705 
#yiv3094711705reco-desc {font-size:77%;}#yiv3094711705 .yiv3094711705replbq 
{margin:4px;}#yiv3094711705 #yiv3094711705ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3094711705 #yiv3094711705ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3094711705 
#yiv3094711705ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3094711705 
#yiv3094711705ygrp-mlmsg select, #yiv3094711705 input, #yiv3094711705 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3094711705 
#yiv3094711705ygrp-mlmsg pre, #yiv3094711705 code {font:115% 
monospace;}#yiv3094711705 #yiv3094711705ygrp-mlmsg * 
{line-height:1.22em;}#yiv3094711705 #yiv3094711705ygrp-mlmsg #yiv3094711705logo 
{padding-bottom:10px;}#yiv3094711705 #yiv3094711705ygrp-msg p a 
{font-family:Verdana;}#yiv3094711705 #yiv3094711705ygrp-msg 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

hiMin=37ms Max=37ms Avg=37ms
thanks

  From: "'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]" 

 To: "firebird-support@yahoogroups.com"  
 Sent: Friday, April 14, 2017 6:20 PM
 Subject: RE: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
    

> select * from MYTABLE where id=200
> 
> takes
>    Total execution time: 5.388s
>    PLAN (MYTABLE INDEX (PK_MYTABLE))
> 
>   the same query executed local on the server(same db,server) takes  0.065s
> 
> queries are done with Flamerobin,from IBExpert the same results
> 
> How can I improve remote speed?

SELECT the columns that you actually need.

SELECT * is fine for debugging, but IMO a slackers approach for production code.


Sean

P.S. What is the latency/PING time of your connection to the remote server?

  #yiv7478938356 #yiv7478938356 -- #yiv7478938356ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7478938356 
#yiv7478938356ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7478938356 
#yiv7478938356ygrp-mkp #yiv7478938356hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7478938356 #yiv7478938356ygrp-mkp #yiv7478938356ads 
{margin-bottom:10px;}#yiv7478938356 #yiv7478938356ygrp-mkp .yiv7478938356ad 
{padding:0 0;}#yiv7478938356 #yiv7478938356ygrp-mkp .yiv7478938356ad p 
{margin:0;}#yiv7478938356 #yiv7478938356ygrp-mkp .yiv7478938356ad a 
{color:#ff;text-decoration:none;}#yiv7478938356 #yiv7478938356ygrp-sponsor 
#yiv7478938356ygrp-lc {font-family:Arial;}#yiv7478938356 
#yiv7478938356ygrp-sponsor #yiv7478938356ygrp-lc #yiv7478938356hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7478938356 
#yiv7478938356ygrp-sponsor #yiv7478938356ygrp-lc .yiv7478938356ad 
{margin-bottom:10px;padding:0 0;}#yiv7478938356 #yiv7478938356actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7478938356 
#yiv7478938356activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7478938356
 #yiv7478938356activity span {font-weight:700;}#yiv7478938356 
#yiv7478938356activity span:first-child 
{text-transform:uppercase;}#yiv7478938356 #yiv7478938356activity span a 
{color:#5085b6;text-decoration:none;}#yiv7478938356 #yiv7478938356activity span 
span {color:#ff7900;}#yiv7478938356 #yiv7478938356activity span 
.yiv7478938356underline {text-decoration:underline;}#yiv7478938356 
.yiv7478938356attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7478938356 .yiv7478938356attach div a 
{text-decoration:none;}#yiv7478938356 .yiv7478938356attach img 
{border:none;padding-right:5px;}#yiv7478938356 .yiv7478938356attach label 
{display:block;margin-bottom:5px;}#yiv7478938356 .yiv7478938356attach label a 
{text-decoration:none;}#yiv7478938356 blockquote {margin:0 0 0 
4px;}#yiv7478938356 .yiv7478938356bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7478938356 
.yiv7478938356bold a {text-decoration:none;}#yiv7478938356 dd.yiv7478938356last 
p a {font-family:Verdana;font-weight:700;}#yiv7478938356 dd.yiv7478938356last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7478938356 
dd.yiv7478938356last p span.yiv7478938356yshortcuts 
{margin-right:0;}#yiv7478938356 div.yiv7478938356attach-table div div a 
{text-decoration:none;}#yiv7478938356 div.yiv7478938356attach-table 
{width:400px;}#yiv7478938356 div.yiv7478938356file-title a, #yiv7478938356 
div.yiv7478938356file-title a:active, #yiv7478938356 
div.yiv7478938356file-title a:hover, #yiv7478938356 div.yiv7478938356file-title 
a:visited {text-decoration:none;}#yiv7478938356 div.yiv7478938356photo-title a, 
#yiv7478938356 div.yiv7478938356photo-title a:active, #yiv7478938356 
div.yiv7478938356photo-title a:hover, #yiv7478938356 
div.yiv7478938356photo-title a:visited {text-decoration:none;}#yiv7478938356 
div#yiv7478938356ygrp-mlmsg #yiv7478938356ygrp-msg p a 
span.yiv7478938356yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7478938356 
.yiv7478938356green {color:#628c2a;}#yiv7478938356 .yiv7478938356MsoNormal 
{margin:0 0 0 0;}#yiv7478938356 o {font-size:0;}#yiv7478938356 
#yiv7478938356photos div {float:left;width:72px;}#yiv7478938356 
#yiv7478938356photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv7478938356 
#yiv7478938356photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7478938356
 #yiv7478938356reco-category {font-size:77%;}#yiv7478938356 
#yiv7478938356reco-desc {font-size:77%;}#yiv7478938356 .yiv7478938356replbq 
{margin:4px;}#yiv7478938356 #yiv7478938356ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv7478938356 #yiv7478938356ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7478938356 
#yiv7478938356ygrp-mlmsg table 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi.I put  TcpRemoteBufferSize  32767   (i've restarted the Fb service) but I 
don't see major differences,same results:
Total execution time: 6.662s
I've done tests also with zebedee but no improvements
thanks

  From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 
<firebird-support@yahoogroups.com>
 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 2:30 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
14.04.2017 8:22, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> How can I improve remote speed?

  Increase value of "TcpRemoteBufferSize" parameter in firebird.conf to max.


-- 
  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





   

[firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi.I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPSFrom tests,remote 
access database works slow,a simple query on a small table with about 500 
records
select * from MYTABLE where id=200 
takes    Total execution time: 5.388s
   PLAN (MYTABLE INDEX (PK_MYTABLE))
  the same query executed local on the server(same db,server) takes  0.065s
queries are done with Flamerobin,from IBExpert the same results
How can I improve remote speed?Thanks

Re: [firebird-support] Firebird web hosting ASP.NET Core

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi. Asp Core works only with Entity Framework Core,there is a list of current 
supported providers :Database Providers
  
|  
|   
|   
|   ||

   |

  |
|  
||  
Database Providers
 By rowanmiller   |   |

  |

  |

  
Firebird is not there yet.This feature is listed on firebird tracker  
[#DNET-663] EF Core (EF7) support - Firebird RDBMS Issue Tracker
  
|  
|   
|   
|   ||

   |

  |
|  
|   |  
[#DNET-663] EF Core (EF7) support - Firebird RDBMS Issue Tracker
   |   |

  |

  |

  

thanks


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

 To: firebird-support@yahoogroups.com 
 Sent: Monday, February 20, 2017 11:10 PM
 Subject: Re: [firebird-support] Firebird web hosting ASP.NET Core
   
    Hi, i am not an expert of .Net but what about 
this?https://www.nuget.org/packages/EntityFramework.Firebird/ regards,Karol 
Bieniaszewski 
   #yiv1349953826 #yiv1349953826 -- #yiv1349953826ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1349953826 
#yiv1349953826ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1349953826 
#yiv1349953826ygrp-mkp #yiv1349953826hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1349953826 #yiv1349953826ygrp-mkp #yiv1349953826ads 
{margin-bottom:10px;}#yiv1349953826 #yiv1349953826ygrp-mkp .yiv1349953826ad 
{padding:0 0;}#yiv1349953826 #yiv1349953826ygrp-mkp .yiv1349953826ad p 
{margin:0;}#yiv1349953826 #yiv1349953826ygrp-mkp .yiv1349953826ad a 
{color:#ff;text-decoration:none;}#yiv1349953826 #yiv1349953826ygrp-sponsor 
#yiv1349953826ygrp-lc {font-family:Arial;}#yiv1349953826 
#yiv1349953826ygrp-sponsor #yiv1349953826ygrp-lc #yiv1349953826hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1349953826 
#yiv1349953826ygrp-sponsor #yiv1349953826ygrp-lc .yiv1349953826ad 
{margin-bottom:10px;padding:0 0;}#yiv1349953826 #yiv1349953826actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1349953826 
#yiv1349953826activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1349953826
 #yiv1349953826activity span {font-weight:700;}#yiv1349953826 
#yiv1349953826activity span:first-child 
{text-transform:uppercase;}#yiv1349953826 #yiv1349953826activity span a 
{color:#5085b6;text-decoration:none;}#yiv1349953826 #yiv1349953826activity span 
span {color:#ff7900;}#yiv1349953826 #yiv1349953826activity span 
.yiv1349953826underline {text-decoration:underline;}#yiv1349953826 
.yiv1349953826attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1349953826 .yiv1349953826attach div a 
{text-decoration:none;}#yiv1349953826 .yiv1349953826attach img 
{border:none;padding-right:5px;}#yiv1349953826 .yiv1349953826attach label 
{display:block;margin-bottom:5px;}#yiv1349953826 .yiv1349953826attach label a 
{text-decoration:none;}#yiv1349953826 blockquote {margin:0 0 0 
4px;}#yiv1349953826 .yiv1349953826bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1349953826 
.yiv1349953826bold a {text-decoration:none;}#yiv1349953826 dd.yiv1349953826last 
p a {font-family:Verdana;font-weight:700;}#yiv1349953826 dd.yiv1349953826last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1349953826 
dd.yiv1349953826last p span.yiv1349953826yshortcuts 
{margin-right:0;}#yiv1349953826 div.yiv1349953826attach-table div div a 
{text-decoration:none;}#yiv1349953826 div.yiv1349953826attach-table 
{width:400px;}#yiv1349953826 div.yiv1349953826file-title a, #yiv1349953826 
div.yiv1349953826file-title a:active, #yiv1349953826 
div.yiv1349953826file-title a:hover, #yiv1349953826 div.yiv1349953826file-title 
a:visited {text-decoration:none;}#yiv1349953826 div.yiv1349953826photo-title a, 
#yiv1349953826 div.yiv1349953826photo-title a:active, #yiv1349953826 
div.yiv1349953826photo-title a:hover, #yiv1349953826 
div.yiv1349953826photo-title a:visited {text-decoration:none;}#yiv1349953826 
div#yiv1349953826ygrp-mlmsg #yiv1349953826ygrp-msg p a 
span.yiv1349953826yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1349953826 
.yiv1349953826green {color:#628c2a;}#yiv1349953826 .yiv1349953826MsoNormal 
{margin:0 0 0 0;}#yiv1349953826 o {font-size:0;}#yiv1349953826 
#yiv1349953826photos div {float:left;width:72px;}#yiv1349953826 
#yiv1349953826photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv1349953826 
#yiv1349953826photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1349953826
 #yiv1349953826reco-category {font-size:77%;}#yiv1349953826 
#yiv1349953826reco-desc {font-size:77%;}#yiv1349953826 .yiv1349953826replbq 
{margin:4px;}#yiv1349953826 #yiv1349953826ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv1349953826 #yiv1349953826ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1349953826 

Re: [firebird-support] Firebird web hosting ASP.NET Core

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi,thanks for the infoin this case I can't access db from winforms app,only 
from web.for a while I need to access data from both.Firebird doesn't support 
Entity Framework Core at this moment so I can't use it with Asp Core  :(

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

 To: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 
 
 Sent: Saturday, February 18, 2017 9:23 PM
 Subject: Re: [firebird-support] Firebird web hosting ASP.NET Core
   
    Hi, you can use Firebird embeded – it work near on every hostingsi use 
Firebird embeded with ASP .Net from 1.1 version  regards,Karol Bieniaszewski

   #yiv3750808898 #yiv3750808898 -- #yiv3750808898ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3750808898 
#yiv3750808898ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3750808898 
#yiv3750808898ygrp-mkp #yiv3750808898hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3750808898 #yiv3750808898ygrp-mkp #yiv3750808898ads 
{margin-bottom:10px;}#yiv3750808898 #yiv3750808898ygrp-mkp .yiv3750808898ad 
{padding:0 0;}#yiv3750808898 #yiv3750808898ygrp-mkp .yiv3750808898ad p 
{margin:0;}#yiv3750808898 #yiv3750808898ygrp-mkp .yiv3750808898ad a 
{color:#ff;text-decoration:none;}#yiv3750808898 #yiv3750808898ygrp-sponsor 
#yiv3750808898ygrp-lc {font-family:Arial;}#yiv3750808898 
#yiv3750808898ygrp-sponsor #yiv3750808898ygrp-lc #yiv3750808898hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3750808898 
#yiv3750808898ygrp-sponsor #yiv3750808898ygrp-lc .yiv3750808898ad 
{margin-bottom:10px;padding:0 0;}#yiv3750808898 #yiv3750808898actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3750808898 
#yiv3750808898activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3750808898
 #yiv3750808898activity span {font-weight:700;}#yiv3750808898 
#yiv3750808898activity span:first-child 
{text-transform:uppercase;}#yiv3750808898 #yiv3750808898activity span a 
{color:#5085b6;text-decoration:none;}#yiv3750808898 #yiv3750808898activity span 
span {color:#ff7900;}#yiv3750808898 #yiv3750808898activity span 
.yiv3750808898underline {text-decoration:underline;}#yiv3750808898 
.yiv3750808898attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3750808898 .yiv3750808898attach div a 
{text-decoration:none;}#yiv3750808898 .yiv3750808898attach img 
{border:none;padding-right:5px;}#yiv3750808898 .yiv3750808898attach label 
{display:block;margin-bottom:5px;}#yiv3750808898 .yiv3750808898attach label a 
{text-decoration:none;}#yiv3750808898 blockquote {margin:0 0 0 
4px;}#yiv3750808898 .yiv3750808898bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3750808898 
.yiv3750808898bold a {text-decoration:none;}#yiv3750808898 dd.yiv3750808898last 
p a {font-family:Verdana;font-weight:700;}#yiv3750808898 dd.yiv3750808898last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3750808898 
dd.yiv3750808898last p span.yiv3750808898yshortcuts 
{margin-right:0;}#yiv3750808898 div.yiv3750808898attach-table div div a 
{text-decoration:none;}#yiv3750808898 div.yiv3750808898attach-table 
{width:400px;}#yiv3750808898 div.yiv3750808898file-title a, #yiv3750808898 
div.yiv3750808898file-title a:active, #yiv3750808898 
div.yiv3750808898file-title a:hover, #yiv3750808898 div.yiv3750808898file-title 
a:visited {text-decoration:none;}#yiv3750808898 div.yiv3750808898photo-title a, 
#yiv3750808898 div.yiv3750808898photo-title a:active, #yiv3750808898 
div.yiv3750808898photo-title a:hover, #yiv3750808898 
div.yiv3750808898photo-title a:visited {text-decoration:none;}#yiv3750808898 
div#yiv3750808898ygrp-mlmsg #yiv3750808898ygrp-msg p a 
span.yiv3750808898yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3750808898 
.yiv3750808898green {color:#628c2a;}#yiv3750808898 .yiv3750808898MsoNormal 
{margin:0 0 0 0;}#yiv3750808898 o {font-size:0;}#yiv3750808898 
#yiv3750808898photos div {float:left;width:72px;}#yiv3750808898 
#yiv3750808898photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv3750808898 
#yiv3750808898photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3750808898
 #yiv3750808898reco-category {font-size:77%;}#yiv3750808898 
#yiv3750808898reco-desc {font-size:77%;}#yiv3750808898 .yiv3750808898replbq 
{margin:4px;}#yiv3750808898 #yiv3750808898ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3750808898 #yiv3750808898ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3750808898 
#yiv3750808898ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3750808898 
#yiv3750808898ygrp-mlmsg select, #yiv3750808898 input, #yiv3750808898 textarea 
{font:99% Arial, Helvetica, clean, 

Re: [firebird-support] Firebird web hosting ASP.NET Core

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi.hi we contacted couple hosting sites but for now none support both,only 
Mysql and Sqlserver are supported
anyone is using that combination?
thanks
  From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 
<firebird-support@yahoogroups.com>
 To: firebird-support@yahoogroups.com 
 Sent: Friday, February 17, 2017 9:56 PM
 Subject: Re: [firebird-support] Firebird web hosting ASP.NET Core
   
17.02.2017 20:36, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> Our clients ask for mobile/web access of our app,in this case we decided to 
> rewrite app
> with Asp Core.What options are for hosting firebird with asp core?

  VPS or your own server.


-- 
  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





   

[firebird-support] Firebird web hosting ASP.NET Core

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi,we use Firebird 2.5 for a windows application build with .NETOur clients ask 
for mobile/web access of our app,in this case we decided to rewrite app with 
Asp Core.What options are for hosting firebird with asp core?thanks.

Re: [firebird-support] Reporting for Firebird in Visual Studio 2013 (C#)

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi,we're are using 
Reporting Tools and Components for .NET, ASP.NET, ASP.NET MVC, Web, WPF, WinRT, 
HTML5 Silverlight, Flex, PHP, Java. Stimulsoft BI. :: Stimulsoft

|   |
|   |  |   |   |   |   |   |
| Reporting Tools and Components for .NET, ASP.NET, AS...Stimulsoft Reports 
Product Line includes reporting tools for the .NET Framework platform. One can 
find reporting tools for WinForms, ASP.NET, WPF, Silverlight,... |
|  |
| View on www.stimulsoft.com | Preview by Yahoo |
|  |
|   |





Download Data Packs and Adapters :: Stimulsoft

|   |
|   |  |   |   |   |   |   |
| Download Data Packs and Adapters :: StimulsoftMore than 10 data adapters as 
projects are available for immediate use in your application. Among them are 
MySQL, PostgreSQL, Oracle, VistaDB, Informix and others. |
|  |
| View on www.stimulsoft.com | Preview by Yahoo |
|  |
|   |



also take a look there
FastReport.Net - report generator - FastReports Inc.

|   |
|   |  |   |   |   |   |   |
| FastReport.Net - report generator - FastReports Inc.FastReport.Net - report 
generator |
|  |
| View on www.fast-report.com | Preview by Yahoo |
|  |
|   |



  From: "Kevin Meyers kevinjmey...@gmail.com [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Wednesday, September 2, 2015 10:43 PM
 Subject: [firebird-support] Reporting for Firebird in Visual Studio 2013 (C#)
   
    Hello -- I'm looking for some suggestions on a reporting tool that works 
well within the Visual Studio 2013 IDE using Firebird 2.5.4.
I've tried using the Crystal Reports add-in. While it works fine within the 
IDE, when I build and run the app, it keeps asking for my login credentials. 
Have not found a way around this. If you know of one, please let me know and I 
will continue to explore using Crystal Reports.
Thanks!
Kevin  #yiv6150276667 #yiv6150276667 -- #yiv6150276667ygrp-mkp {border:1px 
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6150276667 
#yiv6150276667ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6150276667 
#yiv6150276667ygrp-mkp #yiv6150276667hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv6150276667 #yiv6150276667ygrp-mkp #yiv6150276667ads 
{margin-bottom:10px;}#yiv6150276667 #yiv6150276667ygrp-mkp .yiv6150276667ad 
{padding:0 0;}#yiv6150276667 #yiv6150276667ygrp-mkp .yiv6150276667ad p 
{margin:0;}#yiv6150276667 #yiv6150276667ygrp-mkp .yiv6150276667ad a 
{color:#ff;text-decoration:none;}#yiv6150276667 #yiv6150276667ygrp-sponsor 
#yiv6150276667ygrp-lc {font-family:Arial;}#yiv6150276667 
#yiv6150276667ygrp-sponsor #yiv6150276667ygrp-lc #yiv6150276667hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6150276667 
#yiv6150276667ygrp-sponsor #yiv6150276667ygrp-lc .yiv6150276667ad 
{margin-bottom:10px;padding:0 0;}#yiv6150276667 #yiv6150276667actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6150276667 
#yiv6150276667activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6150276667
 #yiv6150276667activity span {font-weight:700;}#yiv6150276667 
#yiv6150276667activity span:first-child 
{text-transform:uppercase;}#yiv6150276667 #yiv6150276667activity span a 
{color:#5085b6;text-decoration:none;}#yiv6150276667 #yiv6150276667activity span 
span {color:#ff7900;}#yiv6150276667 #yiv6150276667activity span 
.yiv6150276667underline {text-decoration:underline;}#yiv6150276667 
.yiv6150276667attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv6150276667 .yiv6150276667attach div a 
{text-decoration:none;}#yiv6150276667 .yiv6150276667attach img 
{border:none;padding-right:5px;}#yiv6150276667 .yiv6150276667attach label 
{display:block;margin-bottom:5px;}#yiv6150276667 .yiv6150276667attach label a 
{text-decoration:none;}#yiv6150276667 blockquote {margin:0 0 0 
4px;}#yiv6150276667 .yiv6150276667bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6150276667 
.yiv6150276667bold a {text-decoration:none;}#yiv6150276667 dd.yiv6150276667last 
p a {font-family:Verdana;font-weight:700;}#yiv6150276667 dd.yiv6150276667last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6150276667 
dd.yiv6150276667last p span.yiv6150276667yshortcuts 
{margin-right:0;}#yiv6150276667 div.yiv6150276667attach-table div div a 
{text-decoration:none;}#yiv6150276667 div.yiv6150276667attach-table 
{width:400px;}#yiv6150276667 div.yiv6150276667file-title a, #yiv6150276667 
div.yiv6150276667file-title a:active, #yiv6150276667 
div.yiv6150276667file-title a:hover, #yiv6150276667 div.yiv6150276667file-title 
a:visited {text-decoration:none;}#yiv6150276667 div.yiv6150276667photo-title a, 
#yiv6150276667 div.yiv6150276667photo-title a:active, #yiv6150276667 
div.yiv6150276667photo-title a:hover, #yiv6150276667 
div.yiv6150276667photo-title a:visited {text-decoration:none;}#yiv6150276667 
div#yiv6150276667ygrp-mlmsg #yiv6150276667ygrp-msg p a 

Re: [firebird-support] Embedded Firebird unload delay

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

is that a bug?
  From: "'Mr. John' ionut_...@yahoo.com [firebird-support]" 

 To: Firebird Support  
 Sent: Thursday, August 27, 2015 4:58 PM
 Subject: [firebird-support] Embedded Firebird unload delay
   
    Hi,
I use FB embedded version for a little local db,Firebird-2.5.4.268560_Win32 on 
W 8.1 x86 with Visual Basic 2012FirebirdClient 4.7 (latest version)

I run this simple code and when I close it,application closes but IDE still 
show "...Running"  for couple seconds (up to 5)If I change   
ServerType=1(embedded)  to ServerType=0 (SS) all works fine,IDE ends running 
mode instantly

I think it is a problem with embedded version,not .NET connector,also found 
this:
Embedded Firebird unload delay

|   |
|   |   |   |   |   |   |   |
| Embedded Firebird unload delay After I close my application fbclient.dll 
remains in memory for about 3 seconds. So it locks the database file and 
prevents my application from unloading. I'm using... |
|  |
| View on stackoverflow.com  | Preview by Yahoo |
|  |
|   |




an this is a video for the test I've done
https://vid.me/vSkS


FbEmbed.avi

|   |
|   |   |   |   |   |   |   |
| FbEmbed.avi MediaFire is a simple to use free service that lets you put all 
your photos, documents, music, and video in a single place so you can access 
them anywhere and share... |
|  |
| View on www.mediafire.com  | Preview by Yahoo |
|  |
|   |



this is the code


   Dim connectionString As String        connectionString = "User=SYSDBA;" + 
_"Password=masterkey;" + _"DataSource=localhost;" + _"Dialect=3;" + 
_"Port=3050;" + _"Charset=NONE;" + _"Role=;" + _"Connection lifetime=15;" + 
_"Pooling=true;" + _"MinPoolSize=0;" + _"MaxPoolSize=50;" + _"Packet 
Size=8192;" + _"ServerType=1;" + _"Database=" + "c:\Program 
Files\Firebird\Firebird_2_5\examples\empbuild\EMPLOYEE.FDB"
        Dim myConnection1 = New FbConnection(connectionString)        
myConnection1.Open()        myConnection1.Close()



I've disabled antivirus,firewall,tested on another machine:the same thing


Thanks.






 #yiv3171386270 #yiv3171386270 -- #yiv3171386270ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3171386270 
#yiv3171386270ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3171386270 
#yiv3171386270ygrp-mkp #yiv3171386270hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3171386270 #yiv3171386270ygrp-mkp #yiv3171386270ads 
{margin-bottom:10px;}#yiv3171386270 #yiv3171386270ygrp-mkp .yiv3171386270ad 
{padding:0 0;}#yiv3171386270 #yiv3171386270ygrp-mkp .yiv3171386270ad p 
{margin:0;}#yiv3171386270 #yiv3171386270ygrp-mkp .yiv3171386270ad a 
{color:#ff;text-decoration:none;}#yiv3171386270 #yiv3171386270ygrp-sponsor 
#yiv3171386270ygrp-lc {font-family:Arial;}#yiv3171386270 
#yiv3171386270ygrp-sponsor #yiv3171386270ygrp-lc #yiv3171386270hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3171386270 
#yiv3171386270ygrp-sponsor #yiv3171386270ygrp-lc .yiv3171386270ad 
{margin-bottom:10px;padding:0 0;}#yiv3171386270 #yiv3171386270actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3171386270 
#yiv3171386270activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3171386270
 #yiv3171386270activity span {font-weight:700;}#yiv3171386270 
#yiv3171386270activity span:first-child 
{text-transform:uppercase;}#yiv3171386270 #yiv3171386270activity span a 
{color:#5085b6;text-decoration:none;}#yiv3171386270 #yiv3171386270activity span 
span {color:#ff7900;}#yiv3171386270 #yiv3171386270activity span 
.yiv3171386270underline {text-decoration:underline;}#yiv3171386270 
.yiv3171386270attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3171386270 .yiv3171386270attach div a 
{text-decoration:none;}#yiv3171386270 .yiv3171386270attach img 
{border:none;padding-right:5px;}#yiv3171386270 .yiv3171386270attach label 
{display:block;margin-bottom:5px;}#yiv3171386270 .yiv3171386270attach label a 
{text-decoration:none;}#yiv3171386270 blockquote {margin:0 0 0 
4px;}#yiv3171386270 .yiv3171386270bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3171386270 
.yiv3171386270bold a {text-decoration:none;}#yiv3171386270 dd.yiv3171386270last 
p a {font-family:Verdana;font-weight:700;}#yiv3171386270 dd.yiv3171386270last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3171386270 
dd.yiv3171386270last p span.yiv3171386270yshortcuts 
{margin-right:0;}#yiv3171386270 div.yiv3171386270attach-table div div a 
{text-decoration:none;}#yiv3171386270 div.yiv3171386270attach-table 
{width:400px;}#yiv3171386270 div.yiv3171386270file-title a, #yiv3171386270 
div.yiv3171386270file-title a:active, #yiv3171386270 
div.yiv3171386270file-title a:hover, #yiv3171386270 div.yiv3171386270file-title 
a:visited {text-decoration:none;}#yiv3171386270 div.yiv3171386270photo-title 

Re: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

ok,thanks
This time,adding condition this way   WHERE FIEL1=:F1 AND FIEL2=:F2 AND    
(FIEL3=:F3 OR :F3 IS NULL)     INTO .. DO ..
is causing query to be much slower ...
this       WHERE FIEL1=:F1 AND FIEL2=:F2 AND    (FIEL3=:F3                      
            )     INTO .. DO ..takes  0.563s

82655 fetches, 1088 marks, 1584 reads, 50 writes.
197 inserts, 98 updates, 148 deletes, 19166 index, 66 seq.Delta memory: 11536 
bytes.Total execution time: 0.563s



but this  takes 29.141sWHERE FIEL1=:F1 AND FIEL2=:F2 AND    (FIEL3=:F3 OR :F3 
IS NULL)     INTO .. DO ..

1700290 fetches, 1065 marks, 3694 reads, 77 writes.198 inserts, 99 updates, 149 
deletes, 29422 index, 68 seq.Delta memory: -71656 bytes.Total execution time: 
29.141sScript execution finished.



in both cases  :F3  is NOT NULL
thanks


  From: Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] 
firebird-support@yahoogroups.com
 To: firebird-support@yahoogroups.com 
 Sent: Wednesday, August 19, 2015 11:51 AM
 Subject: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX
   
    19.08.2015 10:26, 'Mr. John' wrote:

 now index is used if I call
 SELECT * FROM MYPROC(...)
 but I use it in other procedures,no join on it just simply SELECT ..
 FROM MYPROC(...) in this case I can see in the plan :
 ...(MYPROC NATURAL)...

That' OK. In complex plans, (MY_PROC NATURAL) just means a select from a 
procedure, it says nothing about actual plans inside MY_PROC.

Dmitry

  #yiv8407870056 #yiv8407870056 -- #yiv8407870056ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8407870056 
#yiv8407870056ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8407870056 
#yiv8407870056ygrp-mkp #yiv8407870056hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8407870056 #yiv8407870056ygrp-mkp #yiv8407870056ads 
{margin-bottom:10px;}#yiv8407870056 #yiv8407870056ygrp-mkp .yiv8407870056ad 
{padding:0 0;}#yiv8407870056 #yiv8407870056ygrp-mkp .yiv8407870056ad p 
{margin:0;}#yiv8407870056 #yiv8407870056ygrp-mkp .yiv8407870056ad a 
{color:#ff;text-decoration:none;}#yiv8407870056 #yiv8407870056ygrp-sponsor 
#yiv8407870056ygrp-lc {font-family:Arial;}#yiv8407870056 
#yiv8407870056ygrp-sponsor #yiv8407870056ygrp-lc #yiv8407870056hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8407870056 
#yiv8407870056ygrp-sponsor #yiv8407870056ygrp-lc .yiv8407870056ad 
{margin-bottom:10px;padding:0 0;}#yiv8407870056 #yiv8407870056actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8407870056 
#yiv8407870056activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8407870056
 #yiv8407870056activity span {font-weight:700;}#yiv8407870056 
#yiv8407870056activity span:first-child 
{text-transform:uppercase;}#yiv8407870056 #yiv8407870056activity span a 
{color:#5085b6;text-decoration:none;}#yiv8407870056 #yiv8407870056activity span 
span {color:#ff7900;}#yiv8407870056 #yiv8407870056activity span 
.yiv8407870056underline {text-decoration:underline;}#yiv8407870056 
.yiv8407870056attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv8407870056 .yiv8407870056attach div a 
{text-decoration:none;}#yiv8407870056 .yiv8407870056attach img 
{border:none;padding-right:5px;}#yiv8407870056 .yiv8407870056attach label 
{display:block;margin-bottom:5px;}#yiv8407870056 .yiv8407870056attach label a 
{text-decoration:none;}#yiv8407870056 blockquote {margin:0 0 0 
4px;}#yiv8407870056 .yiv8407870056bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8407870056 
.yiv8407870056bold a {text-decoration:none;}#yiv8407870056 dd.yiv8407870056last 
p a {font-family:Verdana;font-weight:700;}#yiv8407870056 dd.yiv8407870056last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8407870056 
dd.yiv8407870056last p span.yiv8407870056yshortcuts 
{margin-right:0;}#yiv8407870056 div.yiv8407870056attach-table div div a 
{text-decoration:none;}#yiv8407870056 div.yiv8407870056attach-table 
{width:400px;}#yiv8407870056 div.yiv8407870056file-title a, #yiv8407870056 
div.yiv8407870056file-title a:active, #yiv8407870056 
div.yiv8407870056file-title a:hover, #yiv8407870056 div.yiv8407870056file-title 
a:visited {text-decoration:none;}#yiv8407870056 div.yiv8407870056photo-title a, 
#yiv8407870056 div.yiv8407870056photo-title a:active, #yiv8407870056 
div.yiv8407870056photo-title a:hover, #yiv8407870056 
div.yiv8407870056photo-title a:visited {text-decoration:none;}#yiv8407870056 
div#yiv8407870056ygrp-mlmsg #yiv8407870056ygrp-msg p a 
span.yiv8407870056yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8407870056 
.yiv8407870056green {color:#628c2a;}#yiv8407870056 .yiv8407870056MsoNormal 
{margin:0 0 0 0;}#yiv8407870056 o {font-size:0;}#yiv8407870056 
#yiv8407870056photos div {float:left;width:72px;}#yiv8407870056 
#yiv8407870056photos div div {border:1px solid 

Re: [firebird-support] MAKE 'EXECUTE STATEMENT' USE INDEX

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi,thanks for your answer
I remove pCondition variable and use :F3 insead (:F3=NULL means no F3  field 
condition,else F3 condition)and I simply have
WHERE FIEL1=:F1 AND FIEL2=:F2 AND    (FIEL3=:F3 OR :F3 IS NULL)     INTO .. DO 
..

now index is used if I call SELECT * FROM MYPROC(...)
but I use it in other procedures,no join on it just simply SELECT .. FROM 
MYPROC(...) in this case I can see in the plan :...(MYPROC NATURAL)...
very strange,I have to fix it because this query takes about 20 min
thanks!





  From: setysvar setys...@gmail.com [firebird-support] 
firebird-support@yahoogroups.com
 To: firebird-support@yahoogroups.com 
 Sent: Tuesday, August 18, 2015 8:03 PM
 Subject: Re: [firebird-support] MAKE 'EXECUTE STATEMENT' USE INDEX
   
 Den 18.08.2015 16:59, skrev 'Mr. John' mr_joh...@yahoo.com 
[firebird-support]:
  


 HI,in SP I have this query  
    FOR EXECUTE STATEMENT 'SELECT SUM(CANT)  FROM TABLE1 WHERE FIEL1='||:F1||' 
AND FIEL2='||:F2|| IIF(:pCondition=1,' AND FIEL3='||:F3,'')  INTO .. DO ..
     TABLE1 PK =FIELD1,FIELD2,FIELD3
  
   running the query gives a NATURAL PLAN 
  How to make it use the index? 
  Index is used if I change to:     FOR SELECT SUM(CANT)  FROM TABLE1 WHERE 
FIEL1=:F1 AND FIEL2=:F2 AND FIEL3=:F3 INTO .. DO ..
  but this way I can't use the IIF condition that I need 
  thanks! 
  
 Why would you need an IIF condition? What about
 
 FOR SELECT SUM(CANT)  FROM TABLE1 WHERE FIEL1=:F1 AND FIEL2=:F2 AND (FIEL3=:F3 
or cast(:pCondition as SmallInt) is distinct from 1) INTO .. DO ..
 
 That could at least use an index for FIEL1 and FIEL2 (if they are the first 
two fields in your PK, that index could be used). Now, in some cases the index 
may have poor selectivity so that it still chooses natural (you didn't say 
whether FOR SELECT SUM(CANT)  FROM TABLE1 WHERE FIEL1=:F1 AND FIEL2=:F2 INTO 
.. DO .. uses an index or not). If so, the only way to use the index would be 
to use IF in your procedure and two separate queries, the index being used if 
you run the query comparing with FIEL3, but no index used when you run the 
query with only FIEL1 and FIEL2.
 
 I've seen Dmitry Yemanov answer a different question (that may or may not be 
similar to yours) with repeating the first part and that could possibly 
translate to:
 
 FOR SELECT SUM(CANT)  FROM TABLE1 WHERE (FIEL1=:F1 AND FIEL2=:F2 AND 
FIEL3=:F3) or
 (FIEL1=:F1 AND FIEL2=:F2 AND cast(:pCondition as SmallInt) is distinct from 1)
 
 I never quite understood why I saw a similar statement to this, but I assume 
it doesn't hurt trying if my first suggestion fails.
 
 Set
  #yiv3118594155 #yiv3118594155 -- #yiv3118594155ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3118594155 
#yiv3118594155ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3118594155 
#yiv3118594155ygrp-mkp #yiv3118594155hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3118594155 #yiv3118594155ygrp-mkp #yiv3118594155ads 
{margin-bottom:10px;}#yiv3118594155 #yiv3118594155ygrp-mkp .yiv3118594155ad 
{padding:0 0;}#yiv3118594155 #yiv3118594155ygrp-mkp .yiv3118594155ad p 
{margin:0;}#yiv3118594155 #yiv3118594155ygrp-mkp .yiv3118594155ad a 
{color:#ff;text-decoration:none;}#yiv3118594155 #yiv3118594155ygrp-sponsor 
#yiv3118594155ygrp-lc {font-family:Arial;}#yiv3118594155 
#yiv3118594155ygrp-sponsor #yiv3118594155ygrp-lc #yiv3118594155hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3118594155 
#yiv3118594155ygrp-sponsor #yiv3118594155ygrp-lc .yiv3118594155ad 
{margin-bottom:10px;padding:0 0;}#yiv3118594155 #yiv3118594155actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3118594155 
#yiv3118594155activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3118594155
 #yiv3118594155activity span {font-weight:700;}#yiv3118594155 
#yiv3118594155activity span:first-child 
{text-transform:uppercase;}#yiv3118594155 #yiv3118594155activity span a 
{color:#5085b6;text-decoration:none;}#yiv3118594155 #yiv3118594155activity span 
span {color:#ff7900;}#yiv3118594155 #yiv3118594155activity span 
.yiv3118594155underline {text-decoration:underline;}#yiv3118594155 
.yiv3118594155attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3118594155 .yiv3118594155attach div a 
{text-decoration:none;}#yiv3118594155 .yiv3118594155attach img 
{border:none;padding-right:5px;}#yiv3118594155 .yiv3118594155attach label 
{display:block;margin-bottom:5px;}#yiv3118594155 .yiv3118594155attach label a 
{text-decoration:none;}#yiv3118594155 blockquote {margin:0 0 0 
4px;}#yiv3118594155 .yiv3118594155bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3118594155 
.yiv3118594155bold a {text-decoration:none;}#yiv3118594155 dd.yiv3118594155last 
p a {font-family:Verdana;font-weight:700;}#yiv3118594155 dd.yiv3118594155last p 
span {margin-right:10px;font-family:Verdana;font-weight:700

[firebird-support] MAKE 'EXECUTE STATEMENT' USE INDEX

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

HI,in SP I have this query
  FOR EXECUTE STATEMENT 'SELECT SUM(CANT)  FROM TABLE1 WHERE FIEL1='||:F1||' 
AND FIEL2='||:F2|| IIF(:pCondition=1,' AND FIEL3='||:F3,'')  INTO .. DO ..
  TABLE1 PK =FIELD1,FIELD2,FIELD3

 running the query gives a NATURAL PLAN
How to make it use the index?
Index is used if I change to:    FOR SELECT SUM(CANT)  FROM TABLE1 WHERE 
FIEL1=:F1 AND FIEL2=:F2 AND FIEL3=:F3 INTO .. DO ..
but this way I can't use the IIF condition that I need
thanks!
 

[firebird-support] How safe is to use SS and embedded version in the same time

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

HiI'm my application I'm using FB superserver for main data.I have some local 
data for application settings,different data (only for read) that can be 
updated on application update and for that I used some xml but I got couple 
corruptions,also can't secure it,etc. I need something else so I've tough to 
use FB embeded for that local data only and super server for main data, of 
course there are different databases for local and main data.Is safe to use 
superserver and embedded version in the same time?
thanks