Hello my friends.
I'm programming a store management for POS device with "Windows CE 6.0". These device are so low. The ram in these device is the hard :-(.
Now, I have 15000 record and wana select records where the "CategoryCode column" value is '445500' (Count of these record is 50).
I use different ways to select the data:
1. SQL CE3.0
For connect to bank get 4sec
For execute WHERE command
get 8sec
2. I create a library (
DotTxt[
^]) that work with text file.
For execute WHERE command
get 6sec
3. Using XML
For open XML document
get 32sec
For execute WHERE command get 1sec
4. Using DataTable (that fill with a text file)
For retrieve lines in DataTable get 13sec
For excute WHERE command (select)
get 3sec
Each of these ways have an problem. I bold them.
Please help me to work with a better way for better speed.
Thanks your helps.