<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@SimSun";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h3
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:13.5pt;
font-family:"Times New Roman";
font-weight:bold;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
code
{font-family:"Courier New";}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1009525298;
mso-list-template-ids:-324885880;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
delphi-bounces@ns3.123.co.nz [mailto:delphi-bounces@ns3.123.co.nz] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Richard Vowles<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, 19 June 2006 1:33
p.m.<br>
<b><span style='font-weight:bold'>To:</span></b> NZ Borland Developers Group - <st1:place
w:st="on">Delphi</st1:place> List<br>
<b><span style='font-weight:bold'>Subject:</span></b> [DUG] who still uses .gdb
files?</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<h3><b><font size=2 face="Times New Roman"><span style='font-size:10.0pt'>Came
across this:</span></font><o:p></o:p></b></h3>
<h3><b><font size=4 face="Times New Roman"><span style='font-size:13.5pt'>Performance
issue with Windows ME/XP<o:p></o:p></span></font></b></h3>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>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.<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>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.<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>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.<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>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.<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>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:<o:p></o:p></span></font></p>
<ol start=1 type=1>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Turn off system restore. <o:p></o:p></span></font></li>
</ol>
<ol start=1 type=1>
<ol start=1 type=a>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Go to Start.<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Right click on My Computer.<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Select Properties<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Select the Restore tab.<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Check the "Turn off System Restore on all
drives" box<o:p></o:p></span></font></li>
</ol>
</ol>
<ol start=2 type=1>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Install InterBase on its own hard drive or
partition and turn off Restore on the drive. <o:p></o:p></span></font></li>
</ol>
<ol start=2 type=1>
<ol start=1 type=a>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Go to Start.<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Right click on My Computer<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Select Properties<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Select the Restore tab<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>In the Drive Settings area, select the drive
where you installed InterBase.<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Select the Settings button<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Check "Turn off System Restore on this
drive"<o:p></o:p></span></font></li>
</ol>
</ol>
<ol start=3 type=1>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Make the InterBase security database (<em><i><font
face="Times New Roman">admin.ib</font></i></em> by default) read only.<o:p></o:p></span></font></li>
</ol>
<ol start=3 type=1>
<ol start=1 type=a>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Run </span></font><code><font size=2
face="Courier New"><span style='font-size:10.0pt'>gfix -mode read_only</span></font></code>
<o:p></o:p></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Please note: This will disable gsec and other
utilities from making security changes. You will have to use </span></font><code><font
size=2 face="Courier New"><span style='font-size:10.0pt'>gfix -mode
read_write</span></font></code> to modify <em><i><font
face="Times New Roman">admin.ib</font></i></em>.<o:p></o:p></li>
</ol>
</ol>
<ol start=4 type=1>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Our open source community has found a possible
workaround, which consists of editing the <em><i><font
face="Times New Roman">FileList.xml</font></i></em> file that lists file
extension to be restored. This file is located in <em><i><font
face="Times New Roman">c:\windows\system\restore</font></i></em> on most
systems. However, this workaround is not recommended and may infringe on
licensing issues on your operating system.<o:p></o:p></span></font></li>
</ol>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><a
href="news://fora.borland.com:563/e5nvg0%246o85%40bornews.inprise.com#_top_"></a> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>---</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Richard Vowles, Solutions Architect, Borland <st1:country-region
w:st="on"><st1:place w:st="on">New Zealand</st1:place></st1:country-region></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>email: <a href="mailto:richard.vowles@borland.com">richard.vowles@borland.com</a></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>phone: +64-9-9184573</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>cell: +64-21-467747</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>other: MSN <a href="mailto:richard.vowles@borland.com">richard.vowles@borland.com</a>,
skype: rvowles</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>blog: <a
href="http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769">http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769</a></span></font><o:p></o:p></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>