About temporary table

neramit · 2006-01-24

All Expert

I want to know about Temporary table
if have more data to insert to temporary table
how about affect client machine ?

thank you :-k

Staminos · 2006-01-24

Hi,

With temporary table, you work on client system.
So if you insert many records in this table, you consummate much memory on client and insert will be speedless.

ara3n · 2006-01-24

To test performance loop through the items andinsert them into a temporary item record. Mostly there is very little performace hit, and the amount of memory depends on number of records inserted.

fb · 2006-01-24

There is a very interesting post on mbsonline.org regarding the internal memory allocation behavior of temporary tables --

http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=11163

That topic isn't displaying correctly (at least for me this morning), so I'll repeat here the more interesting parts:

Navision 3.10/3.60/3.70 will allocate up to 300K for each temp table - the allocation will begin when the first INSERT occurs and continue up to that limit as inserts/modifications are made - the remainder of the storage occupied by the temp table is written to disk in a temp file so you will see no significant memory usage for a temp table. None of this space is freed until the table handle is out of scope so deleting records in a temp table does not reduce this memory nor the size of the temp file.

In Attain 3.01 this threshold was 30K, from Navision 4.0 it is 500k.

The up-side is that you can have almost as many records as you want (<2.6billion) in your temp table without worrying about memory issues inc. swapping - and without a performance problem since they are b-trees.

kriki · 2006-01-24

But the file on disk cannot go beyond 2GB see also Failure in Step 2 of upgrade to 4.00

About temporary table

Comments

Categories