[DUG] who still uses .gdb files?

[Kyley Harris]

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. 

	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/069dc59f/attachment.html