When you create a new database file, you can preallocate database file space using Sybase Central. Preallocating space can improve performance for loading large amounts of data and keeps database files more contiguous.
Prérequis
You must have the MANAGE ANY DBSPACE system privilege.
Contexte et remarques
As you use a database, it automatically grows database files as needed. Rapidly-changing database files can lead to excessive file fragmentation on the disk, resulting in potential performance problems. As well, many small allocations are slower than one large allocation. If you are working with a database with a high rate of change, you can preallocate disk space for dbspaces or for transaction logs using Sybase Central.
Running a disk defragmentation utility after preallocating disk space helps ensure that the database file is not fragmented over many disjointed areas of the disk drive. Performance can suffer if there is excessive fragmentation of database files.
TaskIn Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, click Dbspaces.
In the right pane, right-click the dbspace and click Preallocate Space.
Enter the amount of space to add to the dbspace. You can add space in units of pages, bytes, kilobytes (KB), megabytes (MB), gigabytes (GB), or terabytes (TB).
Click OK.
See also |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |