📄 maximumcapacityspecification.htm

📁 Absolute Database 5.12 src. Absolute Database lets you forget the Borland Database Engine (BDE). Th
💻 HTM
字号:
<html>
<head>
   <title>Maximum Capacity Specifications</title>
</head>

<!--#include virtual="/inc/header.php"-->


<table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="#FFFFFF">
  <tr>
    <td align="left">
      
<span style="font-family:Helvetica,Arial; font-size:12pt; color:#000000"><b>Maximum Capacity Specifications
<br>
</b></span>
    </td>
    <td align="right">
     <font face="Arial" size="2">
     <a href="faq.htm">Previous</a>&nbsp;
     <a href="overview.htm">Top</a>&nbsp;
     <a href="supporteddatatypes.htm">Next</a>
     </font>
    </td>
  </tr>
</table>
<br><br>



<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
<table border="0" cellpadding="1"><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Object</b>
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b> Maximum sizes / numbers</b>
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> <b>Multi-User Edition</b>
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b> Single-User Edition</b>
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Bytes per string field
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 64,000 (also limited by page size)
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 64,000 (also limited by page size)
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Bytes per BLOB field
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2GB
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2GB
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Bytes per index
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 64,000 (also limited by page size)
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 64,000 (also limited by page size)
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Bytes per row
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 65,400 (also limited by page size)
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 65,400 (also limited by page size)
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Columns per index
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 10,000
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 10,000
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Columns per table
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 65,000
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 65,000
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> UNIQUE indexes or constraints per table
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 30,000
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 30,000
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Database size
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 32 TB (also limited by file system and OS)
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 32 TB (also limited by file system and OS)
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Identifier length (in characters)
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 255
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 255
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Locks per connection
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2,147,483,647
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> N/A
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Rows per table
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2,147,483,647
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2,147,483,647
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Tables per database
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2,147,483,647
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2,147,483,647
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Bytes per page
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 65,536
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 65,536
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Pages per database file
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2,147,483,647
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2,147,483,647
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Connections per database
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Maximum value of configured connections before creating database file (up to 2,147,483,647)
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 1
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> Records in transaction
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2,147,483,647 (also limited by available RAM)
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2,147,483,647 (also limited by available RAM)
<br>
</span></td></tr><tr><td align="left" valign="top" width="182">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> In-memory table size
<br>
</span></td><td align="left" valign="top" width="206">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2,147,483,647 (also limited by available RAM)
<br>
</span></td><td align="left" valign="top" width="214">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"> 2,147,483,647 (also limited by available RAM)
<br>
</span></td></tr></table>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="15"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="15"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></td></tr></table><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>

<br>
</span></span>

<!--#include virtual="/inc/footer.php"--> 
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -