(Reply) old data/archive records

[Jean-Pierre A. Radley]

Butch Ammon propounded (on Mon, May 10, 2004 at 03:49:06PM -0400):

| | I'm just curious... No biggie, no rush...  I wonder if an 82,000+
| | record database is small compared to what others have!
|
| Nothing unsual about that size even for an active file, let alone an
| archive.
|
| | Thanks for any tips on archiving old records and/or enabling filePro
| | to quickly search through tens of thousands of records when using
| | dreport with indexes.
|
| What's slow?  Aren't you using the classic sort-select method with
| 'lookup -' to find only the records you need, then quit searching?
|
|
| Hi JP,
|
| No, we're just using standard everyday automatic indexes.  When
| running a cost report from "oldorder" using Request Output, it still
| reads the 82,000 some odd records.  It's okay and runs great, but,
| well, you know how some people can be.  They want things NOW.

Of course you're using "standard everyday automatic indexes".
There aren't any other kind of automatic indexes.  :-)

I was talking about a sort-select table to quickly select a few records
and then quit.  Have a look at
	http://www.vss3.com/tips/tip_9.htm

-- 
JP