Ok, thanks Cableguy.. Just for infos, i've tried these things :
1. Convert csv file format (one column) (6000 records) to sql format and then load it to table (cmd.executetable) --> Took 31 seconds. :sign0148:
2. Load csv with (one column) (6000 records) to table control (without configfile) --> only took < 3 seconds. (WoooWWW...)
3. Load csv with (one column) (6000 records) --> same file as number #2 (6000 records) to table control (BUT this time with configfile) --> took 16 seconds.
Table control loads csv very fast... (without configfile, case #2) --> good for index list.
Sql allowed us to get the data that only needed at one time from large database (ex: when we select one item we want at index list). --> but sql need configfile (net frame 2) that makes table control loads csv so slow..
So, how to get this combining SPEED power of them?
(Tests above are done at ipaq 2750 624 Mhz, 128 RAM, WM 2003, Net cf2 installed)
Cheers.