Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

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

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

Large database {/dev/build issue}

Go to End



Community Member, 19 Posts

24 July 2013 at 11:13pm

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