Issue #541 has been updated by Clément OUDOT. Status changed from New to Assigned Assigned to set to Clément OUDOT Target version set to 2.0.2
---------------------------------------- Bug #541: HSQL database performance with more 3072 lines http://tools.lsc-project.org/issues/541 Author: Frédéric POISSON Status: Assigned Priority: Normal Assigned to: Clément OUDOT Category: Administration Target version: 2.0.2 Problem in version: Hi, I have tested the db2ldap configuration with script hsqldb, and i encountered low performance on a CSV file with 10K rows, during synchronization. I read the hsql web site and i see that information (http://hsqldb.org/doc/guide/ch06.html) : "Text table source files are cached in memory. The maximum number of rows of data that are in memory at any time is controlled by the textdb.cache_scale property. The default value for textdb.cache_scale is 10 and can be changed by setting the property in the .properties file for the database. The number of rows in memory is calculated as 3*(2**scale), which translates to 3072 rows for the default textdb.cache_scale setting (10). The property can also be set for individual text tables: " So currently performance of hsql databases created with script hsqldb are ok under 3072 rows. I made a change on this script to calculate the cache_size parameter before inserting CSV data. I hope that patch could help, the project. Frederic -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://tools.lsc-project.org/my/account
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-dev mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-dev
