You might consider a "translucent" database, that is the record is partially encrypted, with the key and non-critical data remaining in the clear. This facilitates fast lookups and enables sorting. Search Amazon for the book "Translucent Databases" by Peter Wayner.
As for the lack of speed, it depends on the algorithm you are using. For handheld devices with modest cpus, you should use stream encryption rather than block (e.g.: 3-DES algorithm). Lastly, depending how much security you need, you could use hidden and masked record techniques. --Mike Y. http://www.ytechnology.com >>>>>>>>>>>>>>>>>>> "Jefferson Samuel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hello All, I have functions to encrypt-EN() & decrypt-DE() a record in the palm database. I have a function NewRecord(Char *col1,Char *Col2) to insert the values to the database. I want the records to be stored in the Encrypted form. EG: NewRecord(Char *col1,Char *Col2) ---------- NewRecord("Hello","Hai"); NewRecord(): 1) Find the Sort Position. (Not possible b'coz records are in encrpyted, so How can I compare records? ) 2) Encrypt col1 & col2 and store it in ENcol1 & ENcol2 3) Store the ENcol1 & ENcol2 in the sort position retrived from step 1. When showing the records: DmQueryRecord() retrives the Encrypted data. This has to be Decrypted. Retriving 10 records and decrypting them takes a long time. Please give me your suggestions. When excatly should I encrypt & decrypt my records ? Appericate your time. with regards Jeffy -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
