On 1/25/2019 7:11 PM, Daniel Miller dmil...@amfes.com [firebird-support]
wrote:
On 1/24/2019 7:56 AM, respekt...@post.cz [firebird-support] wrote:
Hello
I have problem with part of our databases.
All our databases should have the same structure, but in some of them
I cannot drop constraint
29.01.2019 21:13, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
wrote:
> the multi-segment indexes are to optimize commonly used queries.
In this case you can consider removing one or two fields from the index and
see how
much selectivity it lose and how much performance would
> > All the FB articles/docs/postings that I have seen have said for
> > performance, index depth should be no more than 3.
>
> This is not a hard requirement, 4 levels may be also OK. Are those multi-
> segment indices primary/unique keys or just for lookup purposes?
{Sorry for the delay in
Op 29-01-2019 om 12:45 schreef Rudi Feijó rudi.fe...@multidadosti.com.br
[firebird-support]:
>Two last things come to mind...
>- a memory issue on the server
>What happens if you change page buffers?
>- a disk issue on the server
>What happens if you leave the original file on the server
>Two last things come to mind...
>- a memory issue on the server
>What happens if you change page buffers?
>- a disk issue on the server
>What happens if you leave the original file on the server and try a copy of
>the database
>on a different disk location
>on a different disk
>on a
Hi
Is this from problematic time with connected clients?
If yes than i do no see problems.
You must provide more details about issue.
What exact comand is slow? What are the query plan and query sats?
Did you tested HDD isues?
…
Regards,
Karol Bieniaszewski
Two last things come to mind...
- a memory issue on the server
What happens if you change page buffers?
- a disk issue on the server
What happens if you leave the original file on the server and try a copy
of the database
on a different disk location
on a different disk
on a different
Hi
I tried backup - restore, gfix and it did not help
I drop all dependencies - views, stored procedures, triggers that was
dependend on the table
But it did not help - still the same error.
The full FB version is 2.5.8.27089
Thank for your help.
Tom