 |
 |
 |
|
|
|
 |
Site Index |
 |
1. Minimizing the number of connections. a) use TcsQuery.CacheAllRecords=TRUE for all small result sets. You will have to tune your application choosing between an increased .Open processing and a minimum of concurrent connections. b) use TcsDatabase.KeepConnection=FALSE to make SQLQuery to drop the database connections as fast as possibly. 2. Maximizing performance a) use TcsQuery.CacheAllRecords=FALSE (the default) for all datasets. Consider using AsyncOpen to asynchronously open several queries. b) make sure TcsDatabase.KeepConnection=TRUE to minmize the number of times SQLQuery needs to acquire a new connection. Home
| News
| Products
| Download
| Support |
