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
