Database Query Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Noble Bell - 26 Jan 2010 14:56 GMT

I am working with a 2.0CF application that I wrote in C#. We are currently
using a database called VistaDB for it. We have tried SqlServerCE and there
were some memory leak issues that we could not get around. That is what
prompted us to go with VistaDB.

We have a bunch of data in the database and it takes an aweful long time to
do any querries against it. This was also true with sqlce so there is no
difference in speed there. The querries are optimized the best that I know
how to do and my database is normalized the best I can make it.

Is it best to load the result set of the query into objects on the device
side and place the objects into a list or is there a better, more efficient
and faster, way to handle result sets? It seems as the amount of data
increases in the database the speed at which querries are delt with decreases.

Signature

Noble D. Bell
www.noblesoftware.com

Reply to this Message

Peter Foot [MVP] - 29 Jan 2010 22:33 GMT

I'm not sure how VistaDB handles it but with SQL CE the ResultSet is a
direct cursor to the database which is much more efficient than filling an
in-memory structure like a DataSet. I'm not quite sure what memory leaks you
have encountered with SQL CE, I'm not aware of specific issues. What indexes
have you applied to your tables? An index applied to a field which is
regularly used in a query can greatly improve performance. As you can
imagine the specifics entirely depend on your database schema and how you
are querying the data.

Peter

> I am working with a 2.0CF application that I wrote in C#. We are currently
> using a database called VistaDB for it. We have tried SqlServerCE and
[quoted text clipped - 14 lines]
> increases in the database the speed at which querries are delt with
> decreases.

Reply to this Message