#1  
Old 19th August 2009, 02:31 PM
Macarse
 
Posts: n/a
Default Big .tmp files


Hi:
I am using ODBC and I am getting big tmp files.
I've been reading in the forum[1][2] and it looks that I should set
TempStoreSize=50 or something like that but I don't know where to place
it.

In a post [3] Eivind Bakkestuen answered saying:
>
> > I am using the internal transport to connect to a local data file
> > that is about 1.6MB in size. When I connect to this file a temporary
> > file of about
> > 1.6GB is created. I don't find any way to control the size of this
> > temp file. Is there a way to limit the size ?

>
> Yes (internally that is), but I'm not sure it's exposed as a
> connectionstring param. Issue #849.
>


I couldn't see the issue. Is it solved? What version?


Thanks for reading!

[1] http://www.nexusdb.com/forums/showthread.php?t=7288
[2] http://www.nexusdb.com/forums/showthread.php?t=5909
[3] http://www.nexusdb.com/forums/showthread.php?t=11072


--
Macarse
  #2  
Old 19th August 2009, 04:37 PM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Big .tmp files

> I am using ODBC and I am getting big tmp files.
> I've been reading in the forum[1][2] and it looks that I should set
> TempStoreSize=50 or something like that but I don't know where to
> place it.


Is this using NexusDB version 1.xx?


--
Eivind Bakkestuen [NDD]
Nexus Database Systems
  #3  
Old 19th August 2009, 09:13 PM
Macarse
 
Posts: n/a
Default Re: Big .tmp files


'Eivind Bakkestuen [NDD Wrote:
> ;93736']> I am using ODBC and I am getting big tmp files.
> > I've been reading in the forum[1][2] and it looks that I should set
> > TempStoreSize=50 or something like that but I don't know where to
> > place it.

>
> Is this using NexusDB version 1.xx?
>
>
> --
> Eivind Bakkestuen [NDD]
> Nexus Database Systems



Yes, it is.


--
Macarse
  #4  
Old 19th August 2009, 09:29 PM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Big .tmp files

> Yes, it is.

Then I suspect the answer is: I dont think that parameter was ever
supported, and its not likely to be added at this point in the v1
lifecycle. The handling of temporary storage changed in v2.

--
Eivind Bakkestuen [NDD]
Nexus Database Systems


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Missing Files Hannes Danzl[NDD] nexusdb.public.support.portal 6 24th May 2010 05:58 PM
gateway log files size became 5-10GB after 6 month's normal operation Daniel Gomes Ferrari nexusdb.public.support.portal 7 29th September 2009 08:21 AM
Large temp files size Michael Duncan nexusdb.public.support.adoprovider 1 5th July 2004 01:02 PM


All times are GMT +11. The time now is 02:05 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.