D
dbeavon
Guest
It is unfortunate that we should do our schema maintenance one way for tables under 1,000,000 rows and another way for tables greater than that. The difference in this case is a few minutes vs a few hours (ie. extreme). I don't think most managers would be that comfortable shelling to the command line and running "proutil" commands as a standard operating procedure. Generally speaking, the task of applying our standard monthly dictionary changes is done by one role/individual, and the task of running proutil commands against the database is done by a different type of role/individual (and that happens in exceptional circumstances). This seems like this is a fairly significant limitation in scaling up an OE database.
Continue reading...
Continue reading...