sort an array

[Richard Kreiss]

Mark,

You are correct, however if an SSD is used to create the file, the write, sort, read  will be very quick.

However, the primary issue with this scenario is the hardware issue with the SSD interface and the motherboard. The bottleneck will be is the SSD has a SATA interface or an M.2 may the throttled back by the number of PCIe lanes available.  For the most part, this is an issue for gamers as both interfaces offer far better read/write performance than most Hard Drives.

This difference comes into play when running filePro on a Linux or on a Windows server.  The most noticeable difference will be on outputs or when building or rebuilding indexes.  

My new server  has 2 400GB SSD's and my workstation has 2 SSDs.  One is a Samsung 1 TB EVO 860 (SATA) and the other is a 250GB Samsung 850 EVO(M.2)  The 860 is my boot drive.  I have 3 HHDs; one internal 4TB and the second is a 1TB eSATA drive. The third is an externa; 2.5 GB JBOD USB 3.0 enclosure using 2 extra SATA drive I had but not using.

JBOD - Just a bunch of disks for those of you not familiar with this term.  JBOD allow for the use of different size drives and like RAID 0 presents them as one large drive.  That 2.5 GB is made up of a 1 TB and a 1.5 TB drive.  

What I find interesting is that all of my various 36 Client databases take up 69.2 GB of drive space on my server.  


Richard Kreiss
GCC Consulting





> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Fairlight via
> Filepro-list
> Sent: Tuesday, June 5, 2018 11:52 AM
> To: filepro-list at lists.celestial.com
> Subject: Re: sort an array
> 
> Why use a temporary file?  That's extra overhead and lost speed.  Just use a
> second array with any of the countless sorting algorithms.
> 
> Doing something is RAM will always be faster than going to disk.
> 
> m->
> 
> On Tue, Jun 05, 2018 at 10:26:38AM -0500, Richard D. Williams via Filepro-list
> thus spoke:
> > Dave,
> >
> > I don't know of any function in FP that will sort an array.
> >
> > What I do is write the array data out to a temporary file that has an
> > index built in the correct order, clear the array, reach back into the
> > temporary file, and fill the array again.
> >
> > You can use the tty as a unique identifier for each instance.
> >
> > Hope this helps,
> >
> > Richard
> >
> >
> > On 6/5/2018 9:28 AM, davidrottkamp via Filepro-list wrote:
> > >Hi
> > >
> > >Is there a way to sort an array made inside filepro
> > >
> > >version
> > >
> > >linux
> > >
> > >
> >
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
> 
> --
> Audio panton, cogito singularis.
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 14022 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180605/e8ee38e2/attachment.bin>