How to improve database searhing performance?

Hi, I am using compact framework 1.1 and SQL CE database for my mobile application. My database has a total of 160000 rows of records and whenever i do a query searching, it will take about 20 seconds to look through the whole database if the record does not exist. Is there any method to improve the searching performance? i am using data reader for the query.

Thanks.

If you are using SQL statements now, consider using Seek/SetRange using an index. More information at http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlcedatareader.seek.aspx

How to import data into SQL Server 2005 Mobile Edition database?

There are any import/export utilities for SQL Server 2005 Mobile Edition database? Which edition of SQL Server 2005 can do this?

Or we must use publication/subscription to transfer data to the mobile database?

Thank you for your help!

I am waiting for a solution to this .. :)|||You should be able to use DTS for this (other than using your own home-bew code for that). I have developed a set of tools (commercial) that will help you to do that. You can get them from here.|||I had very little luck with DTS. There are so many disconnects in regards to datatype conversions that it was easier to roll my own solution. I understand this is being addressed in a future SP.|||

Thank you for your help!

But I am still finding some methods which use microsoft utilities is enough to do the import/export for the SQL Server 2005 Mobile Edition database.

|||

Hello Jo?o Paulo

Can you point any link in Microsoft (or other site) website for us to create a DTS that perform this export / import information?

I don't have the resources to buy your tools then I have to create something like that.

Can you help me?

Regards
Paulo Aboim Pinto
Odivelas - Portugal