<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV>
<H3><SPAN class=484143201-19062006><FONT size=2>Came across
this:</FONT></SPAN></H3>
<H3>Performance issue with Windows ME/XP</H3>
<P>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.</P>
<P>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.</P>
<P>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.</P>
<P>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.</P>
<P>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:</P>
<OL>
<LI>Turn off system restore. </LI>
<OL type=a>
<LI>Go to Start.</LI>
<LI>Right click on My Computer.</LI>
<LI>Select Properties</LI>
<LI>Select the Restore tab.</LI>
<LI>Check the "Turn off System Restore on all drives" box</LI></OL>
<LI>Install InterBase on its own hard drive or partition and turn off Restore
on the drive. </LI>
<OL type=a>
<LI>Go to Start.</LI>
<LI>Right click on My Computer</LI>
<LI>Select Properties</LI>
<LI>Select the Restore tab</LI>
<LI>In the Drive Settings area, select the drive where you installed
InterBase.</LI>
<LI>Select the Settings button</LI>
<LI>Check "Turn off System Restore on this drive"</LI></OL>
<LI>Make the InterBase security database (<EM>admin.ib</EM> by default) read
only.</LI>
<OL type=a>
<LI>Run <CODE>gfix -mode read_only</CODE> </LI>
<LI>Please note: This will disable gsec and other utilities from making
security changes. You will have to use <CODE>gfix -mode read_write</CODE> to
modify <EM>admin.ib</EM>.</LI></OL>
<LI>Our open source community has found a possible workaround, which consists
of editing the <EM>FileList.xml</EM> file that lists file extension to be
restored. This file is located in <EM>c:\windows\system\restore</EM> on most
systems. However, this workaround is not recommended and may infringe on
licensing issues on your operating system.</LI></OL>
<P><FONT face=Arial size=2></FONT><A
href="news://fora.borland.com:563/e5nvg0%246o85%40bornews.inprise.com#_top_"></A> </P></DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial size=2>---</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Richard Vowles, Solutions Architect,
Borland New Zealand</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>email: <A
href="mailto:richard.vowles@borland.com">richard.vowles@borland.com</A></FONT></DIV>
<DIV align=left><FONT face=Arial size=2>phone: +64-9-9184573</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>cell: +64-21-467747</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>other: MSN <A
href="mailto:richard.vowles@borland.com">richard.vowles@borland.com</A>, skype:
rvowles</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>blog: <A
href="http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769">http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769</A></FONT></DIV>
<DIV> </DIV></BODY></HTML>