• If this is your first visit, you will have to register before you can post. To view messages, please scroll below and select the forum that you would like to visits. Questions? Be sure to check out the Forum FAQ.

Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Bloated sdf file causes slow down in live

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Bloated sdf file causes slow down in live

    Hello all,

    I've noticed that once the sdf database file under db/NinjaTrader.sdf becomes large (> 500 MB), I get a performance hit when loading and editing strategy configurations.
    Is there a way to reduce the size of this file while keeping the following info which I consider vital?
    These are the work-spaces and the strategy configurations.

    Thanks,
    Boaz

    #2
    Hello,

    Under Tools--> Options--> Data tab--> 'Repair DB' should attempt to compact the database to a smaller size.

    If running the repair db option does not bring the database down to a manageable level, you will need to 'Reset DB'

    The workspaces are not saved in the database and will not be lost when resetting. However some strategy information will be contained here.

    Do you know what exactly you're doing to get the db this large? We typically do not see a db size of over 30-100MB.
    MatthewNinjaTrader Product Management

    Comment

    Latest Posts

    Collapse

    Topics Statistics Last Post
    Started by teafortwo, Today, 04:26 AM
    4 responses
    12 views
    0 likes
    Last Post bltdavid  
    Started by borjanews, Today, 06:13 PM
    0 responses
    4 views
    0 likes
    Last Post borjanews  
    Started by Austiner87, Today, 05:13 PM
    0 responses
    2 views
    0 likes
    Last Post Austiner87  
    Started by Austiner87, Today, 04:59 PM
    0 responses
    4 views
    0 likes
    Last Post Austiner87  
    Started by Austiner87, Today, 04:58 PM
    0 responses
    1 view
    0 likes
    Last Post Austiner87  
    Working...
    X