June 20, 2013 at 8:56 am
I have a client who needs a vb.net program written for a handheld device with Windows CE 5.0 to query a table that has 10 million records in it. Can it hold this many records? If not, should I divide the data up to multiple tables and search different ones? What do you suggest? What is the limit? 4gb per table or overall?
Thanks!
Warren
June 20, 2013 at 9:03 am
well, who in your company has a windows handheld device, vs having an android or iphone/ipad? in my shop of 30 developers, there are no windows based portable devices.
I would question whether you want to even bother developing it; something that is going to touch a four gig local file/database is going to be painfully slow , no matter the processing power.
I'd reconsider the project, and build a web interface that accesses the data in SQL server, in a single central location, instead;
a web based app would be accessible to many more platforms, and involve a single code base, instead of developing for Windows + CE, and then Android + SQLite, and then Iphone, blackberry, etc.
Lowell
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy