[DUG] who still uses .gdb files?

[Richard Vowles]

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. 

	a.	Go to Start.
	b.	Right click on My Computer.
	c.	Select Properties
	d.	Select the Restore tab.
	e.	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. 

	a.	Go to Start.
	b.	Right click on My Computer
	c.	Select Properties
	d.	Select the Restore tab
	e.	In the Drive Settings area, select the drive where you
installed InterBase.
	f.	Select the Settings button
	g.	Check "Turn off System Restore on this drive"

3.	Make the InterBase security database (admin.ib by default) read
only.

	a.	Run gfix -mode read_only 
	b.	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
phone: +64-9-9184573
cell: +64-21-467747
other: MSN richard.vowles at borland.com, skype: rvowles
blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20060619/29e79acf/attachment.html