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.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

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


710 Views

Avatar
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