I am working on WM 6.0 MC75 device. I am creating database using SQL compact server 3.0.
I have almost 30K records in device. When I execute simple query with Order BY it takes almost a minute to fetch data.
Then I used index for where clause. It becomes fast and the time reduced to 7-8 sec.
But it creates problem in Insert/Update. As this takes ____ of time in inserting data to table. I dont know how to proceed further. As i stucked here.
Please give ma a direction
View Complete Post