Kbase P95826: Is there a limit for the number of records in a temp table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/17/2004 |
|
Status: Unverified
GOAL:
Is there a limit for the number of records in a temp table?
GOAL:
Amount of records of a temp table limit?
GOAL:
What are the amount of records that can stored in a temp table?
FIX:
It depends on several factors, the most important of which is the record size. The total amount of space that can be used by all temp tables combined and their indexes is limited to 2 GB. This gives you up to roughly 2,000,000 blocks of 1024 bytes or 250,000 blocks of 8192 bytes. The number of records that will fit depends on the record size and the number of indexes. With 1024 byte blocks, the best case is when 32 records are stored per block, and if you assume one fourth of the blocks are needed for indexes, that gives you 32 * 1,500,000 or about 48,000,000 records of about 31 bytes. If your records are larger, for example 1500 bytes, then you can have about 1,000,000 records.