Re: Performance problem in sql ce

Even though you're using "Proper indexing" (I'm not sure what this
means), are you sure that they're being used?

Query optimizers aren't perfect and sometimes get confused.

Try experimenting with your queries by elminating tables and joins
until performance improves. Try running it on the desktop and seeing
if you have the same issues there. If so, you can look at the
"Execution Plan" to see if it is indeed using an index where is should
be.
.

Loading