Record number

ken_wakeman at me.com ken_wakeman at me.com
Mon Sep 30 09:01:41 PDT 2013


That would be great IF i could store the qualified file in a different location. Like non filepro files ( wish list ? )

Ken
Sent from my BlackBerry device on the Rogers Wireless Network

-----Original Message-----
From: Richard Kreiss <rkreiss at gccconsulting.net>
Sender: filepro-list-bounces+ken_wakeman=me.com at lists.celestial.com
Date: Mon, 30 Sep 2013 15:43:33 
To: mschw at athenet.net<mschw at athenet.net>; filePro Mailing List<filepro-list at lists.celestial.com>
Subject: RE: Record number



> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of Mike Schwartz
> Sent: Monday, September 30, 2013 11:11 AM
> To: filePro Mailing List
> Subject: RE: Record number
> 
> > > So does this mean a file ( fP 5.06 and beyond ) can have more than
> > > 100 million records ??
> 
> > > Sender: filepro-list-bounces+ken_wakeman=me.com at lists.celestial.com
> 
>      Since filePro has a really great "qualifier files" function, I'm just curious
> what sort of applications require having over 100 million records in a single
> file?
> 
>      I was writing filePro apps that handled millions of records for many years.
> For processing efficiency, I've always broken those records down into
> separate qualifiers.  Writing the additional code to handle the qualifiers
> should be pretty trivial.
> 
> Mike Schwartz
> 

I did the same thing for one client as they are constantly adding "memos"  to records in their primary working file.  Memos older the 2 years are moved to a history qualifier.  If there are no current memos associated with the particular record, the program display the most recent memos in the history file.

The memos are displayed on screen when accessing the record using auto processing and dummy fields to display up to 6 memos depending on if they are 1 or 2 line memos.  This is a speed issue.

I have another client with a sales history file by product and store which dates back almost 15 years and grow daily.  This file already broke the 2GB file size and he does not want to archive the old data.  He does run some sales analysis reports off of this file although some of the products or products lines have been discontinued.


Richard Kreiss
GCC Consulting

Office: 410-653-2813



_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list


More information about the Filepro-list mailing list