December 1, 2010 at 3:55 am
Hi,
I have something a little bit different happening.
I have a .net framework application that runs 3 queries against a SQL CE 3.5 database (it runs more but the majority of processing is done by 3 queries) and 3 indexes for the queries.
The performance is ok nothing special, but as soon as I open a connection to the database via query analyzer 3.5 on the device and leave it open while the application is running the performance becomes outstanding, almost instantaneous. As soon as I close the query analyzer connection to the database the performance goes back to normal, I can open the connection from query analyzer while my app is running and notice improved performance straight away.
Can anyone explain why I am getting a performance boost when query analyzer is open? As I would love to have that sort of performance all the time not only when query analyzer is open.
Couple of notes:
- I am not running the queries in query analyzer I am running them from the application, all I am doing is opening query analyzer and opening a connection to the .sdf
- The connection string in my app specifies the max buffer size to around 8900 (I'm not sure why I inherited the app)
- Each query is within a using statement for the SqlCeCommand, therefore the command is created just before the query is run then disposed of straight after
December 12, 2010 at 7:18 pm
I have improved performance by removing a couple of sqlce result sets thus allowing me to remove the need for a max buffer size of 8192. Performance is better but I still don't understand why it becomes quicker when I open a connection to the database using query analyzer
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy