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
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
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
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
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
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
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
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
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
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]
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
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
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,
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 ...
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
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
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
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.
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
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
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?
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
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;
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
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
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
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
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
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
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
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
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
--
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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
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
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
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.
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
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
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
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
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
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
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
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
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
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:
>
>
>
>
> 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
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
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
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,
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
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
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
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
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
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
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
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
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
>
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
> 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
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
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
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
>
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
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
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
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
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.
>
>
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,
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
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
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
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
>
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
>
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
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
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 - 100 of 162 matches
Mail list logo