Dear Sir, As you advised we will keep the "key" as well documented.
Thank you Vikram A. ________________________________ From: Johan De Meersman <vegiv...@tuxera.be> To: Vikram A <vikkiatb...@yahoo.in> Cc: MY SQL Mailing list <mysql@lists.mysql.com> Sent: Tue, 9 November, 2010 7:05:39 PM Subject: Re: Best encription method? Seems like a better plan than simply rolling your own, yes. Do make sure that the key string is well-documented :-p On Tue, Nov 9, 2010 at 2:30 PM, Vikram A <vikkiatb...@yahoo.in> wrote: Sir, > >We have done a encryption by using our own algorithm. it works fine. But during >the report analysis we are facing the performance issue. Which is not >appreciated by our users. > > >We need only one column to be encrypted and the column size will never exceed 3 >chars. > > >We have planed to use the AES_ENCRYPT and AES_DECRYPT by using the "key string" >as a parameter. We can keep this key string as our security point. We found it >is giving better performance in all cases. > >Can i have your advise please? > >Thank you in advance! > >Vikram A > > > > >________________________________ >From: Vikram A <vikkiatb...@yahoo.in> >To: Johan De Meersman <vegiv...@tuxera.be> >Cc: MY SQL Mailing list <mysql@lists.mysql.com> >Sent: Wed, 29 September, 2010 11:46:18 AM >Subject: Re: Best encription method? > > >Sir, > >I must adopt the encryption. I shall bear the cost of the memory. >Thank you for the guidance. > >Vikram A > > > > >________________________________ >From: Johan De Meersman <vegiv...@tuxera.be> >To: Vikram A <vikkiatb...@yahoo.in> >Cc: MY SQL Mailing list <mysql@lists.mysql.com> >Sent: Tue, 28 September, 2010 2:08:57 PM >Subject: Re: Best encription method? > > > > >On Mon, Sep 27, 2010 at 3:43 PM, Vikram A <vikkiatb...@yahoo.in> wrote: > > >>Normally, If i need to store an integer value i have to define it as int, If I >>encrypt this, i must define its type as string of different size[it depend upon >>the encryption output] than its original size. It increases the db size. I am >>known that if it is secure i have to choose encryption. but when i choose >>encryption it leads the more memory usage. >> > >Well, yes :-) That's part of the price you're going to pay for the security. > >As the programmer said; I can make it better, faster and cheaper. Pick any two. > > >-- >Bier met grenadyn >Is als mosterd by den wyn >Sy die't drinkt, is eene kwezel >Hy die't drinkt, is ras een ezel > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
