SQL CE Encryption

The entire database is encrypted when you encrypt a SQL Mobile or CE
database, so you don't need to worry about how JOINs or indexes work - the
database takes care of it.

My performance tests indicate less than 10% performance hit, but
realistically if you need encryption, then you need it and must use it.

--
Ginny Caughey
Device Application Development MVP


"joe_w" wrote in message
news:1154561054.616752.173150@m73g2000cwd.googlegroups.com...
> We are using Mobile 5.0 Devices and need to start encrpting our
> database. Does anyone know what the performance hit is when you encrypt
> the database? We have a 20 or more tables within a database with a
> total SDF foot print of about 80MB. More than what can fit in memory so
> we keep it on an SD card.
>
> The main concern to me is how does the database handle primary key and
> other indexes when you want to "Join" tables since the data is all
> encrypted? I'm assuming you still can have indexes on your tables and
> somehow they get rebuilt or decrypted after the database is open.
>