Re: [firebird-support] RE: Insert into Large Table is slowly!

2013-09-07 Thread Ann Harrison
On Sat, Sep 7, 2013 at 11:07 AM, wrote: > > The page isze is 16KB. > > I'm not run gstat. I will try do it. > At the same time, you should get some monitoring statistics - reads/writes/marks/fetches. And some system stats as well - memory, page faults, disk writes, etc. Good luck, Ann > >

Re: [firebird-support] Use all space or not on large restore?

2013-09-07 Thread Ann Harrison
On Sat, Sep 7, 2013 at 8:15 AM, Kjell Rilbe wrote: > > I'm considering if "use all space" would be a good idea or not. I think > I understand its effect on indices: fill index pages completely vs. > leave 25% free space on each index page for new entries. > > Unh, no. Use All Space affects only

Re: [firebird-support] Which is the reason for the clause GRANTED BY?

2013-09-07 Thread W O
Thank you very much Paul for answering. In your document "Firebird 2.5 - Language Reference Update" the database owner, BOB, writes: *grant digger to frank with admin option granted by fritz* * * but, what if fritz doesnt agree with to be the grantor? It can take him a long time for know that he

[firebird-support] RE: Insert into Large Table is slowly!

2013-09-07 Thread jym013

Re: [firebird-support] Use all space or not on large restore?

2013-09-07 Thread Doug Chamberlin
You seem to not be solving a problem but only looking to improve something. What are you trying to improve? I say you are just looking for trouble by changing something that is not a problem.

[firebird-support] Use all space or not on large restore?

2013-09-07 Thread Kjell Rilbe
Hi, I intend to upgrade my ~Gbyte database to new ODS (for FB 2.5) using backup/restore cycle. For this database, each table has a PK that's strictly incremental, but not contiguous (the same contiguous sequence is used for all tables due to a framework I use = not my personal choice). Most ta

Re: [firebird-support] Use all space or not on large restore?

2013-09-07 Thread fabianoaspro
Do not use this in production databases. It is intended to be used in read only databases, when no writes is allowed and space is critical, like shipping a catalog product in a cdrom. Em 07/09/2013 09:18, "Kjell Rilbe" escreveu: > ** > > > Hi, > > I intend to upgrade my ~100 Gbyte database to new

[firebird-support] Use all space or not on large restore?

2013-09-07 Thread Kjell Rilbe
Hi, I intend to upgrade my ~100 Gbyte database to new ODS (for FB 2.5) using backup/restore cycle. For this database, each table has a PK that's strictly incremental, but not contiguous (the same contiguous sequence is used for all tables due to a framework I use = not my personal choice). Mos