Re: [firebird-support] How does the optimizer of Firebird determine join order?

2014-05-14 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, May 13, 2014 at 10:37 PM, Zhan Li zhanl...@gmail.com[firebird-support] firebird-support@yahoogroups.com wrote: Hi All, I've been studying the optimizer of firebird for a while, and I was wondering how the optimizer chooses join order? As most query optimizers determine join order

Re: [firebird-support] Re: database became broken for any reasons

2014-05-19 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Fri, May 16, 2014 at 1:46 AM, markovdmi...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: I use gfix for define broken DB or not, and I try to do backup and restore. I may see a lot of diffrent errors, for example orphan pages, corrupted indexes, also orphan

Re: [firebird-support] Re: database became broken for any reasons

2014-05-20 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mon, May 19, 2014 at 1:31 PM, markovdmi...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: For preventing orphan pages or backversions I turn off autosweep. So for the last month I don't see any orphan pages or orphan backversions. Probably you were shutting the

Re: [firebird-support] filter conditions: WHERE vs. JOIN clause

2014-05-27 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, May 27, 2014 at 11:17 AM, jakef...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: We have some new members of our team with a MS SQL background, and they have a preference for including filter conditions in the JOIN clause. They say, the predicates in the ON

Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-27 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Sat, May 24, 2014 at 7:43 AM, Halim Boumedjirek halim1...@hotmail.com[firebird-support] firebird-support@yahoogroups.com wrote: I used default restore settings and I got over 8 hours of restore time. Increasing the cache size using gfix -b did not help at all. I got the same result. I

Re: [firebird-support] Update only changed tuple/ execute if-statement via execute statement?

2014-05-30 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Sat, May 24, 2014 at 8:51 AM, eric wulfhekel eric.wulfhe...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: I want to create a update trigger which sets the current date to a field modified if values has changed. I have a lot of tables with a lot of columns so i want

Re: [firebird-support] this keeps happening

2014-06-23 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jun 22, 2014, at 3:58 AM, MYKS51 my...@telus.net [firebird-support] firebird-support@yahoogroups.com wrote: Using SAM 2014.3 on Win7 system with built into SAM, Firebird. Whenever I try to reboot my computer it hangs at Shutting Down and though I've waited as long as 10 minutes it

Re: [firebird-support] no-wait vs wait transactions?

2014-07-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 8, 2014, at 3:37 PM, jonatan.laurit...@yahoo.dk [firebird-support] firebird-support@yahoogroups.com wrote: I have Firebird 2.x database which from time to time has rather long transactions - up to 30 seconds and so, there is high probability that the same record will be updated

Re: [firebird-support] no-wait vs wait transactions?

2014-07-10 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 9, 2014, at 3:09 PM, jonatan.laurit...@yahoo.dk [firebird-support] firebird-support@yahoogroups.com wrote: 1) Almost all of A-transactions end with success in my case, so almost always B-transactions will fail with deadlock message anyway. Therefore the wait mode has no

Re: [firebird-support] Synchronisation between two processes

2014-07-12 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
Sorry, from my phone, sobad formatting and terse. What transaction isolation mode(s) are you using? Ordinarily direct file access is limited to one process. What version of Firebird? Ann On Jul 11, 2014, at 10:31 AM, Bryan Cole bryan.c...@teraview.com [firebird-support]

Re: [firebird-support] Skip records

2014-07-28 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 22, 2014, at 9:47 AM, 'checkmail' check_m...@satron.de [firebird-support] firebird-support@yahoogroups.com wrote: I would like to read every n record, depending on number of records. Do you care if your results are repeatable? If so, you'll have to sort all the records then skip

Re: [firebird-support] Re: Very long transaction start after deleting a big number of records.

2014-07-30 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 29, 2014, at 12:26 AM, brucedickin...@wp.pl [firebird-support] firebird-support@yahoogroups.com wrote: I haven't thought about scanning all the rows with SELECT after DELETE but it might be something. Perhaps FB 3.0 will help us with this. Doing the select in the same transaction

Re: [firebird-support] CONTAINIG vs. LIKE

2014-08-06 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
Containing is not case sensitive and cannot use an index. But it could not be indexed anyway because thestring could occur anywhere in the field, not just at the start. Starting (or is it starts?) is case sensitive and equivalent to like% so it can use an index. Good luck, Ann On Aug 4,

Re: [firebird-support] Forced write, page size and buffer size

2014-08-20 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 20, 2014, at 9:05 AM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] firebird-support@yahoogroups.com wrote: The hard truth is that the only _absolute guarantee_ to prevent database corruption is FW = ON. Provided that the file system also has barrier enabled ...

Re: [firebird-support] Case insensitive search on a memo field

2014-09-05 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Fri, Sep 5, 2014 at 8:43 AM, Stefan Heymann li...@stefanheymann.de [firebird-support] firebird-support@yahoogroups.com wrote: I’m using Firebird 2.5.3, and I am looking for text in a emo field, eg. I’m tempted to do something like Select * from mytable t where lowercase(t.mymemo) like

Re: [firebird-support] Firebird Embedded corruptions

2014-09-14 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Sat, Sep 13, 2014 at 12:22 PM, Jan Flyborg jan.pers...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: We have shipped Firebird Embedded bundled together with our product for a few years now and the system is currently in production at several thousand of our

Re: [firebird-support] Firebird Embedded corruptions

2014-09-19 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mon, Sep 15, 2014 at 7:41 AM, Jan Flyborg jan.pers...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: I just made another posting where I tried to describe three different examples of things we have seen. The first was a wrong page type, which sounds like a bug that

Re: [firebird-support] read-only select generates 'lock conflict on no wait transaction'?

2014-09-19 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Thu, Sep 18, 2014 at 1:00 PM, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] firebird-support@yahoogroups.com wrote: If you are sure that there will be no data editing, I recommend you to use ReadCommited+ReadOnly transaction, since it will not block garbage collection.

Re: [firebird-support] Firebird Embedded corruptions

2014-09-23 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Sep 23, 2014 at 10:49 AM, Jan Flyborg jan.pers...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: The first was a wrong page type, which sounds like a bug that was fixed in a newer version in code that's common to all Firebird architectures. In your case, the

Re: [firebird-support] BLOB

2014-10-10 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Fri, Oct 10, 2014 at 9:58 AM, tiberiu_horv...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: my BLOB records are plain text phrases, somewhere between 1 and 400 char-s , containing setup information (in Delphi I save a TStringList to file and I backup that file in my

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-30 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Oct 29, 2014, at 9:36 PM, Geoff Worboys ge...@telesiscomputing.com.au [firebird-support] firebird-support@yahoogroups.com wrote: Doesn't that depend on how they implemented the separate threads? SS does/can use different threads for separate connections to the same database, can't it?

Re: [firebird-support] Re: In Firebird can you tell when a Stored procedure has been compiled

2014-12-20 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
Having corrected some top-posting for clarity... On Thu, 18 Dec 2014 18:28:56 -0500, 'Edward Mendez' emendez...@nc.rr.com [firebird-support] firebird-support@yahoogroups.com wrote: Can you tell in Firebird 2.1.x or 2.5.x when a stored procedure has been compiled? It is compiled (to

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

2014-12-26 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Dec 24, 2014, at 3:22 AM, brucedickin...@wp.pl [firebird-support] firebird-support@yahoogroups.com wrote: I have two threads which constantly and at the same time are writing to this table: UPDATE OR INSERT INTO PARAMS (NAME) VALUES(:P_NAME) MATCHING (NAME) RETURNING ID;

Re: [firebird-support] Re: Firebird Embedded open database file on network share

2015-01-22 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jan 22, 2015, at 5:06 AM, ralf.erdm...@web.de [firebird-support] firebird-support@yahoogroups.com wrote: So I now know I had no good idea with the network share :-) I hope I made that clear :-) I thought it possible because I read that firebird embedded is at most the same engine

Re: [firebird-support] Problem with sub-optimal query plan

2015-02-03 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Feb 3, 2015, at 8:17 AM, Fulvio Senore mail...@fsoft.it [firebird-support] firebird-support@yahoogroups.com wrote: I want to retrieve rows showing INVOICES data and some CUSTOMERS data so I use an inner join, and I want to see newer invoices first so I add an ORDER BY clause. I only

Re: [firebird-support] How to join records

2015-02-16 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Feb 16, 2015, at 4:22 AM, josef.gschwendt...@quattro-soft.de [firebird-support] firebird-support@yahoogroups.com wrote: we have 2 tables For each record in Table1 there are 2 records in Table2. Table1 (T1) == 1 2 Table2 (T2) T2T1 == 11 21 3

Re: [firebird-support] How to join records

2015-02-17 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Feb 17, 2015, at 7:26 AM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote: Could Common Table Expressions or Derived Tables bring any advantages? I suppose you could use a combination of the two suggestions: [good

Re: [firebird-support] There is a simple way to rename constraint that have not a name?

2015-02-01 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jan 30, 2015, at 1:40 PM, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] firebird-support@yahoogroups.com wrote: There is a way to rename constraint that have not a name? UPDATE rdb$relation_constraints SET rdb$constraint_name = 'MyPrimaryKeyName' WHERE

Re: [firebird-support] FW: FB 2.5.1 db's needing restore

2015-01-12 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mon, Jan 12, 2015 at 10:40 AM, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] firebird-support@yahoogroups.com wrote: *I noticed that, when upgrading to 2.53, it is highly advisable to restore db’s that were on 2.5.1, as stated in the docs :* *Warning re Databases Created

Re: [firebird-support] Re: Speed issues

2015-02-10 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Feb 9, 2015, at 11:52 AM, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] firebird-support@yahoogroups.com wrote: What is your cache settings [2048] Zoran's complaint is about the first time the query is executed. In that case, nothing would be in cache and

Re: [firebird-support] Check constraints vs. user defined triggers

2015-01-04 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Dec 29, 2014, at 9:56 PM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] firebird-support@yahoogroups.com wrote: No one has answered, so I'll offer a not-very interesting suggestion. I have a table with four check constraints, which basically check logical conditions

Re: [firebird-support] Database paths and aliases

2015-03-22 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mar 21, 2015, at 6:29 AM, Emil Totev em...@tot-consult.com [firebird-support] firebird-support@yahoogroups.com wrote: Can there be any problem with a database, accessed simultaneously by some or all of the following methods: -- database file full path, /srv/firebird/mydb.fdb --

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

2015-03-22 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mar 22, 2015, at 7:01 AM, 'Parzival' parzival1...@gmx.at [firebird-support] firebird-support@yahoogroups.com wrote: I am running Firebird 2.5.0 on Windows for some time on several customer locations. When the client and the server are in the same network the performance is good. It

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

2015-03-06 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mar 6, 2015, at 9:58 AM, brian br...@meadows.pair.com [firebird-support] firebird-support@yahoogroups.com wrote: My problem is that I must avoid duplicated records in the database, the unique key is a complicated structure containing four 16-bit words plus a 108-bit set of flags. The

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

2015-03-07 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mar 7, 2015, at 9:43 AM, brian br...@meadows.pair.com [firebird-support] firebird-support@yahoogroups.com wrote: Thanks folks, particularly to Ann - that bit about the way Firebird arranges the indexes itself was the clincher. It seems difficult to find a full manual for Firebird

Re: [firebird-support] windows client debian server

2015-03-07 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mar 7, 2015, at 7:07 AM, wolfgangschammhaust...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: very basic, using on Linux debian 7 firebird2.5-super, must i use on the windows7 clientside the same version? No. You can use an older or newer client. The

Re: [firebird-support] How do I get my database back?

2015-03-24 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Mar 24, 2015 at 11:42 AM, Tim Ward t...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: gbak: ERROR:validation error for column BOXNUMBER, value *** null *** gbak: ERROR: warning -- record could not be restored gbak:Exiting before completion due to errors I'm

Re: [firebird-support] Scope of uniqueness constraint?

2015-04-01 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Apr 1, 2015, at 5:51 AM, Tim Ward t...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: (1) Transaction 1 - check for EXXON, find it doesn't exist (2) Transaction 1 - create EXXON (3) Transaction 2 - check for EXXON, find it doesn't exist (because it can't see

Re: [firebird-support] Character sets. (Again.)

2015-03-31 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mar 30, 2015, at 7:01 AM, Tim Ward t...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: Sorry about this, but I really can't work out what's going on here, and could do with some clues. Not so much a clue as a question. If you declare the columns as varchar, do

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-24 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Feb 24, 2015, at 3:29 AM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote: Sukhen wrote: update never fails but it fails in insert query. loop run in a single connection with a new datarows in same query. I

Re: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-24 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Feb 23, 2015, at 1:06 AM, SUKHEN DASS sukhend...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird table. First, you've hijacked a thread, which is not considered

Re: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-20 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
Thomas, Gbak backup removes all unnecessary back versions and all rolled back changes, unless it is run with the -g switch. That switch is provided for those cases where a database cleanup is not needed. Examples include the case when the database will immediately be replaced by a restored

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

2015-03-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mar 7, 2015, at 4:12 AM, 'Louis van Alphen' lo...@nucleo.co.za [firebird-support] firebird-support@yahoogroups.com wrote: For storage purposes I would use normal column types, ints, whatever. OK. For duplicate checking, I would in the app, calculate a unique hash from all the

Re: [firebird-support] large system slows over time

2015-05-05 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
Hi Nick, I have a system that is slowing down the longer it stays running and I'd like to know why. ... Is there any evidence I can gather before I reboot the system which I expect (from past experience) will return the system to the better performance Hmmm If rebooting will

Re: [firebird-support] large system slows over time

2015-05-06 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On May 5, 2015, at 2:38 PM, Jesus Garcia jeg...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: Hello, I think the problem is the database fragmentation along the time. I have databases in production 24x7x365. If I backup and restore on a test environment, the time

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

2015-05-15 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On May 15, 2015, at 9:02 AM, brucedickin...@wp.pl [firebird-support] firebird-support@yahoogroups.com wrote: 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

Re: [firebird-support] Re: How to determine size of database structures?

2015-05-15 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On May 15, 2015, at 2:14 AM, brucedickin...@wp.pl [firebird-support] firebird-support@yahoogroups.com wrote: This is nice tool, however it does not show how much space is taken by given table and its indices... I am sure this can be deduced by reading gstat output file but I don't

Re: [firebird-support] garbage collect

2015-04-09 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Apr 9, 2015, at 11:01 AM, Nick Upson n...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: to make sure I've got this right Not quite. starting with the same database I can do either a) gbak with gc Won't advance the oldest active b) gbak without gc and

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

2015-04-06 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Apr 6, 2015, at 9:08 AM, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] firebird-support@yahoogroups.com wrote: I am using Firebird 2.5 database. what operating system? Cheers, Ann

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

2015-04-06 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Apr 6, 2015, at 9:08 AM, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] firebird-support@yahoogroups.com wrote: I am using Firebird 2.5 database. I have a table that has column of type Blob field, this table also contains some other columns. The issue is, I had total

Re: [firebird-support] garbage collect

2015-04-05 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Apr 5, 2015, at 11:23 AM, Nick Upson n...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: is there any effective difference between doing gbak with gc and gbak without gc and then gfix -sweep The only differences (that I can think of) are caused by concurrent

Re: [firebird-support] Re: V1.56 query killing my V2.54 app

2015-04-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Apr 8, 2015, at 10:05 AM, andrew_s_...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: Let's see when histograms come to the party, it'll make things more interesting for sure. G Histograms may be less useful in Firebird than you might think, unless there's a

Re: [firebird-support] Altering a domain

2015-06-16 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Jun 16, 2015 at 11:15 AM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] firebird-support@yahoogroups.com wrote: I have defined the following domain : CREATE DOMAIN CURRENCY AS decimal(9,2) I would like to alter it as the following : ALTER DOMAIN CURRENCY AS

Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On 6/12/2015 2:11 PM, Jack Mason jackma...@mindspring.com [firebird-support] wrote: Thank you very much. I will try the -o switch and the gfix suggestion as well. Don't bother with gfix. It does a physical database check - pointers point to what they should, pages are the right type,

Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On 6/11/2015 11:05 AM, Jack Mason jackma...@mindspring.com [firebird-support] wrote: However, that won't help us. Our concern is that we have been backing up our databases for years and it has been a fruitless exercise. We cannot restore them. We did not have that problem with Interbase

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On 6/11/2015 4:33 PM, Jack Mason jackma...@mindspring.com [firebird-support] wrote: Why is everyone else not having this problem? The databases are Firebird databases. For 15 years we had no corruption from Interbase 6. Two years ago, we backed up our databases with Interbase 6 gbak and

Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-21 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 21, 2015, at 2:13 PM, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: Without using CONSTRAINT doesn't work and in such case the name is choosed by Firebird, not for me. For add a Primary Key to a table

Re: [firebird-support] Is it safe to have multiple instances of Gbak with garbage collection?

2015-08-20 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 19, 2015, at 5:49 PM, tvd...@ymail.com [firebird-support] firebird-support@yahoogroups.com wrote: I believe it is generally safe to have multiple simultaneously running instances of Gbak backing up the same server, when all of them read data from within their own transaction.

Re: [firebird-support] Knowing the previous rows

2015-08-07 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 7, 2015, at 1:56 PM, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: Well, after run GSTAT and reading the output I can see how many garbage a whole table has, but it don't shows me the story of a row. ¿How

Re: [firebird-support] Composite Primary Key in JOIN - performance

2015-08-11 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 11, 2015, at 4:59 AM, steve.decle...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: ...when I take a look at the small lookup tables used to store payment conditions, currency codes, titles, etc, the primary key is always VARCHAR(4) to either store a

Re: [firebird-support] Reads inconsistency between FB TraceManager and IB Planalyser

2015-08-11 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 11, 2015, at 12:22 PM, 'Louis van Alphen' lo...@nucleo.co.za [firebird-support] firebird-support@yahoogroups.com wrote: Sure I understand that, but the reads/fetches are 3000 to return 1 row. Which involves a four way join, on top of having to find and use the system tables to

Re: [firebird-support] Reads inconsistency between FB TraceManager and IB Planalyser

2015-08-11 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 11, 2015, at 1:30 PM, 'Louis van Alphen' lo...@nucleo.co.za [firebird-support] firebird-support@yahoogroups.com wrote: Thanks Ann, so maybe the 2 tools' metric are different. So maybe FBTM includes all (low level) reads and IP only user table reads. Or maybe one runs some queries

Re: [firebird-support] Knowing the previous rows

2015-08-07 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
The idea is to know how many garbage a table has. Or several tables. Or the whole database. That you can find out with gstat. It won't tell you how bad each record is, but it will tell you the total number of back version, average, min, and max chain lenght. Then you can set up

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

2015-08-10 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 10, 2015, at 8:15 AM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] firebird-support@yahoogroups.com wrote: does it mean that if the database is shut down periodically the stored procedure plans would be recalculated ? Shutting the database periodically solves

Re: Rif: [firebird-support] Chararacter set NONE to ISO8859_1

2015-07-26 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On 24-7-2015 21:37, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: I wonder if the following strategy has any pitfall: 1) Create the temporary field of the right character set 2) Fill it with data, using CAST to OCTETS as suggested by The Firebird Book 3) Alter

Re: Rif: [firebird-support] Chararacter set NONE to ISO8859_1

2015-07-26 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Sun, Jul 26, 2015 at 3:19 PM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] firebird-support@yahoogroups.com wrote: Why do you say that All but SQL are now dead and BLR is an artifact without benefit ? There is absolutely no interest in interoperability between database

Re: [firebird-support] Re: Firebird Indexing problem

2015-10-23 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Fri, Oct 23, 2015 at 2:40 AM, drci...@yahoo.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > I don't think I understand you fully. Indexed reads a hudreds of times > faster than non indexed. > Yes, when you're looking for a specific value. When you're looking for

Re: [firebird-support] SQL Optimation best way

2015-11-04 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Wed, Nov 4, 2015 at 8:41 AM, 'checkmail' check_m...@satron.de [firebird-support] wrote: > > > two tables > > > > A: > > Field1, Field2, Field3, Field4, Field5 > > > > B > > FieldA, FieldB, FieldC > > > > Now I would like to get the following: > > > >

Re: [firebird-support] Optimize query for date ranges

2015-10-11 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
> On Oct 11, 2015, at 5:00 AM, 'Parzival' parzival1...@gmx.at > [firebird-support] wrote: > i am running a simple query where the result contains 3 records. The query > should provide all records in a specific week. > > > > > SELECT * FROM

Re: AW: [firebird-support] Optimize query for date ranges

2015-10-13 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Oct 13, 2015 at 3:47 PM, 'Parzival' parzival1...@gmx.at [firebird-support] wrote: > Hello Thomas, > > the result set contains 3 record for criteria. > > Records DATUM >= '5.10.2015' = 102 > Records DATUM <= '11.10.2015' = 26 > > It seems that both

Re: AW: [firebird-support] Changing Columns

2015-07-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 7, 2015, at 2:25 AM, 'checkmail' check_m...@satron.de [firebird-support] firebird-support@yahoogroups.com wrote: .. or is there an option to export all data from the database without database itself, then I can change the ddl, create a clean database and import the data again? If

Re: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 8, 2015, at 8:14 AM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote: Take a look here: http://www.firebirdfaq.org/faq361/ I'd add that restore also has a -use_all_space option. If you don't specify this,

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

2015-08-28 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 28, 2015, at 2:40 AM, Macma mac...@wp.pl [firebird-support] firebird-support@yahoogroups.com wrote: 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

Re: [firebird-support] About firebird performance

2015-09-05 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Sat, Sep 5, 2015 at 12:00 PM, Hector Sánchez hec...@planatec.es [firebird-support] wrote: > > > 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

Re: [firebird-support] Error on Gfix

2015-09-30 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Sep 29, 2015 at 4:50 PM, Jeferson Sisto jsis...@gmail.com [firebird-support] wrote: > > > Ok, I know this full procedure about corrupt database. > > But, when the unique problem about corrupt database is ORPHAN PAGE. In > this especific situation, is

Re: [firebird-support] AW: Performance comparision for primary keys - int vs. varchar

2015-10-03 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Fri, Oct 2, 2015 at 5:09 PM, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > > > I’m using integer IDs for primary keys in my tables. What if I would use > varchar fields instead? Will I lose performance in that case, especially > for big

Re: [firebird-support] Re: SELECT for get the number of contexts

2015-09-27 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Sun, Sep 27, 2015 at 1:37 PM, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > The only way to know how many contexts a stored procedure has is looking > at the source code and counting handly them? > > The limit

Re: [firebird-support] Very Strange: Query giving different results

2015-10-05 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mon, Oct 5, 2015 at 12:59 PM, 'Alexis (PROINTER)' ale...@prointersl.com [firebird-support] wrote: > Hi, we have found a very strange problem with our firebird database, a > record on a table of firebird databes is not always beeing returned: > > 1 - Using

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

2015-09-23 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mon, Sep 21, 2015 at 4:53 AM, Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] wrote: > > > > We have FirebirdSQL (2.1) running on a client computer (Windows). This > client has some problems with his power grid which causes the PC to > suddenly and

Re: [firebird-support] Deleting records and deadlocks

2015-12-02 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Wed, Dec 2, 2015 at 11:49 AM, Tim Ward t...@telensa.com [firebird-support] wrote: > > > Yes I do know it's not a real deadlock, I was using the word because I > knew it would be understood and because, I'm pretty sure?, I've seen it > in one of the relevant

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

2015-12-01 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Dec 1, 2015 at 7:42 AM, 'Moessinger, Semjon' s.moessin...@pi.ws [firebird-support] wrote: > > > > My main intend is to add some version information to a firebird database > file, since I will use firebird as embedded database and installers/update >

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

2015-12-04 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
Fabiano Kureck suggested sticking application version information in the checksum slot of the page header. Mark Rotteveel quite correctly responded. > > > That is very dangerous to do, the same bytes might be reused differently > in a newer ODS. Either use a normal Firebird table to store version

Re: [firebird-support] Deleting records and deadlocks

2015-12-02 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
> On Dec 2, 2015, at 6:35 AM, Tim Ward t...@telensa.com [firebird-support] > wrote: > > What about if two concurrent transactions are both trying to *delete* > the *same* record at once? - from the point of the view of the user's > objectives there's no

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

2015-12-29 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Dec 29, 2015 at 2:44 PM, Macma mac...@wp.pl [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Do I have to change any configuration or the matter is that if I can´t > enable disk cache, there is nothing I can do to improve the performance? > > Try to disable force write

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

2015-12-22 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Dec 22, 2015 at 2:17 PM, Caroline Beltran caroline.d.belt...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Since I began using Firebird, I have kept my transactions (type > concurrency) very short and then call COMMIT immediately afterward. This > has

Re: [firebird-support] Numeration without hole, Is right Before Insert Trigger?

2015-12-22 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Dec 22, 2015 at 9:40 AM, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > >I must assign a serial number, without hole, in a column of a fiscal > document. I must assign the number only when I know if the document is > complete >

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

2015-12-22 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Dec 22, 2015 at 2:17 PM, Caroline Beltran caroline.d.belt...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Since I began using Firebird, I have kept my transactions (type > concurrency) very short and then call COMMIT immediately afterward. This > has

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

2015-12-24 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Thu, Dec 24, 2015 at 1:03 PM, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > 24.12.2015 05:31, 'Leyne, Sean' wrote: > > > > With today's unlimited availability of disk space and silly-low cost per > GB for storage, would an argument

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

2015-12-23 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Wed, Dec 23, 2015 at 7:12 AM, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote: > > longest chain of versions here). > > If you will see a long chain of versions, it means that you are updating > the same record while some other writeable transaction

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

2015-12-23 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Wed, Dec 23, 2015 at 12:01 PM, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] < firebird-support@yahoogroups.com> wrote: > 23.12.2015 01:36, Ann Harrison wrote: > > > > > ...Your first update will create a back > > version that's just the difference between the old record state

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

2016-05-26 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Thu, May 26, 2016 at 8:30 AM, fabia...@itbizolutions.com.au [firebird-support] wrote: > > I wrote: > > > In V3.0, Firebird is multi-threaded at the client statement level. It > does not decompose queries and schedule the pieces on different processors. > >

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

2016-05-25 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Wed, May 25, 2016 at 2:53 PM, Ann Harrison wrote: > On Wed, May 25, 2016 at 1:11 PM, fabia...@itbizolutions.com.au > [firebird-support] wrote: > >> >> Now on the flip side, the performance sucks, it is worst than with FB >> 2.54,

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

2016-05-25 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Wed, May 25, 2016 at 1:11 PM, fabia...@itbizolutions.com.au [firebird-support] wrote: > > Now on the flip side, the performance sucks, it is worst than with FB > 2.54, and when looking at the task manager on windows it appears only one > processor it doing

Re: [firebird-support] Engine12 mistery

2016-06-15 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
The way I think of the Y-valve* is that the stem of the Y is the client - whether the normal fbclient or the Java client or other language specific clients. The connection request goes from the client to a provider. Right now, the providers are Remote (which may be built into the Y-valve) and

Re: [firebird-support] Forced writes on Linux?

2016-01-17 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Fri, Jan 15, 2016 at 5:15 AM, Tim Ward t...@telensa.com [firebird-support] wrote: > I know the folklore around forced writes > > - turning forced writes on is safer > Not exactly folklore. Firebird doesn't have a journal but instead depends on careful

Re: [firebird-support] What is more effective execute block or select?

2016-01-28 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Wed, Jan 27, 2016 at 5:01 PM, setysvar setys...@gmail.com [firebird-support] wrote: > >If the question is which is likely to perform better, then the answer > is the select. > ... > >In general, execute block should be used when you want to change what >

Re: [firebird-support] Page is of wrong type (expected 5, found 0)

2016-01-28 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Thu, Jan 28, 2016 at 4:12 PM, Martin Schwedhelm silo...@yahoo.com [firebird-support] wrote: > > > As far as I can tell (via gstat) forced write is enabled. > Also, regarding virtual machines, at least ESX(i) does not cache guest OS > writes >

Re: [firebird-support] What is more effective execute block or select?

2016-01-27 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Wed, Jan 27, 2016 at 7:48 AM, hamacker sirhamac...@gmail.com [firebird-support] wrote: > > > I would know whats methods is more effective, per exemple: > Example below shows two convoluted ways to return 'Y' or 'N' depending on whether an item with a

Re: [firebird-support] Restoring Backup

2016-02-24 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Wed, Feb 24, 2016 at 12:01 PM, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: Referring to the buffers requested for gbak: > > > Why 12? Why not? :) > There's a cost to managing a large buffer cache. Firebird will use the entire cache even if

[firebird-support] Gbak and indexes

2016-02-25 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
Someone on a different forum asked whether gbak restores wouldn't be faster if gbak backed up indexes so it didn't have to rebuild them. The writer wanted the clean-up and compaction that a gbak backup and restore provides, but not the time spent retrieving records, sorting, and rebuilding

  1   2   >