Hello,
Lets put there IDPL.
Regards,
Alexey Kovyazin
Денис Симонов via Firebird-docs :
> I don't mind. This article was originally created for general access,
> although I did not think about the license, but if necessary, I can add so
> that there is no contradiction
>
&g
Hello Mark,
May be we can map page of multi page document to the link of single page
document with anchor?
Regards,
Alexey Kovyazin
пн, 5 июл. 2021 г., 22:09 Mark Rotteveel :
> On 05-07-2021 20:04, Alexey Kovyazin wrote:
> > I just found that we have a hidden nest of old version
it will be seamlessly unified,
without many 404 on site.
Is it Ok? or could be another solution?
Regards,
Alexey Kovyazin
___
Firebird-docs mailing list
Firebird-docs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-docs
Hello,
I think, the good idea will be to include link to it to the launch
message for release of 4.0.
Regards,
Alexey
On 24.05.2021 19:18, Mark Rotteveel wrote:
I 'soft-launched' the language reference and put it online on
https://firebirdsql.org/en/firebird-rdbms/ and
Hello,
I took a quick look and did not see any noticeable problem.
Regards,
Alexey
вт, 23 февр. 2021 г., 19:27 Mark Rotteveel :
> I'm going to publish the links tomorrow.
>
> Mark
>
> On 20-02-2021 17:02, Mark Rotteveel wrote:
> > I have finished up the first version of the Firebird 3.0
Hello Mark,
Great work!
Thank you vey much!
I will read it, of course.
Regards,
Alexey
On 20.02.2021 19:02, Mark Rotteveel wrote:
I have finished up the first version of the Firebird 3.0 Language
Reference, I used the 2.5 version as starting point, and added new
things based on the release
Hello Martin,
I spoke with Vlad about section devoted to garbage, and we agreed it is
difficult.
I plan to rewrite it with pictures explaining records versions, garbage and
sweep, but it really needs courage :)
I suggest to let ost-oit phrases as is.
Regards,
Alexey Kovyazin
IBSurgeon
пт
Mark,
And if the Firebird 2.5 translation is any indication, translating it
will require a ton of effort afterwards to make it presentable. I'd
rather spent time and effort to write it myself (maybe with some
inspiration and copy/google-translate/paste/edit from the Russian
version).
I
Mark,
On 30.07.2020 16:37, Mark Rotteveel wrote:
On 2020-07-30 13:20, Alexey Kovyazin (ak) wrote:
Hello,
We did survey in Telegram channel, and idea was to skip 3.0 and do the
translation of LR4.0...
What Telegram channel?
https://t.me/firebirdsql
Not very representative, of course
Hello,
We did survey in Telegram channel, and idea was to skip 3.0 and do the
translation of LR4.0...
Regards,
Alexey Kovyazin
IBSurgeon
чт, 30 июл. 2020 г., 12:55 Mark Rotteveel :
> On 2020-07-30 09:44, Köditz wrote:
> > Hello everybody,
> >
> > I was asked whethe
Branch: refs/heads/master
Home: https://github.com/FirebirdSQL/firebird-documentation
Commit: 521ee76d782ca3ee9581691e2e217c13bd302cc0
https://github.com/FirebirdSQL/firebird-documentation/commit/521ee76d782ca3ee9581691e2e217c13bd302cc0
Author: Alexey Kovyazin
Date: 2020-07
Mark, Martin,
thanks, will try.
Regards,
Alexey
On 08.07.2020 16:15, Mark Rotteveel wrote:
On 08-07-2020 14:33, Alexey Kovyazin wrote:
I would like to amend documentation of gfix and nbackup to add some
recovery commands, 1-2 examples, extend description of process, etc.
What is the general
Hello,
I support the idea of the single Page list/index for all docs.
I suggest that we should create such page, and then ask people about their
opinion (it will also increase awareness of documentation).
Regards,
Alexey Kovyazin
ср, 1 июл. 2020 г., 16:31 Paul Vinkenoog :
> Mark Rottev
Hello Mark,
Thank you very much, excellent work!
Regards,
Alexey
On 27.06.2020 11:14, Mark Rotteveel wrote:
New links:
https://www.firebirdsql.org/file/documentation/html/en/refdocs/fbdevgd30/firebird-30-developers-guide.html
o you plan to convert also Developers Guide?
Regards,
Alexey Kovyazin
пн, 15 июн. 2020 г., 21:13 Mark Rotteveel :
> I was planning on converting the fbutil-* documentation next, however I
> was wondering how to approach this. Historically, we have released those
> as individual d
Hello,
Looks good! Thank you for your efforts, Mark!
What is the next - Firebird Developers Guide?
Or Quick Start Guide? Or something else?
Regards,
Alexey
On 06.06.2020 11:37, Mark Rotteveel wrote:
I have updated the documentation section on the site to point to the
new version.
Mark
Hello Mark,
PDF link is the same as HTML.
Regards,
Alexey
On 01.06.2020 18:52, Mark Rotteveel wrote:
I have migrated the Firebird 2.5 Language Reference, and it is
available for preview on:
HTML:
Hello Mark,
Like that Page but with high level table of contents for each document.
Regards,
Alexey Kovyazin
ср, 27 мая 2020 г., 14:25 Mark Rotteveel :
> On 2020-05-27 09:43, Alexey Kovyazin (ak) wrote:
> > Hello All,
> >
> > As you know, Firebird documentation contai
outline. Not like a 100% organized documentation
set, of co3, but better than current distributed structure.
What do you think?
Regards,
Alexey Kovyazin
___
Firebird-docs mailing list
Firebird-docs@lists.sourceforge.net
https://lists.sourceforge.net
Hello,
I think we don't need chuncked html.
Regards,
Alexey
On 08.03.2020 16:13, Mark Rotteveel wrote:
As I'm looking at the asciidoc conversion, our current choice of
having a (single) PDF and a chunked HTML output on the website is a
bit of a pain point.
Asciidoctor does not support
-
To unsubscribe e-mail: user-unsubscr...@spark.apache.org
Hello,
before you try FirstAID, download IBPump and try to pump all data to the
new database with the same structure.
Regards,
Alexey Kovyazin
IBSurgeon
On 27.12.2019 22:49, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
Hello.
FB 2.5.7
Windows 10 64 bits
Page size 4096
I am
Hello,
For predictable load reads/fetches is very useful metric, but in case of
spikes like Thomas has - 96 connections to 1300, it will be far less useful.
Regards,
Alexey
On 13.11.2019 14:50, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 13.11.2019 12:41, Alexey Kovya
Hello,
Yes, better use default - pagecache in terms of Linux is different from
Page Buffers/Page cache of Firebird.
Regards,
Alexey
On 13.11.2019 15:10, kragh.tho...@yahoo.com [firebird-support] wrote:
Hey Alexey
Thanks for the answer, I only have one question left, do I need to
adjust
Hello Thomas,
Ok, good to know that you are prepared for the migration! FB3 with
proper migration and config certainly will increase the overall performance.
In my presentation regarding Linux I spoke about specific case which is
under everyday control, and in our long way, we also started
4 have different
optimization, so some queries can start to work slower, and thorough
testing is required.
Regards,
Alexey Kovyazin
IBSurgeon
On 13.11.2019 11:56, kragh.tho...@yahoo.com [firebird-support] wrote:
Hey Alexey
Thanks for the advise, I changed TempCacheLimit to 21, last
Hello Thomas,
Seems like your system generates a lot of sort files - the problem can
be that TempCacheLimit in Firebird 2.5 cannot be more than 2Gb -1.
When you set it to something between 2 and 4Gb, it means 0.
So, set something like
TempCacheLimit=21
Consider to tune other
.
Regards,
Alexey Kovyazin
IBSurgeon
пн, 21 окт. 2019 г., 19:24 Stefan Heymann li...@stefanheymann.de
[firebird-support] :
>
>
>
> > Official or not, we need a simple, up to date, Firebird only, native
> > GUI.
>
> I don't get the point. There are GUI tools readily ava
Ocean, Hetzner and even
Google Cloud.
Regards,
Alexey Kovyazin
IBSurgeon
ср, 9 окт. 2019 г., 10:49 'Louis van Alphen' lo...@nucleo.co.za
[firebird-support] :
>
>
> I think it is unfair to say Azure sucks. I have had huge performance
> issues with FB on a normal server with server gr
Hello,
In short words, Azure sucks, its so called Premium SSD is worse than the
cheapest consumer grade ssd.
Try Google Cloud or Amazon, or Hetzner.
Regards,
Alexey Kovyazin
IBSurgeon
пн, 7 окт. 2019 г., 0:20 Rune Horneland rune.hornel...@kravia.net
[firebird-support] :
>
>
>
Martin,
Vlad head read my mind and answered :)
Try remote restore through service manager, it is much faster.
Regards,
Alexey Kovyazin
вт, 17 сент. 2019 г., 9:59 hv...@users.sourceforge.net [firebird-support] <
firebird-support@yahoogroups.com>:
>
>
> ---In firebird-support@
other choice.
I personally experienced slowness on one of my own desktops, and perfect
performance on the another one. Better just stay out from this lottery.
Try to make experiments with Windows Server, it will make more sense.
Regards,
Alexey Kovyazin
IBSurgeon
Anto
Hello,
Download RAMMap from Sysinternals (Micorosft), and see if database file
is in list of cached files.
Regards,
Alexey Kovyazin
IBSurgeon
On 22.06.2019 11:42, trsk...@yahoo.com [firebird-support] wrote:
Hi guys,
I have FB 3.04 SS in windows 10.
I have a database with these setting
rather shocked by that.
Why? Any database can be opened if you have access to the database file
- there are plenty of recovery tools for MSSQL, PostrgeSQL, etc, to dump
the contents of the database.
Regards,
Alexey Kovyazin
IBSurgeon
On 20.05.2019 13:32, sbai...@mutualconsultants.ltd.uk
hird-party plugins available or you can build
your own.
Regards,
Alexey Kovyazin
IBSurgeon
Steve Bailey
provide details about it.
Regards,
Alexey Kovyazin
IBSurgeon
On 09.01.2019 10:57, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
Hi,
i have read on http://firebirdsql.org/
article "23 More Ways To Speed Up Firebird".
Can you explain me point "12. Don't forget
.
Best regards
Dalton
On Wed, 7 Nov 2018 at 14:32, Alexey Kovyazin a...@ib-aid.com
<mailto:a...@ib-aid.com> [firebird-support]
<mailto:firebird-support@yahoogroups.com>> wrote:
Hello Dalton,
>Where do you see the list of features that are destined to be in 5?
membership in Firebird Foundation (which can be
bought separately by USD$300/year).
Regards,
Alexey Kovyazin
IBSurgeon
nd 3.0, and will be in
community Firebird 4.0
Master-Master is the next step for 5.0.
(6) High Available Clustering
agree, it will be based on top of the replication.
Regards,
Alexey
On Wed, 7 Nov 2018 at 12:19, Alexey Kovyazin a...@ib-aid.com
<mailto:a...@ib-aid.com> [firebird-support]
<mailto:f
Thank you!
In my opinion, Firebird will close the gap with PG in main features in 2
years, with FB5.0 version.
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
On 07.11.2018 19:58, 'Martijn Tonies (Upscene Productions)'
m.ton...@upscene.com [firebird-support] wrote:
> Hello Alexey,
>
&
Martijn,
What about compilation of stored procedures - is it true that it is
possible to create SP with errors, and they appear only when it will be
invoked?
Also, about checking the parameters - is it true that you can create
stored procedure which invokes other stored procedure with wrong
Hello,
As you probably know, Firebird a) uses complex mechanism to write
consistent data to the database file even in the multi-users
environment, b) intensively uses own cache, which must be synced with
database file.
SafeKit says it is byte-level replication.
So, essentially it is the same
Hello,
Since you have enough RAM, you can increase TempCacheLimit in
firebird.conf, for example, set 20Gb.
Fb_sort_xxx files will be created only if sorting will require more than
TempCacheLimit.
Regards,
Alexey Kovyazin
IBSurgeon
On 07.08.2018 10:35, bieten2...@yahoo.de [firebird-support
Hello,
Don't install from repo, better download installation package from
firebirdsql.org and install it instead.
Regards,
Alexey Kovyazin
IBSurgeon
On 27.07.2018 19:41,
mailinglist.int.it.firebird.supp...@principledgroup.com
[firebird-support] wrote:
Problem: Firebird 3.0
Hi Josef,
Firebird 3 shows plan Natural for all procedures.
2.5 also sometimes shows Natural, sometimes - mix of plans of queries
inside the procedure.
So, you cannot apply this plan to the statement.
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
On 22.06.2018 9:47, josef.gschwendt
, and sort on record_idx_reads.
If there are many records - Remove prepared
The queries with the highest numbers of record_idx_reads are those which
responsible for high CPU usage.
Regards,
Alexey Kovyazin
IBSurgeon
On 10.05.2018 16:12, Rudi Feijó rudi.fe...@multidadosti.com.br
[firebird-support] wrote:
I am totally agree with Mark.
Ratio of page reads/page fetches for all queries has a little sense.
For example, the single badly designed query with many page fetches can
"improve" this parameter a lot, without any real improvement in the
performance, of course.
Regards,
Alexe
Hello,
We recommend perform at least everyday sweep - with disconnect of long
running active writeable transactions before it.
Can you please clarify what do you mean by
> measuring the effectiveness of the page cache
?
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
On 04.05.2018 5
the encrypted backup is also encrypted,
otherwise it will be a security hole.
If you're implementing your own plugin, you can implement whatever you
need.
Regards,
Alexey Kovyazin
IBSurgeon
вт, 1 мая 2018 г., 3:24 Hamish Moffatt ham...@risingsoftware.com
[firebird-support] <firebird-supp
Hello Nils,
No other issues.
Regards,
Alexey Kovyazin
IBSurgeon
On 05.12.2017 14:52, Nils Boedeker nilsboede...@t-online.de
[firebird-support] wrote:
Hi
I want to use windows server 2016 as server for
firebird 2.5.7 (Classic Server)
are there any known issus with using firebird
/45-ways-to-speed-up-firebird-database/
https://www.slideshare.net/ibsurgeon/resolving-firebird-performance-problems
Regards,
Alexey Kovyazin
IBSurgeon
On 11.10.2017 12:35, 'Gian Uys' gian...@gmail.com [firebird-support] wrote:
Hi
We have an application with roughly 20 000 lines of code and have
Hi,
Look at System Audit feature.
Regards,
Alexey Kovyazin
IBSurgeon HQbird
www.ib-aid.com
On 09.10.2017 2:49, Hamish Moffatt ham...@risingsoftware.com
[firebird-support] wrote:
Is there an official way to detect if a database has changed?
I have some expensive reports and backups to run
On 09.10.2017 8:27, Jiří Činčura wrote:
Convert to Git and put it under FirebirdSQL organization on GitHub for
extra visibility. It might even help with contributions.
+1
Regards,
Alexey
--
Check out the vibrant tech
is to decrease record sets which should be
sorted.
For example, many developers use ORDER BY for internal processing in
stored procedures - usually it can be simply removed.
Regards,
Alexey Kovyazin
IBSurgeon
On 03.09.2017 20:47, kragh.tho...@yahoo.com [firebird-support] wrote:
Hey
Thanks
there is the single
server process.
Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com
On 02.09.2017 20:46, Thomas Steinmaurer t...@iblogmanager.com
[firebird-support] wrote:
Hi Thomas,
> From what i can read on the internet TempCacheLimit, is per server
> process, and not per atta
Hi,
It can be several reasons.
Try ##7, 20, 21, 23 from this list
https://www.ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/
Regards,
Alexey
On 15.08.2017 19:50, anderphil...@hotmail.com [firebird-support] wrote:
Hi, I have a strange problem which is probably quite obvious
Hi,
In short - 5 years of development.
These versions are different major releases, no backward compatibility.
Regards,
Alexey Kovyazin
IBSurgeon HQbird www.ib-aid.com
On 23.06.2017 12:15, 'Vonica Tng (Madsoft)' vonica@madsoft.com.sg
[firebird-support] wrote:
Hi,
Can anyone advise
Hi,
For 6 months of fees of powerful Azure VM you can buy the whole server.
I don't know if they charge for IO rounds, like Amazon - there IO adds a
huge $$ to the bill.
If you want your database hosted and be reliable and safe - rent 2
servers with SSD in Hetzner and install asynchronous
.
It is not possible to 100% protect from all types of corruptions, but it
possible to eliminate their consequences - implement a failover solution
based on Firebird replication (VM failover does not work).
Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com
1. I got following error reported
lta is very small.
In 2.5 nbackup of any level scans the whole database file.
Consider to migrate to 3.0 to take advantage of nbackup improvements
Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com
Hi Alexey,
In my case the database is seldom larger 500 MB and the backup takes
30 maximum seco
be retrieved from the database.
Regards,
Alexey Kovyazin
Hello,
Is there a way to ask a database if someone is performing a nbackup?
If it's in "the physical backup mode".
I'm always paranoid if there is a power failure during a backup and it
gets stuck in that mode and I would like it to re
Hi Ed,
There is IBAanalyst tool (now it is a part of HQbird), it shows sizes of
tables and associated indices, see column Size
http://ib-aid.com/images/iba_tables.gif
Regards,
Alexey Kovyazin
IBSurgeon HQbird
www.ib-aid.com
I have a number of growing databases on my server and would like
in lock table, or related with
excessive number of record versions (Max Versions in database
statistics), or with other reasons. I would recommend to perform
detailed investigation of the problem.
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com<http://www.ib-aid.com>
Hi,
we’re running Fi
Versions in database
statistics), or with other reasons. I would recommend to perform
detailed investigation of the problem.
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
Hi,
we’re running Firebird 2.5.7 SuperClassic on Windows Server 2012R2 as
part of a web application. Database
Hi Jiří,
Here they are in Russian
http://www.ibase.ru/files/articles/firebird_examples/how_to_create_aplication_firebird_delphi_example_rus.pdf
http://www.ibase.ru/files/articles/firebird_examples/how_to_create_application_firebird_sql_entity_framework_net_example_rus.pdf
Hi,
Look at the English version of the page
https://ib-aid.com/en/optimized-firebird-configuration/
Regards,
Alexey Kovyazin
IBSurgeon
Those are for 2.5 aren't them?
The only ones I found there are at
https://ib-aid.com/br/optimized-firebird-configuration/
I was guessing there are different
Hi,
Migrate to Firebird 3 - it has protocol improvements for high latency
networks.
With 2.5 you will never reach such good results as with FB3.
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
Hi.
I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPS
From tests,remote access
with low and moderate writes.
Regards,
Alexey Kovyazin
> Hi guys,
>
> I'm just responding one more time because I want to mark this as solved
> for me:
>
> Several things did the trick:
>
>* Upgrade Firebird to 2.5.7 (apparently there was a subquery bug in
>
that - start to check performance of your queries - non-optimal
queries lead to 90% of performance problems.
Regards,
Alexey Kovyazin
IBSurgeon
Hi everyone,
I originally tried to post to this like I would to a normal mailing list. I've
never seen an open source project that required me to have
Hi,
Recompile all stored procedures and triggers in Firebird 3.
Regards,
Alexey Kovyazin
IBSurgeon HQbird www.ib-aid.com/hqbird
Dear Sir/Madam,
I am trying to migrate my database from 2.5 to 3.0 now.
It was tested before and worked successfully
with great help from firebird community
Hi,
There is no sense to tune or upgrade CPU or other hardware without prior
analysis of slowness reasons.
In 95% the reason is in non-optimal queries plans or absense of indices.
--
Regards,
Alexey Kovyazin
IBSurgeon суббота, 07 января 2017г., 11:26 +03:00 от trsk...@yahoo.com
[firebird
Hi,
Please take a look
http://www.slideshare.net/ibsurgeon/failsafe-cluster-for-firebirdsql-and-something-more
Regards,
Alexey Kovyazin
IBSurgeon
Hi Everyone,
First, I apologise if this isn't the correct group - please forgive me.
I'm trying to find some contemporary (ie from in the last 24
Hi,
We did it several times for our clients.
Not very difficult, but requires to detect and rewrite wrong SQL queries.
Regards,
Alexey Kovyazin
IBSurgeon
Hi ,
It is my First question in this group.
I would like to know if someone has accomplished a migration from
Interbase 7.5 to Firebird
Hi Andre!
Thank you! Have a good vacation!
We will definetely do more conferences and meet there!
--
Regards,
Alexey Kovyazin
IBSurgeon пятница, 07 октября 2016г., 09:53 +02:00 от André Knappstein
andre.knappst...@beta-eigenheim.de :
>Hello Alexey,
>hello Dmitry,
>
>I hope the
Hi Ian,
It seems that you have multi-volume database, is it correct?
Regards,
Alexey Kovyazin
IBSurgeon
Hi FB Support!
We have been running FB since IB4.2 days and have only previously had
any database corruption when we've had hardware issues...until
recently, when I've seen this error
, there are other options to deal with such performance problem - please
contact me directly.
--
Regards,
Alexey Kovyazin
IBSurgeon вторник, 30 августа 2016г., 19:18 +03:00 от Antti Nivala
antti.niv...@m-files.com [firebird-support] firebird-support@yahoogroups.com :
>
>Hi,
>
>We've
Hi,
There is broken link
(http://developer.postgresql.org/cvsweb.cgi/#dirlist) at the page
http://firebirdsql.com/manual/docwritehowto-copyrights.html, using this
text "http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/;
I assume that associated document should be
Hi Fabian,
Firebird caches only actually used pages.
The small cache means that your application touches the small part of the
database.
--
Regards,
Alexey Kovyazin
IBSurgeon
PS It is difficult and wrong to give you any direct advice without all details
in hands - it can lead to worse
/download/docs/hqbird2016r1userguide.pdf
Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com
Hi,
I'm looking for easy to use solution that can help me trace statements
executed inside every transaction and keep them until transaction is
active.
Once it is closed(commit or rollback) statements
ally after the
conference. By submitting materials to the Firebird conference, you
grant the Firebird Foundation permission to use, reproduce, audio/video
record and distribute your materials.
Regards,
Alexey Kovyazin
IBSurgeon
Hi Fabian,
Also I recommend you to try our optimized configuration file for FB3:
http://ib-aid.com/en/optimized-firebird-configuration/
Regards,
Alexey
Hi Alexey
Thank you for the comments. So far everything has gone ok, I fixed all
the fields with ASCII charset at the FB 2.54 DB (changed
we do migration for our clients, we use our automation tools which
ensure that we have traced all problematic queries before going to
production.
I don't think it's possible to do such checking manually in case of big
enough system - and comments in this thread confirm it.
Regards,
Alexey
Hi,
Yes, sure, my mistake - I should not answer questions so late and need
to sleep more :)
Regards,
Alexey
23.05.2016 22:32, Alexey Kovyazin wrote:
>
> 44. This option turn off individual savepoints.
Individual savepoints are never turned off. This option disables the
root (trans
(i1 integer not null primary key, iSort integer,
BIGSTARTING VarchaR(2000));
insert there 10 mln records and do 2 queries as in the example. It will
take 10 mins, and and you'll see the difference by yourself.
Regards,
Alexey Kovyazin
IBSurgeon
Hi,
https://ib-aid.com/en/articles/45-ways
ur website
http://www.firebirdsql.org/en/firebird-foundation/
For more information, contact:
Steve Summers, sesumm...@firebirdsql.org, or
Alexey Kovyazin, c...@firebirdsql.org
-guide/
Regards,
Alexey Kovyazin
IBSurgeon HQbird
We have a 127GB Firebird database that was running on Windows Server
2008 x64 with 16GB of RAM and Firebird SuperClassic v2.5.2.26539. The
database has a page size of 8192 and buffers of 6144, and ODS version
11.2.
Due to time
Patrick,
Definetely you need to compare real life loads.
--
Regards,
Alexey Kovyazin
IBSurgeon среда, 13 апреля 2016г., 04:47 +03:00 от " thetr...@yahoo.com
[firebird-support]" < firebird-support@yahoogroups.com> :
>
>
>Hey Alexey,
>thanks you for our input. I t
ough
random reads.
>From Sintatica, every 20 Minutes a Peak in GC for >~15.000 transactions
Sinatica uses really strange terms to describe transactions behaviour, and
since it is an abandonen tool, nobody can explain how they are aligned with
real situation.
--
Regards,
Alexey Kovyazin
I
06.2 IOPS]
From our optimization practice we found that if you need to optimize
only the single instance of the database, the most cost effective way is
to upgrade to SSD first, and only then fix other problems.
Regards,
Alexey Kovyazin
IBSurgeon HQbird www.ib-aid.com
hi,
recently we
, this idea is not so good as it appears - if index has good
selectivity, Firebird usually uses it very effectively, until you have
some abandoned parts in the database, where you never send SQL queries.
Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com
Hi
What is the best way to go
Hi,
Gfix visits each page of the database, so 90 minutes is not so long if
your disk subsystem is not based SSD.
In general, follow these steps
http://ib-aid.com/en/articles/how-to-repair-a-corrupt-firebird-database/
Check firebird.log too - gfix reports there its findings.
Regards,
Alexey
get Snapshot.
MonLogger saves all data from MON% tables for the investigation in the
folder, and on the tab Transaction it highlights with red color those
transactions which are potentially conflict, so you can review which
application runs it.
Regards,
Alexey Kovyazin
IBSurgeon
due to
versioning and blobs.
DBinfo will give you information about distribution of pages with
numbers and percentage of page types.
Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com
Hi,
I use firebird 2.5 classic server on windows operating system.
Because our database file is quite big (1
Hi,
It is faster to use RDB$DB_KEY to find and delete duplicates.
See more details here
http://ib-aid.com/en/articles/how-to-find-and-delete-duplicate-records-in-firebird-database/
Regards,
Alexey Kovyazin
IBSurgeon
I had finally figured it out just before your reply
SELECT DISTINCT
Hi,
There should a reason why optimizer chooses the wrong plan.
Try to recalculate indices statistics.
Also, for general performance, use optimized Firebird configuration:
http://ib-aid.com/en/optimized-firebird-configuration/
Regards,
Alexey Kovyazin
IBSurgeon HQbird
www.ib-aid.com
I am
Hi,
>The following file is affected:
>http://sourceforge.net/projects/firebird/files/firebird-win64/2.5.5-Release/Firebird-2.5.5.26952_0_x64.exe/download
I can confirm that Security Essential also reported this exe as
Trojan.Win32/Varpes.J!plock
Regards,
Alexey Kovyazin
IBSurgeon
Hi Eduardo,
Can you please give links to these articles?
Regards,
Alexey Kovyazin
IBSurgeon
I searched in Google and found that, for instance, MS suggests not to
install SQL Server in a domain controller, but for security reasons.
In some articles, MS even recommends to disable disk write
that cache is bad, just highlights the potential risk
of data loss if caching without BBU is used.
So, essentially you need to buy advanced disk controller and properly
setup it - that's true.
Regards,
Alexey Kovyazin
IBSurgeon
There is an interesting (and quite long) article about SQL Server
-25% better than 2.5 SC.
Keep in mind that test is designed to simulate parallel write load.
Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com
Is FB 3.x much faster than FB 2.5.x? I'm looking for some timing and
stability comparisons.
Thanks.
kes
Firebird to preserve versions of updated record.
In general, avoid multiple updates of the same record - replace them
with INSERTs and some scheduled delete, right before sweep.
Regards,
Alexey Kovyazin
IBSurgeon
Since I began using Firebird, I have kept my transactions (type
concurre
1 - 100 of 404 matches
Mail list logo