RE: [firebird-support] Cannot create simple table

> Trying to create a simple table and receive this error: > > unsuccessful metadata update > cannot create index PK_CUR_CASE_INV_NON_JUD_CNT > while executing: > ALTER TABLE CUR_CASE_INV_NON_JUD_CNTY ADD CONSTRAINT > FK_CUR_CASE_INV_RPT3 >   FOREIGN KEY (REPORT_ID) REFERENCES CUR_CASE_INV_RPT >

RE: [firebird-support] Server reboot during Windows exe setup?

> Is there a remote chance that this reboot has anything to do with the Firebird > installation then went on at that very second? Can it be related to the > installation of the Win32 runtimes that was going on at this time? The Firebird install would only prompt for a reboot as appropriate, it wo

RE: [firebird-support] Incorrect values within SQLDA structure SQLDA version expected between 1 and 1, found 0 when using Firebird 3.0 client with older (BDE) programa

> Am 14.07.2016 um 13:35 schrieb Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support]: > > 14.07.2016 13:33, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > >> Is this bug in Firebird 3.0 client and is there workaround? > >This is a bug in BDE and you must ask for workaround at Emb

RE: [firebird-support] FB 32 bits x FB 64 bits

> Dear Friends. > > One more time, a question around FirebirdSQL performance. > > I ran the same application before compiled 32 bits and after compiled 64 bits. > > The version compiled 64 bits ran  slowly  (much more) than 32 bits version. > > I dont believe this should be expected. Please re

RE: [firebird-support] Query with few reads is slower than query with many reads. Which query to choose?

> I am trying select contracts together with the contract lines. around 30.000 > contracts and around 800.000 contract lines.  And I have two queries that to > essentially the same (each contract has at least one contract_line): ... > All the reads of both queries are indexed reads. > > The qu

RE: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

> >>> 3.0.1 hasn't been released yet, but snapshot builds are available here: > >>> http://www.firebirdsql.org/en/snapshot-builds/ > >>> > >> > >> the link is dead > > > > Works here. I get the entry page regarding snapshot builds for all > > branches and Windows/Linux. Anyway ... ;-) > > > >> ht

RE: [firebird-support] Is Firebird 3 ready for Production?

> 27.05.2016 15:26, 'Leyne, Sean' s...@broadviewsoftware.com [firebird- > support] wrote: > > Avalerion??? > >Yes. Sorry, I meant what is Avalerion??? Sean

RE: [firebird-support] Is Firebird 3 ready for Production?

>Especially at version 5 which is on pre-release stage now in accompany with > Avalerion. >http://www.ibphoenix.com/ibpr_devel/ Avalerion??? Sean

RE: [firebird-support] Database Unavailable

Bill, > Used IB 10 years ago. Porting an SQL Anywhere app to FB 2.5. Going well > until I try to connect a client to the database - "database unavailable." I > have > shared the DB folder on my Windows 7 machine, can browse to it from a > client machine (Win 10) and see Full Control permissio

RE: [firebird-support] Re: SELECT WITH LOCK, WAIT transaction, deadlock

Dmitry, > 28.04.2016 16:19, Gabor Boros wrote: > > > In the language reference for "isc_tpb_read_committed + isc_tpb_wait" > > I see this: "Update conflict exceptions can never be raised by an > > explicit lock statement in this TPB mode." > > This is true for two concurrent transactions but may

RE: [firebird-support] Re: [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

> 1) We have sweep set to 0. We do monitor the transaction gab and if > needed, we interact. Any kind of automatic sweep under high load will kill > the server :) 1- Do you run a manual sweep on a regular basis? 2- What is the CPU % like when Firebird "slows down"? 3- Have you tried using Cr

RE: [firebird-support] FB 3.0

> 2. Anybody tested code with with FB 3.0 and Delphi and IBX ? Any problems ? > Can IBX properly access the boolean fields in FB 3.0 ? The IBX components are a third-party library, not produced by the Firebird project. Testing of components is the responsibility of the library developers/main

[firebird-support] RE: Database performance slowdown

> We are investigating an issue with one of our systems where it gradually > slows down during the course of a day. > > We have our  epos system that we write ourselves using Delphi XE2 and the > IBX components. > We have a group of tables that are updated during the end of sale save > process.

RE: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

> Hello, > > since 3 days during production the modified date does not chenge, is there a > reason why? Its the right database. This is a Windows issue, it does not update file properties until a file is closed. Since, you haven't closed the database file... Sean

RE: [firebird-support] How write a query with a progressive sum field

> I'm sure, IBReplicator does its job very well. I simply noted that V3 RC > should > be treated as not production-ready (like any other RC in Firebird's history), > but perhaps the Firebird project philosophy changed. It has not! RC releases should not be used for production purposes. > >

RE: [firebird-support] How write a query with a progressive sum field

> > I need add SALDO fields in the result of the query to get a > > progressive sum of CARICO - SCARICO. > > Although not that flexible as an ad-hoc query, but perhaps your particular > use case can be achieved with a selectable stored procedure ... A similar solution, one which could support s

RE: [firebird-support] How write a query with a progressive sum field

> > Needless to say, 3.0 is in release candidate state. Not sure if Luigi > > wants to run 3.0 in production yet. ;-) > >Nothing prevents him from installing of an additional server for report > purposes and setting up replication to it from production one. Seriously!?? Do you read you

RE: [firebird-support] Restoring Backup

Dimitry, > > When it is restoring data, it > > fills a data page and goes on to the next one. A large cache will > > fill with pages that will not be referenced again until the indexes > > are built. To build indexes, Firebird reads records and sorts by > > keys. That might suggest that keeping

RE: [firebird-support] 32 bit vs 64 bit arthmetic

Tim, > So I've got this stored procedure which takes DECIMAL(18,6) parameters and > returns DECIMAL(18,12) results, and internally copies stuff into and out of > DOUBLE PRECISION variables which it uses to call a UDF to do the actual > calculations. > > And the results are different (in the 8th d

RE: [firebird-support] An SQL query perform badly after firebird database file size grow beyond 8GB

> My guess is that the rows you're added reduces the selectivity of > SL_CSDTL_ITEMCODE and that this makes Firebird (incorrectly) believe that > the bad plan becomes better than the good plan. You can prevent Firebird > from using the bad plan by changing the query a bit (I've also changed it to

RE: [firebird-support] Bad performance of Firebird in Windows Server 2012

> The other is the fact that PDC machine will always have write cache disabled. It seems that this is not true for all disks attached to PDC server, only to boot/Windows drive. https://social.technet.microsoft.com/Forums/windowsserver/en-US/16352eee-6bc6-4858-8642-12b2496d39ee/how-to-enable-wr

RE: [firebird-support] Re: UPDATE to same record causing heavy disk I/O

> Right. When we were working on InterBase 1.1 (I think) a friend of Jim's > suggested using deltas for back versions to save space.  He's still a friend, > but > that feature was a real trial to implement and debug, partly because we ran > out of bits in the record header. With today's unlimit

RE: [firebird-support] 2 servers acessing one database

Rudi, > The shared SAN drive is very fast and provide the locking/visibility > guarantees, it is designed to do so. Do not inter-link SAN storage with accessing a database from 2 FB servers running on 2 nodes/systems. SAN storage (NAS storage is different) is fine for use, we have used it in th

RE: [firebird-support] Firebird on Raspberry Pi 2 : Problem to connect remotely

Have any of you success to install Firebird on Raspberry and able to connect to its database remotely via Windows machine? I have these settings on Raspberry Pi: - OS : Raspbian Jessie - Firebird 2.5 SuperServer I am curious, what is the use case that makes a Raspberry an appropriate solutio

RE: [firebird-support] Is it save to append some data at end of the binary firebird database file?

The same could be accomplished by creating a “Application_SchemaVersion” SP which would return the necessary details. The advantage would be that no search thru the domain would be required. Sean From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: December 3,

[firebird-support] MON$IO_Stats and prepared statements

All, We are investigating a client report of performance problems and are looking at the MON$IO_Stats values but they look very large. We are wondering if for prepared statements the values represent the total of all uses/executions of the prepared statement or just the last run. All answer wi

RE: [firebird-support] Writing to Aliases.conf in non-admin mode

Walter, While that answer is correct, the better answer would be for the Project to modify engine and installer to be Windows Vista+ compliant and have all configuration files stored in All Users\Application Data\Firebird and not in Programs Files\Firebird Sean From: firebird-support@yahoogr

RE: [firebird-support] date format

> http://www.sysprobs.com/change-date-format-windows-7-ddmm Why does this matter to this list? Sean

[firebird-support] RE: FirebirdSql.Data.FirebirdClient

> Hello, > I have used FirebirdSql.Data.FirebirdClient.dll for Compact Framework in PDA > devices. But I obtain new device with Windows Embedded Compact 7 now > and this library probably doesn't work. It generate > PlatformNotSupportedException. Do you know any help, please< For best answers, yo

RE: [firebird-support] Slow Query

Stef, > Can somebody please have a look at this query and let me know how I can > improve the performance (10 seconds execute time) You are processing the Journal table 3 times, for no real benefit AFAICT. BTW, what fields are indexed, in what combinations? To your question, how does this work

RE: [firebird-support] What is better: UPDATE or DELETE + INSERT?

> They will generate a comparable amount of garbage, but I think updating the > existing records is better than delete + insert, especially if there are also > foreign key references to those records. I don't think so. Unless you are updating every column in the row, the UPDATE will generate a

RE: [firebird-support] Another ordering question?

> Well, with all transaction numbers within a few hundred of each other > >     Oldest transaction    391428664 >     Oldest active        391428665 >     Oldest snapshot        391428665 >     Next transaction    391429145 Actually, there are 480 transactions between you and the OAT. > so tha

RE: [firebird-support] About firebird performance

> Hi Hector, > > > I discovered something else quite interesting: > > > > I realized both IB and FB dbs have pagebuffers set to 100.000. I changed FB > to 0 and now it works like I expected!!.. > > Same query now completes on FB on 50 sec. It seems this is the problem > although I don't under

RE: [firebird-support] Firebird backup on virtual machine

> > Veeam should not create file corruptions, but rather the backup of the > > database could have data from uncommitted transactions, although > > present in the db file, would be ignored by the engine (might show up > > in the log file). > > > My biggest concern was that after restore form Veea

RE: [firebird-support] Firebird backup on virtual machine

> > My biggest concern was that after restore form Veeam backup firebird > > database file could be damage. If not there is nothing I can worry > > about. I'm just want to be sure that when someone restore full vmdk > > file my system will work and survive such operation. > > Unless Veeam works

RE: [firebird-support] Firebird backup on virtual machine

> I have to run Firebird 2.5 in Windows 2012R2 on VMware cluster. All VM > machines will be regularly backup with Veeam Backup. I red that such > backups could cause database file corruption (inconsistency) within the > backup. Is there any method to prevent it? Veeam should not create file corru

RE: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

> The PER_PHONE table currently contain 579,873 rows > > 91455 or 15.771% is ‘G’ > > 166075 or 28.639% is ‘V’ > > For a total of 44.41% What about RefPerson index? What field is it based on? (I suspect Person) Many unique values are found in RefPerson index? Do you need to search on the

RE: [firebird-support] Plan evaluation in stored procedures

Aldo, > My question is: does the optimizer evaluates the plan for the query each > time the stored procedure is excecuted or is it evaluated only once, when > the stored procedure is compiled to BLR. > In the latter case it would be a dissadvantage because as time passes, > table cardina

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Using 2.5.4 FB Client to access a 1.5.3 DB database (Follow-Up)

> I guess all can tell I’m a little confused on if 32 bit and 64 bit Firebird > server/client can be mixed and matched for v2.5.4 and if whatever is placed > onto the work stations would be able to connect to v1.5.3 Firebird server > running on the old windows 2003 32 bit server. The Firebird serv

RE: [firebird-support] Simple query takes too much time

> El 29/07/2015 02:07 p.m., 'Leyne, Sean' s...@broadviewsoftware.com > [firebird-support] escribió: > > Jorge: > > > >> Using MSAccess, a single query to this table takes an average of 14 ms. > > You think *14ms* is slow?!?!?!? > When a similar que

RE: [firebird-support] RE: Possible to use FIRST 1 inside a group by?

inale------- > > Da: 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] > Data: 29/07/2015 18.59.03 > A: firebird-support@yahoogroups.com > Oggetto: [firebird-support] RE: Possible to use FIRST 1 inside a group by? > > > Maya, > > > Might not b

RE: [firebird-support] Simple query takes too much time

Jorge: > Using MSAccess, a single query to this table takes an average of 14 ms. You think *14ms* is slow?!?!?!? > SELECT "GTIN" ,"ACTIVO" FROM "TRAZABILIDAD_MEDICAMENTOS" WHERE > ("GTIN" > = ?) > ^^ > ^ > PLAN (TRAZA

[firebird-support] RE: Possible to use FIRST 1 inside a group by?

Maya, > Might not be the most efficient method, but this works: Unfortunately, it is least efficient method -- you will read each table row n^2 times Try: SELECT T.ID T.GroupID T2.FKCode T2.Value FROM ( select MIN (ID) as ID, GroupID from MyTable GROUP BY GroupID ) T JO

RE: [firebird-support] Problem with FB database that freezes

> gstat output (normal performance): > - >  Oldest transaction 18709808 >  Oldest active  18953295 >  Oldest snapshot  18851591 >  Next transaction 19520857 The large difference in Oldest Active and Next Transaction suggests that your pro

RE: [firebird-support] Firebird 3 and Gbak

Hugo, > I am trying to use my application while gbak makes backup, but a message is > raised 'File alredy in use by another'. Is gbak running on the same computer as the database? Are you trying to access the database via network share? Which FB version and server type (classic, SuperClassic or

RE: [firebird-support] Re: 450 active transactions after database restore, is it normal?

Dmitry, > 02.07.2015 19:36, 'Leyne, Sean' wrote: > > > >>> Oldest transaction1 > >>> Oldest active2 > >>> Oldest snapshot2 > >>> Next transaction492 > > > > Even it that

RE: [firebird-support] Re: 450 active transactions after database restore, is it normal?

Dmitry, > > Oldest transaction1 > > Oldest active2 > > Oldest snapshot2 > > Next transaction492 > > Gstat was started right after the restore. Is it normal to have so > > many active transactions right after the database restore? > > Yes. I suppose yo

RE: [firebird-support] Proper way for copy data from big table

> what is the proper way for copy data from big table to another database > if table is bigger then avaiable RAM and we need to do this in one > transaction? > You know if we do > SELECT * FROM SOURCE_TABLE - and table have e.g. 400 000 000 records > then retrive it is impossible because of RAM

RE: [firebird-support] Re: losing connection with server on a local PC

> We are having this same problem.  Looking at our server logs, it appears that > this issue started for us on May 2nd, and has happened 16 times since > then.  Before May, our server logs show it happening only about once per > month.  This server has been in operation since November of 2014. >

RE: [firebird-support] Re: losing connection with server on a local PC

> 1) With rare exception, it only seems to happen outside of business > hours.  Usually in the middle of the night, but sometimes shortly after > closing > or just before opening.  In the 16 instances in May so far, it only happened > during business hours twice. > > Here are the dates: > 5/2 10

RE: [firebird-support] Why index is not used in this query?

Bruce, > SELECT * FROM > TABLE_2 T2 >   INNER JOIN TABLE_1 T1  ON T2.TABLE_1_ID = T1.ID > > After executing this query I am getting such plan: > > PLAN JOIN (T1 NATURAL, T2 INDEX (FK_TABLE_2)) > > Why in case of TABLE_1 optimizer did not chose index PK_TABLE_1? Given that there is no ORDER BY

[firebird-support] RE: Firebird 2.1 - Shutting down

Dan, > We are a provider of a commercial software package that runs on the firebird > database,  this afternoon we have been deluged with offices calling that their > database is down.  In every case we are finding firebird 2.1 shut > down.  Restarting it seems to only last for a bit. > > Is anyo

RE: [firebird-support] Re: SQL Case query takes 4 minutes 30 seconds to execute !!

> No it should only return 1 line but even with “and jtype = j.jtype” added to > the subselect condition it still takes almost 5 minutes to return data Please provide the PLAN for the statement and the details of indexes defined for the queries tables. Sean

[firebird-support] RE: Scheduled maintenance for tracker.firebirdsql.org and web.firebirdsql.org servers has started

> > Changes are required to the hosts for these systems, which > > necessitates the outage. > > > > The outage is scheduled to last 4 hours. The work is completed! Thanks for your patience. Sean

[firebird-support] RE: Scheduled maintenance for tracker.firebirdsql.org and web.firebirdsql.org servers has started

> Changes are required to the hosts for these systems, which necessitates the > outage. > > The outage is scheduled to last 4 hours. An update. The work on the hosts/systems is taking much longer than expected. We will advise when the work has been completed. Sean

RE: [firebird-support] Database Size Is Not Reducing

On Apr 6, 2015, at 9:08 AM, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] mailto:firebird-support@yahoogroups.com>> wrote: I am using Firebird 2.5 database. what operating system? Also, what page size? How big (on average) was the size of the BLOB

[firebird-support] Scheduled maintenance for tracker.firebirdsql.org and web.firebirdsql.org servers has started

All, Changes are required to the hosts for these systems, which necessitates the outage. The outage is scheduled to last 4 hours. Sean

[firebird-support] Reminder: Scheduled maintenance for tracker.firebirdsql.org and web.firebirdsql.org servers -- Monday April 6, 2015 @ 9a (GMT - 4)

All, Changes are required to the hosts for these systems, which necessitates the outage. The outage is scheduled to last 4 hours. Sean

RE: [firebird-support] coalesce

> one short question, why is the Result of > coalesce(:variableVarchar(10),'NULL') not ,NULL' but rather 'NULL  ' with > blanks from varchar(10) length? What tool/application are you using to evaluate the result? As Dmitry and Mark have already pointed out, the result should be a VarChar(10

[firebird-support] Reminder: Scheduled maintenance for tracker.firebirdsql.org and web.firebirdsql.org servers -- Monday April 6, 2015 @ 9a (GMT - 4)

All, Changes are required to the hosts for these systems, which necessitates the outage. The outage is scheduled to last 4 hours. Sean

RE: [firebird-support] Connect via TCP and shared file parallel

> The share Z:\mysharedfolder\mydb.fdb is a folder on fileserver with the > Firebird Server itself on it. Accessing the database via myhost:mydb points to > the same file as Z:\mysharedfolder\mydb.fdb. The database path must use server-side local drive/path references, not shared folder paths.

RE: [firebird-support] Newbie question on how to hold an unusual data type

Marco, > Maybe storing it into a CHAR(22) using OCTECTS charset? While this will work and is the smallest storage footprint/representation. I would recommend to sacrifice disk space and to store the key as a string using a base 36 encoding (0-1 + A-Z) -- it makes debugging via tools much easi

RE: [firebird-support] Multiple WHERE clauses

Bhavbhuti, > I have a SELECT statement which needs to have a WHERE clause adapt if a > variable has a value or not: > >     WHERE CASE WHEN 72 <> 0 THEN tDevelopment.iID = 72 >     ELSE (CAST(tDevelopment.tDT AS DATE) BETWEEN (SELECT US1.dValue >     FROM dSetValue('Current Year', 'From') US1

RE: [firebird-support] What is the correct way to shutdown fb_inet_server from the CL?

Vadim, > Hi All, > what is the correct way to shutdown fb_inet_server  from the command line > (on Windows and Linux)? > To start the server, we use "fb_inet_server -a"   on Windows, > "fb_inet_server -m" on Linux. Because there are multiple fb_inet_server processes involved in a Classic server

RE: [firebird-support] Re: Speed issues

Ann, > > Zoran's complaint is about the first time the query is executed. In that > case, nothing would be in cache and everything would still need to be loaded > from disk. > > > A 2048 page cache may be small enough that it would cause problems even > during loading, given the size of his datab

RE: [firebird-support] Re: Speed issues

Karol, > What is your cache settings In this case, the answer won't really matter. Zoran's complaint is about the first time the query is executed. In that case, nothing would be in cache and everything would still need to be loaded from disk. Sean

RE: [firebird-support] Re: Speed issues

Zoran, > after full restore of the database, now with 8192 page size,  i got What is the Index Depth after the restore? Did you try the change to the order of the columns/fields in the compound index? > Operations > > Read   : 273 > Writes : 0 >

RE: [firebird-support] Re: Speed issues

> Params = field values, it is always  tof_link_la_typ.lat_typ_id and > tof_link_la_typ.lat_ga_id i search, but always with diferent params. OK > OS is Win7 x64 - its my development  machine. > I plan to put database on win2008 R2 x64 server wit 20GB RAM. That is the right RAM size > I dont

RE: [firebird-support] Re: Speed issues

Zoran, > I dont have other connections to database - I am runing it on my > development machine. timing for the second run never was a problem - > second query with same params is exretmly fast. Problem is that I dont have > 2 same params never one after first. And, whenever I change params, first

RE: [firebird-support] Re: Speed issues

> Hi Sean, > > Thanks for your reply. I did it, and you are right - selectivity is much > better. > But, what is not better is query execution time. ... > Query Time > > Prepare   : 31.00 ms > Execute   : 4,789.00 ms > Avg fetch time: 228

RE: [firebird-support] Speed issues

Zoran, > Query > > select distinct > articles.art_id, > articles.art_article_nr, > generic_articles.ga_id, > link_art.la_id, > link_la_typ.lat_sort sort, > link_la_typ.lat_sup_id bra_id, > articles.art_replacement > from link_la_typ > inner join gen

RE: [firebird-support] Unlock record

Eduardo, > I add some information to my previous mail. When I try to delete the record > of MON$ATTACHMENTS, the complete message I got is the following: > > SQL ERROR CODE:-817 > > SQL ERROR MESSAGE: > The insert, update, delete, ddl or authorization statement cannot >  be executed because the

RE: [firebird-support] nesting - weight calculation

> there is a table with all Material (stock), each one has a number. Now, in a > second table there is listed the material that is a part of the Material. > > For example: > > Material ABC > Material BCD > Material XXX > Material OMV > Material KOM > > Material OMV can be a Part of XXX and XXX

RE: [firebird-support] Big database optimization

Zoran, > I am runing WI-V2.5.2.26539 Firebird 2.5, on win 7 64 bit. Databse is more > than 20 GB big, and I have tables which are really huge - millions of rows. > > My query combines 6-7 tables, and all tables are searched with use of > indexes, so altough tables are huge, query fethes only 10.0

RE: [firebird-support] Bad surprise on performance

> Thank you for the prompt answer, Sean. > But, no, I have read about this specific one. > And though I am sure I did not fully understand about it yet, since my > biggest database is only 1 GByte I *thought* this would not be a > problem for me. Do you still have access to old server/

RE: [firebird-support] Bad surprise on performance

> Seems there will be a delay. I migrated the database from old hardware > running 1.5.4 to new hardware running 2.5.3. Backup/Restore is about 4 > times faster. Wow! > But normal working is - at least - 50% slower sometimes worse. > [Old] > Server 2003 x86 no service packs > Xeon with 4 GB RAM

RE: [firebird-support] Re: Firebird 1.5 - CURRENT_TIMESTAMP difference

> Unfortunately we're using 1.5 so "NOW" isn't available to us. Yes, it is. It is 'NOW' (note the single quotes) Sean

RE: [firebird-support] Join three tables problem

> i have tried > select > Seller.NameSeller, > sum(buyfromseller.qty*buyfromseller.cost) as buys, > sum(sell.qtysell*sell.price) as Sells, > from > Seller > left join buyfromseller on buyfromseller.fkseller=seller.idseller > left join sell on sell.fkseller=seller.idseller group by seller.namesell

[firebird-support] Outage for tracker.firebirdsql.org and web.firebirdsql.org from November 26 07:00 to 08:30 (EDT)

All, As previously mentioned, BroadView has moved offices. Well, tomorrow is the last step in our relocation. We will be changing our net connection to a new ISP and moving our firewalls from the old data centre to the new. This will affect the project tracker.firebirdsql.org and web.firebirds

RE: [firebird-support] FB 2.5 and lock

> Ok, rephrased: > > Is it possible that a deadlock causes all connections to all databases to > freeze? > > And if not, is there a known cause for all connections to all databases to > freeze? What Firebird engine type (Classic, SuperServer)? What does the database page header details for t

RE: [firebird-support] Left outer join with stored procedure

The correct syntax for JOINing to an SP would be: select regioni _ID, stored_procedure_value from regioni left outer join stored_procedure (:DATE1,:DATE2) ON 1 = 1 <-- Sean From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: November-19-14 9:25 AM To:

RE: [firebird-support] Re: Cross database update

Again, this question should be directed to the appropriate IBExpert support forum/list/group. Sean From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: November-18-14 12:00 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Re: Cross database

RE: [firebird-support] Re: Why does the optimizer choose NATURAL for this tiny table?

> 13.11.2014 14:39, Svein Erling Tysvær wrote: > > > D1) ON p.icd10 = t.icd10 > > > > These change the plan to: > > PLAN JOIN (MERGE (SORT (JOIN (P NATURAL, G INDEX > > (I_ICD10_GRUPPE_ICD10))), SORT (JOIN (T KID INDEX > (U_NPR_KRG_ID_FNRK), > > T N INDEX (I_NPR_KRG_ID), T T INDEX (I_NPR_TILSTAND

RE: [firebird-support] Re: Why does the optimizer choose NATURAL for this tiny table?

> Does the plan change to INDEX if the condition would be: > 1) ON p.icd10 = t.icd10 > 2) ON p.icd10 = t.icd10 OR p.icd10 = t.icd10 I think you meant ON p.icd10 = t.icd10 OR p.icd10 = substring(t.icd10 from 1 for 3) Sean

[firebird-support] RE: Why does the optimizer choose NATURAL for this tiny table?

> I have an EXECUTE BLOCK statement, for which a small part goes NATURAL > where I'd expect it to use an index associated with a UNIQUE CONSTRAINT. > > I would expect > > JOIN icd10_purres p ON p.icd10 IN (t.icd10, substring(t.icd10 from 1 for 3)) > > to use an index, maybe something along the

[firebird-support] RE: Firebird 2.0 Support Windows Server 2012?

> we have a Software that only Support Firebird 2.0. > Now we had changed the OS from Windows Server 2003 to Windows Server > 2012. But you likely changed from 32bit Win2003, so you are experiencing the expected problem of Window Cache/Pages management with 64bit OS. > Is there anything to con

RE: [firebird-support] GTT data available between transactions and connections?

Bhavbhuti, If not, how efficient is create an actual table just for such records purposes, create in one app and use them in another and then delete the rows in the app? It can be very efficient if you don’t create too many/any indexes (reminder: with FB a Primary Key is not required for table

RE: [firebird-support] Re: Request new feature - better perfomance

> Try this one: > > select x.* from ( >   select something, anotherthing, >   (select sum(thirdthing) from second b where b.something = a.something) > total >   from a > ) x where x.total > 10 While all of the suggestions are appropriate for an immediate work around, the OP original point is st

RE: [firebird-support] Firebird v2.5 running Classic mode

> Taskkill will be ok if no one user worked with yours database and no internal > process worked with your database. And it's not OK when you have more > than one database on such server, because you interrupt working sessions to > another databases. All of which will not corrupt a database if F

RE: [firebird-support] Firebird v2.5 running Classic mode

> If you execute taskkill /IM fb_inet_server.exe /F then you are kill your > database(broken indexes, missing data or some else things. if autosweep is > on, you may completely kill your database). Not true at all! We use taskkill all of the time to force a shutdown of FB instances when we nee

RE: [firebird-support] BLOB

Carlos, > LSSBcfs> Our application uses BLOB fairly extensively and can report > LSSBcfs> that the GBAK disk write rate increases very significantly when > LSSBcfs> tables with Blobs are being backed-up, orders of magnitude > LSSBcfs> faster than tables with small rows (YMMV), so this suggests > L

RE: [firebird-support] BLOB

Mark, > I am not sure how gbak reads blobs, but if it honours the defined segment > size, IIRC, Ann has mentioned that SEGMENT SIZE is a legacy issue that hasn't really been used in some time. Our application uses BLOB fairly extensively and can report that the GBAK disk write rate increases v

RE: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on Windows server 2012 R2

Fabiano, > Number of guaranteed writes is much lower on SSD. **Not true** for all SSD/flash based devices. Certainly true for low end/consumer Flash/SATA devices. > when FB tries to write some write operations will fail and database will be > corrupted. Again, not true, as a broad statement.

RE: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on Windows server 2012 R2

> Hello, > I have installed Firebird 2.5.3 SuperServer x64 on a Windows server 2012 R2 > (x64). > At the moment I have done no changes in firebird.conf > > Hardware resources are: > 2 x 12core Intel Xeon, 32 GB DDR3 Ram, 6 x 1.2TB SAS RAID 10, 1 GB Ram on > 6Gbps RAID controller with Flash Backu

[firebird-support] Rescheduled: Maintenance/outage for tracker.firebirdsql.org and web.firebirdsql.org from Sept 20 08:00 to Sept 21 18:00 (EDT)

All, The previously mentioned ISP problems have been resolved, so the server room equipment move is happening tomorrow. Although the move should be largely completed on the 13th, there may be issues which could drag into the 14th. This will affect the project tracker.firebirdsql.org and web.fi

RE: [firebird-support] Select based upon date between two date fields

> Why is his approach wrong, Sean? It might be unusual to have the constant > on the left side of a comparison, but I'm sure I've done it when it is the > easiest way to write a query. Agreed, that might be my own bias showing. Also, BETWEEN would not use indexes whereas my query would ;-] S

RE: [firebird-support] Select based upon date between two date fields

> The sql is below. It works fine until I add the BETWEEN statement. Hopefully > you can point out something simple that I am doing wrong. > > > SELECT description, WOReqd, Addontype as AddonTypeID, RatebookID FROM > rentaladdons LEFT JOIN rentalratebook on rentaladdons.ratebookID = > rentalrat

RE: [firebird-support] Re: Help!!! - Problem with Firebird Embeded

>> What's this file? It should be fbembed.dll renamed to fbclient.dll. If it's >> not, >> then it's the regular client API and you're getting the error because >> there's no >> server. > > Yes this is fbembed.dll from the Firebird-2.5.2.26539-0_x64_embed.zip root > folder renamed to fbclient.d

[firebird-support] CANCELLED: Maintenance/outage for tracker.firebirdsql.org and web.firebirdsql.org from Sept 13 08:00 to Sept 14 18:00 (EDT)

> As previously mentioned, BroadView is moving offices.  Well, this weekend > we are moving our server room equipment to our new location. > > Although the move should be largely completed on the 13th, there may be > issues which could drag into the 14th. > > This will affect the project tracker

RE: [firebird-support] SQL Error -104

> i just don't get it what the heck i'm doing wrong. I would like to have > something like that: > > select ba.artno > from mov_invoices mi, bas_articles ba > where mi.invdate between '2014-05-01 00:00:00' and '2014-08-01 00:00:00' > and case > when (ba.artno like '90__') then '9000' > when (ba.

<    1   2   3   4   5   6   >