Re: Performance problem in sql ce

joker,

With a server database I'd agree with you, but on memory constrained devices like Gagan's and the amount of data he's working with, I don't think it's likely he'd get decent performance with that many joins using the query processor. Even with the approach he's using, he's still leveraging the indexes of the database, so that alone is a good reason not to use something like flat files or XML.

Ginny

"joker" <joker@xxxxxxxxxxx> wrote in message news:f76b3dd6-eca7-4812-bb3c-33dd375487ba@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
If this is how to solve sql performance problems, why bother using a
relational database at all?

You're better off figuring out why your initial query takes so long.
Restructure it or perhaps break it into 2 queries, but to do this is
quite rediculous.

--

Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Software for Waste Management



.

Loading