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

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

[firebird-support] avoid query subselect

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

Re: [firebird-support] Help creating expression index

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

[firebird-support] Help creating expression index

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

Re: [firebird-support] query Integer overflow

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

Re: [firebird-support] query Integer overflow

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 a

Re: [firebird-support] query Integer overflow

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:

Re: [firebird-support] query Integer overflow

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

[firebird-support] query Integer overflow

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

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

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

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

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

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

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

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

. John' mr_joh...@yahoo.com [firebird-support] wrote: > what other way I could use?   Create database from scratch, pump data. --   WBR, SD. ++ Vi

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

uin 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"  -us

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

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

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

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

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

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

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

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

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

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

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

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,

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

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 th

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

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

[firebird-support] Turn on WireCompression on Firebird 3

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   

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

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 coup

[firebird-support] Deactivate triggers inside EXECUTE BLOCK

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

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

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 show

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

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

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 Kovy

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

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

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

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

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

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

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

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:

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

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

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

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 diffe

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

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

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

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

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

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

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]" To: "firebird-support@yahoogroups.com" Sent: Friday, April 14, 2017 9:13 PM Subject: RE:

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

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

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

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]

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

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

[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

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

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  

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

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

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

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

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

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

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

Re: [firebird-support] Embedded Firebird unload delay

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

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

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

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

@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

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

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

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

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