Today, I am going to do webcast online on how to improve performance for SQL CE. Here are three articles which I am going to base my session.
Database Design and Performance (SQL Server Compact Edition)
- Use Database Denormalization
- Decide Between Variable and Fixed-length Columns
- Create Smaller Row Lengths
- Use Smaller Key Lengths
- Publication Article Types and Options
Query Performance Tuning (SQL Server Compact Edition)
- Improve Indexes
- Choose What to Index
- Use the Query Optimizer
- Understand Response Time vs. Total Time
- Rewrite Subqueries to Use JOIN
- Use Parameterized Queries
- Query Only When You Must
Optimizing Connectivity (SQL Server Compact Edition)
- Synchronization Time-Out Properties
- Time-out Optimization
I found above articles very interesting and useful, and looking forward to your opinion on the same.
Reference: Pinal Dave (https://blog.sqlauthority.com)
1 Comment. Leave new
Excellent !! I enjoyed.
I just didn’t understand “Under Parametrized query ”
” If you must run several parameterized queries in interleaved manner, you can create several command objects, each caching the execution plan for a parameterized query. This way, you effectively avoid re-compilations for all of them.”
from this link
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms172984(v=sql.90)
Can anybody explain with complete and suitable example ?what is meant by “several command object” ?