om
[firebird-support] wrote:
>
>
> 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 (typ
Since I began using Firebird, I have kept my transactions (type
concurrency) very short and then call COMMIT immediately afterward. This
has worked very well.
I recently had the need to perform more complex processing and what I did
was to keep everything short and modular. But I am now seeing t
I read that CONSISTENCY imposes table locking even for read operations
which means that I will continue using CONCURRENCY mode. Additionally, I
will not run both update processes at the same time to avoid the problem I
have been having.
On Sat, Dec 19, 2015 at 11:01 PM, Caroline Beltran <
carolin
Alan, I think you are right. I backed up then restored my database. Next
I installed SuperServer and everything was going very well. Here are my
stats:
Database header page information:
Flags 0
Checksum12345
Generation 22516
I can reproduce this 'stalling' behavior. At the moment, the application
is importing records without delay. CPU consumption remains very low.
To stall FB, I will now run a query that will scan several thousands of
records that have just been INSERTed and UPDATEd. Before I run this query,
here
Here are some more details. I used GBAK to backup and then restored the
database. Here are the gstat details:
Database header page information:
Flags 0
Checksum12345
Generation 30
Page size 4096
I have happily used Firebird 2.5 for a web application that run 24x7 for at
least 2 years. The sweep interval is set to the default 20,000 and it
works very well. There is at least 10 inserts per minute but not much more
than that. I would guess that there are at least 20 reads per second and
I'
Problem finally resolved by GBAK using the -g option to disable garbage
collection. After creating my backup, I restored using GBAK and my problem
was completely resolved.
My question remains though. Is it a bad idea to modify a database as
indicated above during heavy use? Thank you.
On Tue,
Please note that I attempted to backup and restore the database in hopes
that the problem would be resolved. This is what I tried:
gbak -b E:/mydata.fdb e:/mydata.fbk -user sysdba -password masterkey -v
It started off well and "wrote data for table" for 3 of the 4 tables.
When it started to wri
I have a FB database 4 tables. I decided to add some columns, drop one
index and create two indexes while the FB database handling a 12 hour long
batch job.
Between all tables, these batch jobs consist of an average of 1 to 20
INSERTS per second and 10 to 40 UPDATES per second. There are also
app
I hope that someone can advise how I can efficiently arbitrarily select
data from a table. I am provided with a list of IDs to display, for
example:
Employee ID Numbers: 1032, 624, and 2841.
This would be the output (in the same order as the list above):
Employee ID FName LName
...@gmail.com [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> Qual a versão do firebird você está usando ?
> Porque não usa utf-8 ?
>
> Em 25/08/2014 13:07, Caroline Beltran caroline.d.belt...@gmail.com
> [firebird-support] escreveu:
>
>
>
Alexandre, thank you for suggesting!
I am thinking of using the ISO8859_1 characterset and ES_ES_CI_AI
collation. Since I need support for English and Spanish, would this
collation be the best option for case/accent insensitive searching? Thanks
Again!
Mark, thank you for responding. I ended up downloading FlameRobin and it
does show computed indexes in the 'Index' tab as well as in the DDL, i.e.:
CREATE INDEX IDX_FNAME ON PEOPLE COMPUTED BY (lower(fname));
P.S. I found your response in my Google 'Sent' folder, it never made it
into my inbox,
I created the following computed index:
CREATE INDEX IDX_FNAME ON PEOPLE COMPUTED BY (lower(fname))
This works fine and instead of traversing the entire table when performing
a case insensitive query, an 'index read' for matching records is performed.
The question I have is that the database mana
15 matches
Mail list logo