Re: [firebird-support] Re: tempdirectories

2018-07-30 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
wobble...@yahoo.co.uk, > is there a good and up to date official source of documentation on > firebird.conf The firebird.conf file itself, version current for the Fb version you are using. You won't get more up to date than that anywhere. For Fb3, which allows per-database config for a lot of pa

Re: [firebird-support] Re: tempdirectories

2018-07-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.07.2018 12:01, wobble...@yahoo.co.uk [firebird-support] wrote: > is there a good and up to date official source of documentation on > firebird.conf and other > admin? Description of firebird.conf is inside of it. -- WBR, SD. ---

Re: [firebird-support] Re: tempdirectories

2018-07-30 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Ian wrote: > We got the idea from The Firebird Book, and after that I can't find > mention of it being deprecated in 2.0 release notes or later. Not deprecated but abolished. If something is "deprecated", it is still valid but likely to be dropped in a subsequent release. From Fb 2 onward, Fb wa

Re: [firebird-support] Re: tempdirectories

2018-07-28 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
> 27.07.2018 21:41, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: >> I don't know where you got the idea that you could specify the size of >> a temp directory. Dmitry replied >It is an Interbase feature. Uh...ok... @_@ If you want to allocate specific spaces for your temp di

Re: [firebird-support] Re: tempdirectories

2018-07-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.07.2018 21:41, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > I don't know where you got the idea that you could specify the size of > a temp directory. It is an Interbase feature. -- WBR, SD.

Re: [firebird-support] Re: tempdirectories

2018-07-27 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
wobble...@yahoo.co.uk wrote: > I've just tried > TempDirectories = /location1 5000 ;/location2 ; /location3 > And location1 is ignored, but 2 and 3 used! Which tells you something. ;-) The engine doesn't recognise the format of the first member of the list but it's OK with the second a

Re: [firebird-support] Re: TempDirectories and ALTER INDEX ACTIVE

2012-06-10 Thread Mark Rotteveel
On 10-6-2012 12:32, Dmitry Yemanov wrote: > 10.06.2012 14:09, Mark Rotteveel wrote: >> >> * for each record (sequential read of all pages?) >> * insert column value into index > > Inserting unsorted / random values into the b-tree is known to be much > slower than sorting the values in advance and

Re: [firebird-support] Re: TempDirectories and ALTER INDEX ACTIVE

2012-06-10 Thread Mark Rotteveel
On 8-6-2012 18:07, Ann Harrison wrote: > On Fri, Jun 8, 2012 at 11:24 AM, Alec Swan wrote: > >> Thanks Vlad, but this is too complicated to give as a guidance to our >> customers. However, it sounds like rebuilding an index cannot require more >> space that the database size itself, right? > > > O

RE: [firebird-support] Re: TempDirectories and ALTER INDEX ACTIVE

2012-06-08 Thread Leyne, Sean
Alex, > However, it sounds like rebuilding an index cannot require more > space that the database size itself, right? Correct, in order to build the index, the engine must build and sort a projection of the index values. So, if you build an index on a string [say varchar(100)] column which is o

Re: [firebird-support] Re: TempDirectories and ALTER INDEX ACTIVE

2012-06-08 Thread Ann Harrison
On Fri, Jun 8, 2012 at 11:24 AM, Alec Swan wrote: > Thanks Vlad, but this is too complicated to give as a guidance to our > customers. However, it sounds like rebuilding an index cannot require more > space that the database size itself, right? On a bad day, yes it could. To have a day that ba

Re: [firebird-support] Re: TempDirectories and ALTER INDEX ACTIVE

2012-06-08 Thread Alec Swan
Thanks Vlad, but this is too complicated to give as a guidance to our customers. However, it sounds like rebuilding an index cannot require more space that the database size itself, right? On Fri, Jun 8, 2012 at 7:22 AM, hvlad wrote: > ** > > > > > --- In firebird-support@yahoogroups.com, Alec S