Client Device Database Performance Issues after Primary Key Changed to Composite

Problem: You observe client device database performance issues.

Explanation: If the MBO's single attribute primary key is changed to a composite primary key, Unwired WorkSpace automatically generates redundant object queries for each added primary key attribute with Create Index selected. This behavior causes client device database performance issues.

Solution: For a findByPrimaryKey object query with multiple primary key attributes, remove the redundant findByPrimaryKey queries.

For any object query, check if the index or indices are needed and remove the unnecessary index or indices

Related concepts
AutoCommit Option in JDBC Attributes or Operations
Related tasks
Unwired WorkSpace Crashes When Previewing or Test Executing Large Amounts of Data
Cannot Start Unwired WorkSpace After Upgrade
Cannot Access sampledb
Cannot Access Sample Database After Switching Network Types
Data Source Connection Fails After Installing to a New Directory
Related reference
MS SQL Server Connection Errors
Mobile Business Object Errors
Preview Errors for a Web Service Mobile Business Object
Compiler Errors When Deploying Device Applications
Deploying to Unwired Server Fails
Deploying to Unwired Server in a Cluster Fails
Data Truncation for Attributes without Explicit Length
Input Parameters Fail to Generate for Complex Data Sources