filepro RAM limit

[scooter6]

On 5/11/07, Doug Luurs <doug at borisch.com> wrote:
>
>  Just a few ideas.
>
>     Do you have a lot of 'spare' hard drive space available ?
>

       Yes - I have plent of hard drive space


>     You can copy the ?/filepro/* directories into a different area, then
> renaming the original, and then renaming the copy.
>     (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
>     about 3-5% (Not a lot, but every bit helps).
>

      I might just do this and see if I see any performance gain


> Next, is this a single processer PowerEdge ?  If not, do you have the MPU
> License installed.  This will acutally turn
> "on" the processor.
>

       It's a single CPU server so this doesn't apply


>     Also .. When you install new memory into the computer, you will need
> to adjust the keneral setting.  SCO may still
>     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
>     hours, then run TUNEUP, and it would suggest the proper Keneral
> setting for the new configuration.
>

      Any idea where to get this TUNEUP program?  I'd like to look into this
as well

     However, my thought is:  if filePro doesn't see any advantage to the
RAM, it won't directly
     address my issues I'm having - but it's a point well taken

    My question then would be this:   what are others using as far as server
hardware specs to
    have their systems fun faster?  The indexes I'm talking about are only
on a file that has just under
    250,000 records in it -- but there are 10 indexes or so on this file -
and it takes far too long to
    index it my opinion --
    If $ wasn't an object -- what would you spec out for a server that would
drastically increase
    performance??  There are some weekend processes that deal with files
much larger than
    mentioned above - one is an 'archive' process that has over 1M records
in it - and it now takes
    almost too long to finish over the weekend -- so I'm looking for
guidance on making things run
    considerably faster than the status quo.  Any suggestions would be
greatly appreciated.
   Scott



> Doug Luurs
> Borisch Mfg Corp
>
>  ------------------------------
> *From:* filepro-list-bounces+doug=borisch.com at lists.celestial.com [mailto:
> filepro-list-bounces+doug=borisch.com at lists.celestial.com] *On Behalf Of *
> scooter6
> *Sent:* Friday, May 11, 2007 9:28 AM
> *To:* filepro-list at lists.celestial.com
> *Subject:* filepro RAM limit
>
>
>  I have a customer who is running filepro 5.0.09R4 on a SCO OpenServer
> 5.0.5 platform --
>
> Hardware is a Dell Poweredge Server - 2.4GHz processor
>
> 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 --
>
> 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 ???
>
> Anyone have any suggestions on why the filepro processes wouldn't be
> noticably quicker to run ???
> Thanks
>
> Scott Ullmann
>
>
> *-- *
>
> *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.*
>
> *This E-mail, including any attachments, may contain confidential informa*
> *tion **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.*
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20070511/7c4df84d/attachment.html