How much data would SQL Mobile be able to handle?

[dha...@gmail.com]

Hi all,

we have a system where users need to be authenticated in a windows
mobile based applciation. this has to be offline database (user db
stored in device).

I'm just wondering if anyone can help me identify if it would be a good
idea to store user's data in device. Given that a user's record
consumes 100 bytes of memory,
1) how many records would a typical SQL Server mobile edition would be
able to store efficiently?
2) if I have 80,000 users, how long would it take to authenticate one
user. given that i used dot net compact framework to program.

cheers!
d2

[Ginny Caughey [MVP]]

The limit for a SQL Mobile database is 4 gb, so unless my math is wrong, you
shouldn't have any problems at all with 80,000 records of that size assuming
you enough space on the device. I have a production app that handles 65,000
records and on a mobile device seeking to a unique key using the table's
index is almost instantaneous. One thing I have found with big databases is
that sometimes queries get very slow because the query processor apparently
wants more memory for its own work than I have available. I've been able to
reduce a 30-minute query to well under a second by switching from using SQL
syntax to TableDirect in situations like that.

--
Ginny Caughey
Device Application Development MVP

<dha...@gmail.com> wrote in message
news:1154328528....@b28g2000cwb.googlegroups.com...

[Ginny Caughey [MVP]]

One other point with large amounts of data - don't try to load all that data
into a DataSet. Use SqlCeResultSet and only load the data you need at any
given point in your app.

--
Ginny Caughey
Device Application Development MVP

<dha...@gmail.com> wrote in message
news:1154328528....@b28g2000cwb.googlegroups.com...

[dha...@gmail.com]

Thanks Ginny.

This will help me design my app better.

Regards,
d2