Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL CE 3.5 query performance Expand / Collapse
Author
Message
Posted Wednesday, December 1, 2010 3:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 22, 2011 4:59 AM
Points: 6, Visits: 21
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

Post #1028504
Posted Sunday, December 12, 2010 7:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 22, 2011 4:59 AM
Points: 6, Visits: 21
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
Post #1033544
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse