Changes between Version 3 and Version 4 of OracleBranch
- Timestamp:
- Apr 19, 2007, 4:19:24 PM (18 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
OracleBranch
v3 v4 21 21 === Tablespace options === 22 22 23 A common paradigm for optimizing performance in Oracle-based systems is the use of [http://en.wikipedia.org/wiki/Tablespace tablespaces] to organize disk layout. The Oracle branch supports this use case by adding '' tablespace'' options to Meta and Field classes. When using a backend that lacks support for tablespaces, these options are ignored.23 A common paradigm for optimizing performance in Oracle-based systems is the use of [http://en.wikipedia.org/wiki/Tablespace tablespaces] to organize disk layout. The Oracle branch supports this use case by adding ''db_tablespace'' options to Meta and Field classes. When using a backend that lacks support for tablespaces, these options are ignored. 24 24 25 A tablespace can be specified for the table(s) generated by a model by supplying the " tablespace" option inside the model's Meta class. Additionally, the "tablespace" option can be passed to a Field constructor to specify an alternate tablespace for the Field's column index. If no index would be created for the column, the "tablespace" option is ignored.25 A tablespace can be specified for the table(s) generated by a model by supplying the "db_tablespace" option inside the model's Meta class. Additionally, the "db_tablespace" option can be passed to a Field constructor to specify an alternate tablespace for the Field's column index. If no index would be created for the column, the "db_tablespace" option is ignored. 26 26 27 27 {{{ 28 28 class TablespaceExample(models.Model): 29 name = models.CharField(maxlength=30, db_index=True, tablespace="indexes")29 name = models.CharField(maxlength=30, db_index=True, db_tablespace="indexes") 30 30 data = models.CharField(maxlength=255, db_index=True) 31 edges = models.ManyToManyField(to="self", tablespace="indexes")31 edges = models.ManyToManyField(to="self", db_tablespace="indexes") 32 32 33 33 class Meta: 34 tablespace = "tables"34 db_tablespace = "tables" 35 35 }}} 36 36 … … 62 62 63 63 * The branch could use additional testing. 64 * Rename the "tablespace" options to "db_tablespace" to match "db_table" and "db_index"? 65 * Additional code refactoring for the !QuerySet.iterator and !QuerySet._get_sql_clause methods. 64 * Additional code refactoring for the !QuerySet.iterator and !QuerySet._get_sql_clause methods would be nice.