At 04:15 AM 10/17/2007, you wrote:
Subject: AW: DB question, searching
From: "Harald Schlangmann" <[EMAIL PROTECTED]>
Date: Tue, 16 Oct 2007 18:18:21 +0200
X-Message-Number: 14
Roger,
what is the clue behind the 10k limit?
> But a warning... You should avoid high record counts! Although you
> can have 64K records, you should avoid getting significantly over
> 10K. If you need more records then start treating each PDB record
> as a block and put multiple actual records in each block.
Its just a guideline, but actually once you get several thousand
records you should start thinking whether you need to start treating
PDB records as blocks and then putting multiple actual records in each block.
For example: HotSync'ing a file with lots of small records is much,
much slower than a file of the same size with a few large
records. Also a linear search is slower as well.
Roger
--
For information on using the ACCESS Developer Forums, or to unsubscribe, please
see http://www.access-company.com/developers/forums/
