RE: [DUG] who still uses .gdb files?

Sun, 18 Jun 2006 19:07:37 -0700

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
  1. 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"
  1. 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.
  1. 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.

 

 

---

Richard Vowles, Solutions Architect, Borland New Zealand

email: [EMAIL PROTECTED]

phone: +64-9-9184573

cell: +64-21-467747

other: MSN [EMAIL PROTECTED], skype: rvowles

blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769

 

_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi

Reply via email to