On 2020-01-30 16:02, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 27.01.2020 19:23, Daniel Wenzel danielwenz...@hotmail.com
> [firebird-support] wrote:
>> So my question is, there's a way of modifying SQLLEN of Firebird ODBC
>> driver to match
>> unixODBC configuration?
>
>
27.01.2020 19:23, Daniel Wenzel danielwenz...@hotmail.com [firebird-support]
wrote:
> So my question is, there's a way of modifying SQLLEN of Firebird ODBC driver
> to match
> unixODBC configuration?
I would suggest to build it from sources in your environment. It looks like
distributed
Have you checked transaction statistics when things are slow? The typical
reason for gradual slowdown is that there is one or more transactions that
started quite a long time ago and hasn't finished yet. This prevents
garbage collection and may make Firebird very slow. It is easily visible by
30.01.2020 12:48, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> Do I need to do anything else to improve performance fo the table?
Analyse queries' plan and stats. Simple delete is not a solution.
--
WBR, SD.
Hello,
I have a table with 1´000´000 entries.
As a cleanup I now delete all except for the most recent ones.
Do I need to do anything else to improve performance fo the table?
Rebuilding indices is not possible if the primary key is a autogenernarted
int, right?
Any other suggestions?
BR