|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|
||||||||
|
|||||||||
|
|
|
|
Company
|
|
 SQL LINKS DEVELOPER SUPPORT
SEARCH Borland Online/Developer Support
SQL server specific speed tips ALL DRIVERS ENABLE SCHEMA CACHE, SCHEMA CACHE DIR Enabling and setting the SCHEMA CACHE/SCHEMA CACHE DIR BDE driver parameters can improve application performance by reducing the time spent by the BDE and SQL Links requesting database and table schema info from your server. It is important that the remote schema remain static because the BDE does not "refresh" the local schema info for obvious reasons. BATCH COUNT: The BATCH COUNT controls the number of rows processed in a single transaction in a BatchMove operation. Adjusting this parameter will also affect the performance of the Data Migration tool. Explicit Transaction control: Using explicit Begin Transaction and End Transaction in your application can be much faster than relying on the BDE SQL Links to control transactions (AUTOCOMMIT). For explicit transaction control use the BDE Configuration utility to set the SQLPASSTHRU MODE parameter to SHARED NOAUTOCOMMIT for your Database Alias and control transactions explicitly in your application by using BEGINTRANSACTION, COMMIT and ROLLBACK. LOCAL SHARE: Set LOCAL SHARE = False on the System page in the BDE configuration utility. This option needs to be set to TRUE only if both BDE and non BDE applications are accessing dBASE or Paradox tables simultaneously. All Borland products use the BDE to access Paradox and dBASE tables, so this option should usually be FALSE. MSSQL and SYBASE drivers TDS PACKET SIZE: Verify that this parameter is set to at least 4k (4096). Increasing this setting can further improve performance. Additional information on setting the TDS PACKET SIZE parameter can be found in the SQLLNK32.HLP file. DRIVER FLAGS: Check to make sure that the DRIVER FLAGS parameter is set to 0 (on driver page of BDE Configuration utility). If it is 2048, queries will execute in Asynchronous mode, which can be very slow. ORACLE, DB/2 and BDE ODBC Socket Tuning the ROWSET SIZE parameter for the alias or the driver in the BDE Configuration utility will specify how many rows are fetched or inserted in a single Server operation. PUB ALL TECH BC
|
|
||
|
|
|
|||
|
|||||
|
|
||||
 |
|||||
|
|||||
| Made in Borland® Copyright© 1994-2003 Borland Software Corporation. All rights reserved. Report Piracy, Legal Notices, Privacy Policy Last Modified Monday, 26-Mar-2001 16:27:08 PST |
|||||
