[DUG] who still uses .gdb files?

[Paul McKenzie]

True - this should also be on the DUG InterBase list...

Regards
Paul McKenzie
Wellington
New Zealand


Kyley Harris wrote:
> Well, that’s old news and really odd fix. Not using gdb is really a much 
> easier fix. Interbase doesn’t care what the file is called. Just name it 
> idb for interbase database and there is no problem at all
> 
>  
> 
> ------------------------------------------------------------------------
> 
> *From:* delphi-bounces at ns3.123.co.nz 
> [mailto:delphi-bounces at ns3.123.co.nz] *On Behalf Of *Richard Vowles
> *Sent:* Monday, 19 June 2006 1:33 p.m.
> *To:* NZ Borland Developers Group - Delphi List
> *Subject:* [DUG] who still uses .gdb files?
> 
>  
> 
> 
>       *Came across this:*
> 
> 
>       *Performance issue with Windows ME/XP*
> 
> This issue was raised during the release of InterBase 7.0. If you have 
> renamed your databases to have an extension other than ".gdb" or if none 
> of your databases are on Windows platforms, you can ignore this section.
> 
> Microsoft has implemented a backup and restore utility called System 
> Restore. This utility automatically backs up files that have certain 
> extensions whenever they are touched. The old default InterBase file 
> extension 'GDB' is on this list, which means that databases that have 
> names ending in ".gdb" get backed up extremely frequently when they are 
> in use. This is causing performance problems on Windows ME and XP systems.
> 
> Because of this situation, we have changed the name of the InterBase 
> security database from isc4.gdb to admin.ib. above, for information on 
> how to restore an existing security database to this or another name.
> 
> We also recommend that you no longer use .gdb for any of your database 
> names on these platforms, to avoid the performance degradation 
> associated with having the OS back up every database every time it is 
> modified.
> 
> However, if you need to retain "gdb" as the extension for your security 
> database and for other databases, we have developed the following 
> workarounds for this issue:
> 
>    1. Turn off system restore.
> 
>          1. Go to Start.
>          2. Right click on My Computer.
>          3. Select Properties
>          4. Select the Restore tab.
>          5. Check the "Turn off System Restore on all drives" box
> 
>    2. Install InterBase on its own hard drive or partition and turn off
>       Restore on the drive.
> 
>          1. Go to Start.
>          2. Right click on My Computer
>          3. Select Properties
>          4. Select the Restore tab
>          5. In the Drive Settings area, select the drive where you
>             installed InterBase.
>          6. Select the Settings button
>          7. Check "Turn off System Restore on this drive"
> 
>    3. Make the InterBase security database (//admin.ib// by default)
>       read only.
> 
>          1. Run |gfix -mode read_only|
>          2. Please note: This will disable gsec and other utilities from
>             making security changes. You will have to use |gfix -mode
>             read_write| to modify //admin.ib//.
> 
>    4. Our open source community has found a possible workaround, which
>       consists of editing the //FileList.xml// file that lists file
>       extension to be restored. This file is located in
>       //c:\windows\system\restore// on most systems. However, this
>       workaround is not recommended and may infringe on licensing issues
>       on your operating system.
> 
> <news://fora.borland.com:563/e5nvg0%246o85%40bornews.inprise.com#_top_> 
> 
>  
> 
> ---
> 
> Richard Vowles, Solutions Architect, Borland New Zealand
> 
> email: richard.vowles at borland.com <mailto:richard.vowles at borland.com>
> 
> phone: +64-9-9184573
> 
> cell: +64-21-467747
> 
> other: MSN richard.vowles at borland.com 
> <mailto:richard.vowles at borland.com>, skype: rvowles
> 
> blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi