<br><br>
<div><span class="gmail_quote">On 5/11/07, <b class="gmail_sendername">Doug Luurs</b> <<a href="mailto:doug@borisch.com">doug@borisch.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div align="left"><span><font face="Arial" color="#0000ff" size="2"><span><font face="Arial" color="#0000ff" size="2">Just a few ideas.<br><br> </font></span>Do you have a lot of 'spare' hard drive space available ?
</font></span></div></div></blockquote>
<div> </div>
<div> Yes - I have plent of hard drive space</div><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div align="left"> </div>
<div align="left"><span><font face="Arial" color="#0000ff" size="2"> You can copy the ?/filepro/* directories into a different area, then renaming the original, and then renaming the copy.</font></span></div>
<div align="left"><span><font face="Arial" color="#0000ff" size="2"> (Poor man's method of Defraging on a unix server). I do this once or twice a year, and it does speed up access by</font></span></div>
<div align="left"><span><font face="Arial" color="#0000ff" size="2"> about 3-5% (Not a lot, but every bit helps).</font></span></div></div></blockquote>
<div> </div>
<div> I might just do this and see if I see any performance gain</div><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div align="left"> </div>
<div align="left"><span><font face="Arial" color="#0000ff" size="2">Next, is this a single processer PowerEdge ? If not, do you have the MPU License installed. This will acutally turn</font></span></div>
<div align="left"><span><font face="Arial" color="#0000ff" size="2">"on" the processor.</font></span></div></div></blockquote>
<div> </div>
<div> It's a single CPU server so this doesn't apply</div><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div align="left"> </div>
<div align="left"><span><font face="Arial" color="#0000ff" size="2"> Also .. When you install new memory into the computer, you will need to adjust the keneral setting. SCO may still</font></span></div>
<div align="left"><span><font face="Arial" color="#0000ff" size="2"> think there is only 512k. I had a program called TUNEUP, and I would run the system as is under a full load for 24-48</font></span></div>
<div align="left"><span><font face="Arial" color="#0000ff" size="2"> hours, then run TUNEUP, and it would suggest the proper Keneral setting for the new configuration.</font></span></div></div></blockquote>
<div> </div>
<div> Any idea where to get this TUNEUP program? I'd like to look into this as well</div>
<div> </div>
<div> However, my thought is: if filePro doesn't see any advantage to the RAM, it won't directly</div>
<div> address my issues I'm having - but it's a point well taken</div>
<div> </div>
<div> My question then would be this: what are others using as far as server hardware specs to</div>
<div> have their systems fun faster? The indexes I'm talking about are only on a file that has just under</div>
<div> 250,000 records in it -- but there are 10 indexes or so on this file - and it takes far too long to </div>
<div> index it my opinion -- </div>
<div> If $ wasn't an object -- what would you spec out for a server that would drastically increase </div>
<div> performance?? There are some weekend processes that deal with files much larger than </div>
<div> mentioned above - one is an 'archive' process that has over 1M records in it - and it now takes</div>
<div> almost too long to finish over the weekend -- so I'm looking for guidance on making things run</div>
<div> considerably faster than the status quo. Any suggestions would be greatly appreciated.</div>
<div> Scott</div>
<div> </div><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div align="left"> </div>
<div align="left"><span><font face="Arial" color="#0000ff" size="2">Doug Luurs<br></font></span><span><font face="Arial" color="#0000ff" size="2">Borisch Mfg Corp</font></span></div><br>
<div align="left">
<hr>
<font face="Tahoma" size="2"><b>From:</b> filepro-list-bounces+doug=<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:borisch.com@lists.celestial.com" target="_blank">borisch.com@lists.celestial.com</a>
[mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:filepro-list-bounces+doug=borisch.com@lists.celestial.com" target="_blank">filepro-list-bounces+doug=borisch.com@lists.celestial.com</a>] <b>
On Behalf Of </b>scooter6<br><b>Sent:</b> Friday, May 11, 2007 9:28 AM<br><b>To:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com
</a><br><b>Subject:</b> filepro RAM limit<br></font><br> </div>
<div><span class="e" id="q_1127b8a915df5713_1">
<div></div>
<div>I have a customer who is running filepro 5.0.09R4 on a SCO OpenServer 5.0.5 platform -- </div>
<div><font face="Arial" color="#0000ff" size="2"></font> </div>
<div>Hardware is a Dell Poweredge Server - 2.4GHz processor </div>
<div> </div>
<div>Everything has been working great for about 3 yrs now -- I decided to upgrade their RAM -- they only had 512MB -- so, I'm at client's site -- ordered 2GB from Dell and installed it last night -- everything booted fine and ran a couple of processes last night - including some indexes - and it seemed a bit faster - just not REALLY faster like I would have thought --
</div>
<div> </div>
<div>During their series of night time processes that runs nightly, it wasn't any faster at all to complete -- still takes about an hour and a half ???</div>
<div> </div>
<div>Anyone have any suggestions on why the filepro processes wouldn't be noticably quicker to run ???</div>
<div>Thanks</div>
<div> </div>
<div>Scott Ullmann</div>
<div> </div></span></div></div><font face="Tahoma" size="2"><font color="#0000ff">
<p align="left"><font face="Courier New" size="2"><span style="FONT-SIZE: 10pt"><em>-- </em></span></font></p>
<p align="left"><font face="Courier New" size="2"><span style="FONT-SIZE: 10pt"><em>These commodities/technical data are controlled under the United States Export Regulations and may not be exported to a foreign person, either in the
U.S. or abroad, without the proper authorization of the U.S. Department of State or the U.S. Department of Commerce. Please contact Borisch Manufacturing Corporation for commodity classification and jurisdiction.</em></span>
</font></p>
<p align="left"><font face="Courier New" size="2"><span style="FONT-SIZE: 10pt"><em>This E-mail, including any attachments, may contain confidential informa</em></span></font><font face="Courier New" size="2"><span style="FONT-SIZE: 10pt">
<em>tion </em></span></font><font face="Courier New" size="2"><span style="FONT-SIZE: 10pt"><em>and is intended solely for use by the individual to whom it is addressed. If you received this E-mail in error, please notify the sender, do not disclose its contents to others, and delete it from your system. Any other use of this E-mail and/or attachments is prohibited. This message is not meant to constitute an electronic signature or intent to contract electronically.
</em></span></font><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font></p></font></font></blockquote></div><br>