ODP: ODP: [firebird-support] Re: Strange behavior on very large table

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

I see that you have only 1024 page buffers. 
Do you use SuperServer or Classic?
If Superserver then increase it.

Regards,
Karol Bieniaszewski

Re: ODP: [firebird-support] Re: Strange behavior on very large table

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

02.03.2019 10:50, Karol Bieniaszewski liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
> You have quite big fill 94%, that there is a chence that new page must be 
> allocated – but 
> here still you have free slots.

   It may be a sign of record fragmentation which is bad from performance POV. 
Average 
record length is not big enough to fill data pages completely so I would guess 
that his 
application may do something strange: insert "empty" record and then update it 
with data. 
That would be bad.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

ODP: [firebird-support] Re: Strange behavior on very large table

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

You have 91345 versions but Max versions is 1. Then i do not think that 
performance problem is here.
You have quite big fill 94%, that there is a chence that new page must be 
allocated – but here still you have free slots.
You have gap between oldest active nad next transaction. It is not big but you 
must look if this do not cause problem somewhere else
Which affect overall performance.

No more to say. I do not know anything about indexes, referencess and queries 
involved in this system.
Regards,
Karol Bieniaszewski