TDV users may see the following warning when using the option 'Use Default Cache Database' for a view in TDV Studio >> Caching >>Status tab

Performance issue: The data source used for caching has settings that differ from the Server settings
The Trailing Spaces setting on this data source does NOT match the Server settings.
The Case Sensitivity setting on this data source does NOT match the Server settings.
Significant performance and data issues may result if this is not corrected.

All supported operating systems

Follow the steps below to resolve this issue  :

1) Browse to the folder [TDV Installation folders]\conf\adapters\system\<adapter name>

Example: TDV>>INSTALL>\conf\adapters\system\postgresql_9_1

2) Open the adapter settings file  <adapter name>_values.xml in a text editor like Notepad. 

Example: open the file "postgresql_9_1_values.xml".

3) In the xml file, cut and paste the following xml attribute block to the top (i.e outside the commented block but under the <common:attributes xmlns:common="http://www.compositesw.com/services/system/util/common"> tag).
Note: This block may already be in the commented-out section; if it is, then you can also obtain it from there:
 

<ns8:attribute xmlns:ns8="http://www.compositesw.com/services/system/util/common">
<ns8:name>/runtime/query/comparisonCaseInSensitive</ns8:name>
<ns8:type>BOOLEAN</ns8:type>
<ns8:value>true</ns8:value>
<ns8:configID>jdbcds.comparisons_case_insensitive</ns8:configID>
</ns8:attribute>

The value of this xml attribute can be set to true or to false in the pasted block as needed to match the server settings. To see the server setting, open TDV Studio and browse to  Administration >> Configuration >> and type 'case sensitivity' in the Find box.

4) Similarly, in the xml file, cut and paste the following xml attribute block (this block may already be in the commented-out section; if it is, then you can also obtain it from there):
 

<ns26:attribute xmlns:ns26="http://www.compositesw.com/services/system/util/common">
<ns26:name>/runtime/query/trailingSpaceIncludeInComparison</ns26:name>
<ns26:type>BOOLEAN</ns26:type>
<ns26:value>false</ns26:value>
<ns26:configID>jdbcds.trailing_spaces_included_in_comparison</ns26:configID>
</ns26:attribute>

The value of this xml attribute can be set to true or to false in the pasted block as needed to match the server settings. To see the server setting, Open TDV Studio and browse to  Administration >> Configuration >> and type "trailing spaces"  in the Find box. 

5) Restart the TDV Server services for the changes to take effect.

This article explains the steps to resolve the performance issue for default cache database.