• 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 login_dejavu, Today, 09:03 AM
    0 responses
    1 view
    0 likes
    Last Post login_dejavu  
    Started by MavMoney, Today, 07:17 AM
    1 response
    5 views
    0 likes
    Last Post MavMoney  
    Started by jameslee001, Today, 08:09 AM
    0 responses
    5 views
    0 likes
    Last Post jameslee001  
    Started by bertochi, Today, 07:25 AM
    1 response
    2 views
    0 likes
    Last Post bertochi  
    Started by Kentoes, Today, 07:06 AM
    0 responses
    4 views
    0 likes
    Last Post Kentoes
    by Kentoes
     
    Working...
    X