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

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

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}

1062 Views

hello_world

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

Regards

Return to top