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:* [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
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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
phone: +64-9-9184573
cell: +64-21-467747
other: MSN [EMAIL PROTECTED]
<mailto:[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
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
