Jump to:

23481 Posts in 18951 Topics by 2878 members

General Questions

SilverStripe Forums » General Questions » Large database {/dev/build issue}

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 233 Views
  • hello_world
    Avatar
    Community Member
    17 Posts

    Large database {/dev/build issue} Link to this post

    Hello Silverstripers,

    We have a database which has ~1,6GB (~3 million records).
    Only 2 tables has ~ 2,8mln records and has defined index.
    Everything works !!perfectly!! but we have a issue with correct run of /dev/build
    I can`t define new columns in model because when I run /dev/build, after several minutes system return 5xx status.

    I change in development environment max_execution_time up to 3600 secounds but sill nothing.

    My question is: if I defined new fields in datamodel, must run /dev/bulid? Can I add this field manually in console rdbms and manually reindex table?
    What really happends when we run /dev/build , outside create new fields - if they defined?

    Project was build on SilverStripe 2.4.xx
    RDBMS is PostgreSQL 9.1
    Webserver: nginx

    Regards

    233 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.