Re: [firebird-support] gfix -v -full sufficient?

> On Jan 11, 2020, at 7:37 AM, Kjell Rilbe kjell.ri...@marknadsinformation.se > [firebird-support] wrote: > > Does gfix -v -full detect all kinds of database corruption? Or are there > corruptions that cannot be detected Gfix finds only errors in the physical structure of the database.

Re: [firebird-support] Sweep isn't moving OIT

On Tue, Nov 26, 2019 at 3:26 PM lucassch...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > I'm having a problem while running manually sweep, it's not increasing OIT > as expected. > As you mentioned in your bug report, the problem was a transaction stuck in limbo -

Re: [firebird-support] Table is fragmented?

On Fri, Nov 22, 2019 at 11:47 AM rudi.fe...@multidadosti.com.br [firebird-support] wrote: > > > Recently I ran a "Database statistics" with ibexpert on one of our dbs, > and there were a lot of tables marked in yellow, with the tooltip saying > "Table xxx Is fragmented" > > > > I couldn't quite

Re: [firebird-support] After downgrading database FB3 to FB2.5 - no permission for read/select access to DATABASE

> On Nov 19, 2019, at 7:27 AM, kok...@yahoo.com [firebird-support] > wrote: > I upgraded production database, let it working for some weeks, then i > realized that due some limitations (upadte of system tables) i am not able to > use it with 3.0 > What direct system table updates are you

Re: [firebird-support] What is the optimum pageSize?

> On Nov 17, 2019, at 6:22 AM, jerz...@o2.pl [firebird-support] > wrote: > > On Sat, 16 Nov 2019 10:29:44 +0100, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: > In Release Notes for these versions. Maximum size of record was not changed. > > >>> This is a

Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?

> On Nov 13, 2019, at 10:01 AM, Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support] wrote: > > 13.11.2019 15:51, blackfalconsoftw...@outlook.com [firebird-support] wrote: >> However, internally, the CHAR field definition is more efficient as the >> database does not >> have to

Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?

> On Nov 12, 2019, at 10:44 PM, Richard Damon rich...@damon-family.org > [firebird-support] wrote: > >> On 11/12/19 12:38 PM, cte...@gmail.com [firebird-support] wrote: >> >> >> What are the trade-offs of CHAR vs. VARCHAR? I know that VARCHAR >> consumes less space. Anything thing else

Re: [firebird-support] SQL

> On Aug 28, 2019, at 12:54 AM, Kjell Rilbe kjell.ri...@marknadsinformation..se > [firebird-support] wrote: > > Den 2019-08-05 kl. 13:20, skrev mohamed hamza medh...@hotmail.com > [firebird-support]: >> >> Hi All, >> >> I am new to sql, I am coming from Xbase system . >> I want to

Re: [firebird-support] index vs page size

> On Jun 20, 2019, at 11:10 AM, Nick Upson n...@telensa.com [firebird-support] > wrote: > > > > Hi > > I have a large 100Gb+ firebird 2.5 database and I'm trying to deal with some > performance issues. > > One indicator I have found is that several large tables have indexes with a >

Re: [firebird-support] FB 2.1 transaction question

On Mon, May 13, 2019 at 5:08 AM Rustam rusta...@ukr.net [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Important notice: modified rows in that 'dead' transaction remains locked > along this TA existence. So, your another connections will get 'lock > conflict' errors ('no

Re: [firebird-support] Can not create backup of Firebird database because of the errors

On Thu, Sep 20, 2018 at 5:30 AM Georgiy Kovalov g...@liconic.com [firebird-support] wrote: > > > At the time of backup firebird database (gbak -g -ig) I have the following > error: > > gbak:writing data for table ORDERS > gbak: ERROR:message length error (encountered 532, expected 528) >

Re: [firebird-support] Sequential auto incremental numbering

On Wed, Sep 5, 2018 at 10:07 AM, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > 2018. 09. 02. 17:03 keltezéssel, 'Christian Giesen' ch...@xt.co.za > [firebird-support] írta: > > > > > I have a need to generate unique sequential invoice/credit note numbers.. > > I fully understand the

Re: [firebird-support] Sequential auto incremental numbering

> On Sep 3, 2018, at 6:00 AM, 'River~~' river14ap...@gmail.com > [firebird-support] wrote: > > Two ideas that should work on any SQL database so long as you never delete > invoices Remember that a transaction can roll back, so delete is not your only challenge. > > I amNot a guru for

Re: [firebird-support] Query - Regarding a Firebird Source Control Application

In addtion to Mark Rotteveel’s description of the system tables, you might want to look at the code in isql which supports the -x command. It should include everything to create a complete DDL script from the system tables. Good luck, Ann

Re: [firebird-support] Firebird 3 - Auto Garbage collection with Sweep interval = 0

Hi Everyone, Adding just a bit more detail to the description of garbage collection in Firebird. For those who know little about Firebird, when a record is updated, Firebird does not replace the old version with the new. Instead, it creates a new version and chains the old version

Re: [firebird-support] Index process in Firebird 2.1.4

> On Oct 19, 2017, at 11:45 PM, gn7s...@gmail.com [firebird-support] > wrote: > > > > Hi! > I'm going to develop a commercial program with Firebird2.1, in Delphi7. > As noted, 2.1 is obsolete. > I want to know whether the following index is picked by the

Re: [firebird-support] Always use BIGINT?

On Sun, Jul 2, 2017 at 1:50 PM, Slavomir Skopalik skopa...@elektlabs.cz [firebird-support] wrote: > > > I test general impact of compression and I found that for FB 2.5 and FB3 > is critical to take another DB page from cache. > Sure. OK, you're considering

Re: [firebird-support] Always use BIGINT?

On Sat, Jul 1, 2017 at 6:23 AM, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > > > what do you mean with alignment? > It varies from machine to machine, but generally in order to add or compare two integers they must be aligned on a

Re: [firebird-support] Always use BIGINT?

On Fri, Jun 30, 2017 at 10:30 AM, Slavomir Skopalik skopa...@elektlabs.cz [firebird-support] wrote: > > advantage of SmallInt vs INT vs BIGINT is data density (keep record > shortest as possible). > > If you have one column, it is irrelevant, if you have ten

Re: [firebird-support] Always use BIGINT?

On Fri, Jun 30, 2017 at 5:37 AM, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > > In 2014 I was at the FB conference in Prague. If I remember correctly, Ann > Harrison told the audience that there are no advantages when using SMALLINT > or

Re: [firebird-support] Changing collation

On Tue, Jun 27, 2017 at 1:39 PM, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] < firebird-support@yahoogroups.com> wrote: > , > > Is it possible to change the collation of a varchar column in place > (without making a temporary column, copying data, dropping the original >

Re: [firebird-support] Foreign key different field type

On Mon, Jun 19, 2017 at 1:21 PM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: > , > > > > Can someone show me example when it is usefull to have different field > > type in [referenced and referencing keys of a foreign key relationship]? >

Re: AW: [firebird-support] RE: Firebird SuperClassic hangs

> On May 9, 2017, at 9:10 AM, Freddy Ertl f.e...@speexx.com [firebird-support] > wrote > > that's the question, that I have: How to find out what causes the deadlock > scans. I have thousands of transactions per minutes, doing all possible kind > of things.

Re: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

> Apr 25, 2017, at 12:21 PM, Lester Caine les...@lsces.co.uk > [firebird-support] wrote: > > On 25/04/17 16:50, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: >> The SQL standard is quite clear at what needs to happen: adding a new >> column

Re: [firebird-support] Read Only Transaction

ebird-support/conversations/topics/111668 > > Aldo Caruso > >> El 07/03/17 a las 15:52, Ann Harrison aharri...@ibphoenix.com >> [firebird-support] escribió: >> > On Mar 7, 2017, at 10:30 AM, Aldo Caruso >> > aldo.car...@arge

Re: [firebird-support] Read Only Transaction

> On Mar 7, 2017, at 10:30 AM, Aldo Caruso aldo.car...@argencasas.com wrote: > > Supposing a connection only needs to read from a database. Which are the > benefits of starting a read only transaction ? > I doubt that there is any difference in performance that you could measure.

Re: [firebird-support] Transactions isolation levels and collisions

> On Mar 1, 2017, at 9:53 AM, Aldo Caruso wrote: > > > > Ann, > > Thanks for your detailed answer. > > But this leads me to the following question: If snapshot transactions > have their own copy of the Transaction Inventory Pages ( TIP ), taken when > the transaction started,

Re: [firebird-support] Transactions isolation levels and collisions

> On Feb 28, 2017, at 3:07 PM, Aldo Caruso wrote: > > I'm trying to understand interactions between transactions with > different isolation levels. The problem is not mixed isolation levels. You would get the same behavior if all transactions were Snapshot The scenario (described below in

Re: [firebird-support] Is there an easy way for input rows from a script file?

> On Feb 15, 2017, at 6:31 PM, setysvar setys...@gmail.com [firebird-support] > wrote: > > > > Den 15.02.2017 17:07, skrev 'Walter R. Ojeda Valiente' > sistemas2000profesio...@gmail.com [firebird-support]: >> Hello everybody >> >> If I connect to a

Re: [firebird-support] How to change cpu utilization in Firebird engine?

On Thu, Jan 5, 2017 at 9:54 PM, trsk...@yahoo.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > As you know, on a single connection, Firebird's cpu utilization calculate > by 100% / no of cores. > That's not an arbitrary limit. Firebird is not capable of running a single

Re: [firebird-support] info

On Wed, Jan 4, 2017 at 9:41 AM, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] < firebird-support@yahoogroups.com> wrote: We want to create table- and fieldnames (Firebird 3) in camelcase. If we > want to write a select statement we have to use quotes around a tablename.

Re: [firebird-support] Explicit Transaction + Suspend

> On Nov 24, 2016, at 2:59 PM, fabia...@itbizolutions.com.au [firebird-support] > wrote: > > Just wondering can my app start a transaction with Begin Transaction and > then call a stored procedure that contains the SUSPEND sentence at the end > while the

Re: [firebird-support] Re: Best way to delete millions of rows

On Nov 22, 2016, at 6:56 AM, kragh.tho...@yahoo.com [firebird-support] wrote: > > Pagesize is 16384 and pagebuffers is 256. Servermode is superclassic. > If I drop the primary key/index everything works as expected. > Interesting. GUIDs produce really fat

Re: [firebird-support] Digest Number 9396

Do you see the same behavior if the guid field is not indexed? > On Nov 22, 2016, at 3:09 AM, tiberiu_horv...@yahoo.com [firebird-support] > wrote: > > > > All right, thank you all for your time ! > > I have code that uses temporary tables in at least 30

Re: [firebird-support] Digest Number 9396

> On Nov 19, 2016, at 11:20 PM, Dalton Calford dcalf...@distributel.ca > [firebird-support] wrote: > > > > Every time you do not define a domain when creating a column in a table, > firebird creates a new domain ... So, you perform a backup and it

Re: [firebird-support] New auto-increment column, existing data

> On Nov 15, 2016, at 3:58 PM, 'Some One' anotherpersonsomewh...@mail.com > [firebird-support] wrote: > > I am trying to add new auto-increment primary keys for existing table. > . > select rdb$db_key > from mytable > into :dbkey > . As several

Re: [firebird-support] Reviving an old firebird database (file conversion/programming hints)

> On Oct 13, 2016, at 4:37 AM, Urs Liska fireb...@openlilylib.org > [firebird-support] wrote: > >> Am 13.10.2016 um 10:18 schrieb Elmar Haneke el...@haneke.de >> [firebird-support]: >> >> > 1) >> > I assume on LInux (Debian based Mint version and an Ubuntu

Re: [firebird-support] Optimizer request

I wrote > > select o.* > > from orders o > > inner join partners p > > > * where p.partid = o.opartid > and p.country = 'Spain*'; > > Helen suggests the more correct: > select o.* > from orders o > inner join partners p > * on p.partid =

Re: [firebird-support] Optimizer request

On Fri, Sep 9, 2016 at 8:30 AM, 'Djordje Radovanovic' softsis...@sbb.rs [firebird-support] wrote: > > I tried query with subquery in where clause and found big issue for this > type of subquery. > > select * from orders where orders.partid in (select

Re: [firebird-support] gbak error

Does the error happen on file creation or after some data has been written? > On Aug 30, 2016, at 4:36 PM, Nick Upson n...@telensa.com [firebird-support] > wrote: > > > > no, not a file name collision and plenty of disk space > > this just started

Re: [firebird-support] Database/Backup consistency check

On Mon, Jul 4, 2016 at 2:52 PM, 'Steffen Heil (Mailinglisten)' li...@steffen-heil.de [firebird-support] wrote: Late, but I was away... > > I have a database on a hard drive which is failing. The hard drive already > has some bad sectors and we are about to

Re: [firebird-support] Database design. Simple question!

On Mon, Jul 25, 2016 at 5:51 PM, shg_siste...@yahoo.com.ar [firebird-support] wrote: > > Hello! I have a FB 2.5 database with a tabla "invoices". I need to add a > field in that table which will be null most of the times. Lefts say, that > 90% of the records

Re: [firebird-support] Engine12 mistery

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] Re: Is Firebird 3 ready for Production?

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?

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?

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: Re: [firebird-support] update all records

On Fri, May 6, 2016 at 2:05 AM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > > > He wrote: > > all records inserted by tr2 are not updated if tr1 is e.g. snapshot > or during tr1 update there are inserts. > > I wrote: > > Actually, that's

Re: [firebird-support] update all records

Sergio asked why this statement update stock set actualizar = 0 where 1=1 doesn't update all records in the stock table. First, the clause "where 1=1" is unnecessary. The update statement does not requires a where clause and in the absence of a where clause, it affects all records

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

On Thu, Apr 28, 2016 at 11:39 AM, Ann Harrison wrote: A lot of stuff including: > In ancient history, even in read-committed mode, Firebird blocked > transactions from updating records if the most recent version was created > by a concurrent transaction. At the time,

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

On Thu, Apr 28, 2016 at 2:16 PM, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > ... > > Try to utilize WITH LOCK because I need many unique number generators in > a table field. Like a generator/sequence but under transaction control. > Okay...

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

On Thu, Apr 28, 2016 at 9:19 AM, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > 2016. 04. 28. 14:55 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support] írta: > > 28.04.2016 13:41, Gabor Boros gaborbo...@yahoo.com

Re: [firebird-support] Re: Connecting to Firebird database from two or more pc with same username

On Mon, Apr 18, 2016 at 10:03 AM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: > > On Thu, 14 Apr 2016 12:28:41 +0200 (CEST), 'Thomas Steinmaurer' > > t...@iblogmanager.com [firebird-support] > > >

Re: [firebird-support] Connecting to Firebird database from two or more pc with same username

On Thu, Apr 14, 2016 at 3:17 AM, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > >If a user try to connect from two or more PC with same username, > Firebird accepts the connection but is safe without problems or is best > to avoid like

Re: [firebird-support] VIEW optimization

On Thu, Apr 7, 2016 at 3:41 PM, Ann Harrison wrote: > On Thu, Apr 7, 2016 at 2:27 PM, Gabor Boros gaborbo...@yahoo.com > [firebird-support] wrote: > >> 2016. 04. 07. 19:31 keltezéssel, 'Mark Rotteveel' m...@lawinegevaar.nl >>

Re: [firebird-support] VIEW optimization

On Thu, Apr 7, 2016 at 2:27 PM, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > 2016. 04. 07. 19:31 keltezéssel, 'Mark Rotteveel' m...@lawinegevaar.nl > [firebird-support] írta: > > > > > > For a join (inner join), the rows must exist in both

Re: [firebird-support] help to repair a corrupted database

On Thu, Apr 7, 2016 at 11:28 AM, korkl...@yahoo.it [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > hi, i'm trying to repair a corrupted db for firebird 2.5.2, the database > file is of about 30 gb. > > i have disconnected all the user, i did a copy of the file and then i >

Re: [firebird-support] db corruption

On Mon, Apr 4, 2016 at 2:41 AM, 'Andrew Zenz' and...@aimsoftware.com.au [firebird-support] wrote: ... > > > I am using WI-V2.5.3.26780 Firebird 2.5 ODS 11.2 > > ... > > For both databases while running gbak: > > gbak -user sysdba -password masterkey -b -ig -l

Re: [firebird-support] Do I need to "recompile" dependant stored procedure?

On Thu, Mar 24, 2016 at 5:13 PM, 'Wodzu' brucedickin...@wp.pl [firebird-support] wrote: > > > I would have to dig in for example o that behavior, maybe it only seemed > to me that this has occurred. > Don't bother digging, but if it happens again, take notes.

Re: [firebird-support] Do I need to "recompile" dependant stored procedure?

On Thu, Mar 24, 2016 at 7:24 AM, brucedickin...@wp.pl [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > I have two procedures: > > 1. PROC_A > 2. PROC_B - which is using internally PROC_A. > > Now, I've made some changes in PROC_A, do I need to recompile PROC_B as > well? >

Re: [firebird-support] violation of PRIMARY or UNIQUE KEY constraint

On Tue, Mar 15, 2016 at 8:04 AM, Tim Ward t...@telensa.com [firebird-support] wrote: > > > Now, I seem to recall seeing somewhere that actually a primary key (and > any other unique index?) is independent of transactions, so the following: > > (1) Transaction A

Re: [firebird-support] Composite index - issue or not existing feature?

On Mon, Mar 14, 2016 at 5:30 PM, setysvar setys...@gmail.com [firebird-support] wrote: > > > Hi Karol! At the risk of this being confusing or even incorrect (I trust > Dmitry or Ann will correct if it is incorrect). > > >SELECT * FROM dbo.XXX X WHERE X.A BETWEEN

Re: [firebird-support] Re: Composite index - issue or not existing feature?

On Mon, Mar 14, 2016 at 3:41 AM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > W dniu 2016-03-14 08:36:40 użytkownik Dmitry Yemanov > dim...@users.sourceforge.net [firebird-support] < > firebird-support@yahoogroups.com> napisał: > > > >

Re: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 ss

On Fri, Mar 4, 2016 at 3:22 AM, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > > > > If I must go back tot he 2.5 version of firebird, how can I gbak the new > backup-file to the old version? > If you haven't used V3 features in data definitions

Re: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 ss

On Thu, Mar 3, 2016 at 11:16 AM, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > > > > I’ve postet my problems with the new odbc driver and firebird 2.5 cs, the > slow queries and all other issus. Now I have installed the firebird 3.0 > rc2, the

Re: [firebird-support] Unable to retreive database

On Tue, Mar 1, 2016 at 6:02 AM, jojecodewo...@yahoo.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > My firebird database got corrupted and I am trying to retrieve it. For > retrieving database I tried using *gfix.exe* and its commands and got my > tables back but

[firebird-support] Gbak and indexes

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

Re: [firebird-support] Restoring Backup

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

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

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)

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?

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] Page is of wrong type (expected 5, found 0)

On Sat, Jan 23, 2016 at 9:41 AM, Martin Schwedhelm silo...@yahoo.com [firebird-support] wrote: > > > I have multiple (8) databases where no connection is possible and gfix > prints the above message. > > Firebird version: 2.5.2 > Operating system: Windows 2003 -

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

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] Bad performance of Firebird in Windows Server 2012

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] Re: UPDATE to same record causing heavy disk I/O

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

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

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] UPDATE to same record causing heavy disk I/O

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?

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

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] Is it save to append some data at end of the binary firebird database file?

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

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] Deleting records and deadlocks

> 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] Is it save to append some data at end of the binary firebird database file?

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] SQL Optimation best way

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] Re: Firebird Indexing problem

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: AW: [firebird-support] Optimize query for date ranges

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: [firebird-support] Optimize query for date ranges

> 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: [firebird-support] Very Strange: Query giving different results

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] AW: Performance comparision for primary keys - int vs. varchar

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] Error on Gfix

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] Re: SELECT for get the number of contexts

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] Securing database against corruption on systems that suddenly get turned off

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] About firebird performance

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] Firebird backup on virtual machine

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] Re: Differences when adding a Primary Key

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?

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] Composite Primary Key in JOIN - performance

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

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

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] Plan evaluation in stored procedures

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

  1   2   >