SqlCe Select Performance

  • Thread starter Thread starter Matze
  • Start date Start date
M

Matze

My select Queries always take the same time no matter how complex my
Queries get.
I always end up with 3-4seconds the first time I use the Select -
Command and 1Second on all following queries.
Do you have the same Performance? (Intel PXA 250 - 500 rows / 6 cols /
Index on queried Column)
I would now run all queries on startup once and hope to have the 1
Second Query-Duration for the Rest of the Connection - Lifetime. Do
you think this works?

Mathias Fritsch
 
the first time the cmd got executed. it pays the time to do cmd preparation
and that is the reason for the perf difference.

You may try add cmd.Prepare() before the first call to cmd.executeXXX() to
solve it.

Regards !

Yunwen Bai
Sql Server CE

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top