Record number
Richard Kreiss
rkreiss at gccconsulting.net
Mon Sep 30 08:43:33 PDT 2013
> -----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
More information about the Filepro-list
mailing list