04.02.2019 13:09, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
wrote:
> Can I ask you if there is any good tutorial so one could start learning the
> ins and outs
> about optimizing queries and plans? I’ve sifted through the available
> documentation a few
> times but they are
>Look about your where clause and also if your inner join catch whole index
>segments (explained plan can >help here).
>Also increase cache of this database.
Thanks for the feedback Karol.
Generally it’s very hard for us to optimize the bigger queries, we usually try
to shift joins and
Yes, this wideo is usefull and show where the problem is.
1. Something is not satisfy by ypour filter and go throught 1M rows when you
have this one additional record vs 21K.
2. First run go from disk – 59K reads from disk vs 2.5K.
Look about your where clause and also if your inner join catch
Hello.
Since the topic died down I would like to give it another go and explain all
that transpired, in the hopes of trying to understand this behavior.
I am unable to determine is this is normal/intended behavior, or something
that might be worth being looked upon by the devs.
-I have a
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
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
>Read Release Notes. Embedded mode is used automatically for local connections.
Sorry. In that case, yes, I tried with embedded too.
28.01.2019 18:10, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
wrote:
> Tried downloading it now but couldnt find the embedded version for firebird 3
Read Release Notes. Embedded mode is used automatically for local
connections.
--
WBR, SD.
28.01.2019 17:07, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
wrote:
> Im using firebird 3, tried with the latest stable release, and the latest
> snapshot from today.
Did you try it in embedded mode?
--
WBR, SD.
>>Look at gstat output
>>You probably have very long version this particular record
>Hi Karol.
>I checked gstat and made a manual sweep of the database, but the problem
>persists.
>There are some things I’m finding odd :
>-The query brings 4791 records total
>-Always on record 4000, it
Op 28-01-2019 om 14:14 schreef Rudi Feijó rudi.fe...@multidadosti.com.br
[firebird-support]:
>Look at gstat output
>You probably have very long version this particular record
Hi Karol.
I checked gstat and made a manual sweep of the database, but the
problem persists.
There are some things
>Look at gstat output
>You probably have very long version this particular record
Hi Karol.
I checked gstat and made a manual sweep of the database, but the problem
persists.
There are some things I’m finding odd :
-The query brings 4791 records total
-Always on record 4000, it hangs and
Hi.
Look at gstat output
You probably have very long version this particular record
Regards,
Karol Bieniaszewski
I have a query that returns about 5000 records, that should run without
problems.
However, when Im fetching the records in my applications loop, it always
hangs for several seconds on an specific record.
All the other records are fetched fast as expected, but when it gets to
record 4096 it hangs
15 matches
Mail list logo